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

Login to MySQL with root privileges

[email protected] [~]# 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 [email protected] identified by 'db_password';

 

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

/usr/local/cpanel/bin/setupdbmap

 

Similar Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *