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.

 

Esta resposta foi útil? 0 Utilizadores acharam útil (0 Votos)