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.

 

Was this answer helpful? 0 Users Found This Useful (0 Votes)