Connect to mySQL server as root from console by type
[root@vpshelpdesk]#mysql -u root -p
Create a mySQL database from console by type this
mysql>CREATE DATABASE dbuser;mysql>CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; mysql>GRANT ALL PRIVILEGES ON dbuser.* TO 'user'@'localhost' WITH GRANT OPTION; mysql>CREATE USER 'user'@'%' IDENTIFIED BY 'password'; mysql>GRANT ALL PRIVILEGES ON dbuser.* TO 'user'@'%' WITH GRANT OPTION; mysql>FLUSH PRIVILEGES; mysql>SHOW GRANTS FOR 'user'@'localhost';
![]()
Displaying list of users, use the SELECT USER statement
mysql>SELECT USER FROM mysql.user;
To remove an account, use the DROP USER statement
mysql>DROP USER 'user'@'localhost';
Displaying list of all databases, use the SHOW DATABASES statement
mysql>show databases;
To remove an database, use the DROP DATABASE statement
mysql>DROP DATABASE dbuser;
1 thought on “Create mySQL User Grant PRIVILEGES to Database”