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.

 

Ha estat útil la resposta? 0 Els usuaris han Trobat Això Útil (0 Vots)