Main menu

Skip to content

CYBR's Blog

Digital deep sea diving

RSS

Tag Archives: mysql

Create mysql database, user and grant permission

Posted by cbrunsch on May 24, 2011

I just can’t remember these commands

mysql> create database mydb;

mysql> create user newuser@'192.168.1.2' identified by '-Pas$w0rd-';
mysql> grant all privileges on mydb.* to newuser@'192.168.1.2';
mysql> flush privileges
Leave a comment Posted in Maintenance Tagged database, mysql, sql

Recent Posts

  • OpenShift – git push your webpage to the cloud
  • Create a new VM from a non-Proxmox appliance template
  • Reversing in God Mode
  • BeanShell puts Java Application Servers at Risk
  • AES Maths (Rijndael multiplication)

Categories

  • Advisories (13)
  • Cloud (1)
  • Cryptography (1)
  • Embedded (1)
  • Maintenance (19)
  • Multimedia (5)
  • Programming (8)
  • Reversing (1)

alternatives amavis apache arch arm awk backup bash cag centos chkconfig cisco citrix clone compiler composite convert cortex database date dnat error forensic gcc gnu google grub http imagemagick iptables java jboss jvm kernel lame linker linux logging LPC1768 mod_rewrite mp3 mysql nortel ntp opencms openkm openvz oracle pebble perl postfix redirect resume rpmforge sap sed seo service spam spider sql suspend tcp template timestamp timezone toolchain ubuntu update uuencode vzdump wav windows xsrf xss

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy