MySQL: Grant **all** privileges on database

At mysql prompt as root user:

 GRANT ALL privileges ON *.* TO ‘user’@’machine.lan’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;

 FLUSH PRIVILEGES;

 

That’s all

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.