Create MYSQL User and Assign Privileges Command Line, Add New User in Mysql, Assign Privileges to Mysql User

Create MYSQL User and Assign All Privileges

Login as Root User in Database use database. And type the following command line.

 mysql> GRANT ALL ON database TO user@'%' IDENTIFIED BY 'Password'; 

mysql> GRANT ALL ON database TO user@'localhost' IDENTIFIED BY 'Password'; 


Create MYSQL User and Assign Privileges Linux Command Line ,
Create MYSQL User and Assign Privileges Putty Command Line

If You Think This Post has helped you buy us a Coffee :)

Make Donation

  • Other: $

Donate now