grant all – Blog

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.*