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

4 votes190 views4 answers
Update select mysql
SQL
1 vote182 views1 answer
Set statiscis on in sql server
SQL
0 vote192 views1 answer
Connect to ssms with python
SQL
7 votes202 views1 answer
Oracle pagination query offset
SQL
11 votes205 views1 answer
Oracle insert into where
SQL
0 vote193 views1 answer
Postgres week number
SQL
0 vote196 views1 answer
How to print mysql query of codeigniter query builder
SQL
5 votes196 views1 answer
Purge undo tablespace usage
SQL
2 votes204 views1 answer
Oracle sql merge
SQL
0 vote208 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL