Answers for "mysql grant specific privileges on tables"

SQL
0

mysql grant grant option

GRANT ALL ON *.* TO 'user'@'localhost';

GRANT GRANT OPTION ON *.* TO 'user'@'localhost';
Posted by: Guest on May-29-2020
0

mysql grant access to one database

//create the user:
CREATE USER 'user'@'hostname' IDENTIFIED BY 'password';

//give it access to the database dbTest
GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' ;
Posted by: Guest on July-21-2021

Code answers related to "mysql grant specific privileges on tables"

Code answers related to "SQL"

Browse Popular Code Answers by Language