Answers for "mysql show grants for user on all hosts"

SQL
2

mysql grant all privileges to user from any host

GRANT ALL PRIVILEGES ON database_name. * TO 'username'@'localhost';
Posted by: Guest on August-24-2020
2

create mysql user on all hosts

CREATE USER 'newuser'@'%' IDENTIFIED BY 'user_password';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%';
SHOW GRANTS FOR 'newuser'@'%';
FLUSH PRIVILEGES;
Posted by: Guest on May-14-2021

Code answers related to "mysql show grants for user on all hosts"

Code answers related to "SQL"

Browse Popular Code Answers by Language