SANGKRIT

MySQL Client : Creating Database

Creating Database and User is fast and easy by running MySQL from Shell.

  • $ mysql -u adminusername -p
  • Enter password:
  • Welcome to the MySQL monitor. Commands end with ; or g.
  • Your MySQL connection id is 5340 to server version: 3.23.54
  • Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.
  • mysql> CREATE DATABASE databasename;
  • Query OK, 1 row affected (0.00 sec)
  • mysql> GRANT ALL PRIVILEGES ON databasename.* TO “wordpressusername”@”hostname”
  • -> IDENTIFIED BY “password”;
  • Query OK, 0 rows affected (0.00 sec)
  • mysql> FLUSH PRIVILEGES;
  • Query OK, 0 rows affected (0.01 sec)
  • mysql> EXIT
  • Bye
  • $

Leave a Reply