How to create a MySQL database, username, password and privileges from the mysql command line
Login to MySQL with root privileges
| 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.*