How to create a MySQL database, username, password and privileges from the mysql command line

December 15, 2013 at 4:23 pm (last edited December 15, 2013 at 4:36 pm)

root@server [~]# mysql

Create the Database

mysql > create database cleint_dbname;

Create the User

mysql > create user cleint_dbuser;

Grant privileges for this chain database + database username + password

mysql > grant all on client_dbname.* to client_dbuser@localhost identified by 'db_password';

If you are using cPanel run setupdbmap script to update just created mysql data

/usr/local/cpanel/bin/setupdbmap