Command line instructions to create a database in MySQL

$ mysql -u ”adminusername” -p


  1. mysql> CREATE DATABASE ”databasename”;
  2. mysql>
    grant all privileges on db_name.* to 'db_user'@'localhost' identified by 'db_password';
    
  3. mysql> FLUSH PRIVILEGES;
  4. mysql> EXIT

Report this snippet   Continue reading

Advertisements