Grant All Privileges to Database Mysql User



 mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' WITH GRANT OPTION; 


 >
GRANT ALL PRIVILEGES ON database.* TO db_user @'%' IDENTIFIED BY 'db_password'; 


 > GRANT ALL PRIVILEGES ON database.* TO db_user @'localhost' IDENTIFIED BY 'db_password';


 > GRANT ALL PRIVILEGES ON database.* TO db_user @'' IDENTIFIED BY 'db_password';


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

Make Donation

  • Other: $

Donate now