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

1 vote121 views1 answer
Postgresql last element of array
SQL
0 vote178 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote186 views1 answer
Renommer base sql
SQL
45 votes256 views5 answers
Grant all privileges mysql
SQL
8 votes288 views2 answers
Oracle auto increment primary key
SQL
0 vote171 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote158 views1 answer
Oracle query archive mode
SQL
-1 vote185 views1 answer
Mysql extract days
SQL
0 vote203 views1 answer
How to check database engine in mysql
SQL
4 votes173 views3 answers
How to describe a table in sqlite3
SQL