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' ;

Similar codes

0 vote289 views1 answer
Oracle procedure teamplate
SQL
8 votes281 views1 answer
Mac restore mysql database command line
SQL
0 vote306 views1 answer
Typeorm raw sql
SQL
0 vote298 views1 answer
Suse status MySQL
SQL
0 vote298 views1 answer
Sql delete from with relation
SQL
4 votes282 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote301 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote271 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote301 views1 answer
Postgresql on conflict pair
SQL
0 vote282 views1 answer
Add SuperUser MySQL
SQL