In order to grant access to a user over an existing database on your MySQL server, start the "mysql" command-line client and execute the following query:

GRANT ALL PRIVILEGES ON 'testuct_db'.* TO 'cb'@'localhost';

 

Here,

"testuct_db" is the name of the databases. And "testuct_db".* syntax means to grant access on all tables in that database.

 

Cette réponse était-elle pertinente? 0 Utilisateurs l'ont trouvée utile (0 Votes)