Answers for "grant access to a database mysql"

SQL
24

mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
Posted by: Guest on March-18-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 "grant access to a database mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language