/SQL/Mysql user access to database

Mysql user access to database

Mysql user access to database

GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' IDENTIFIED BY 'password';

2

Source: stackoverflow.com

Grant user all privileges

mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

0

Source: chartio.com

Similar codes

13 votes172 views6 answers
Restart postgresql
SQL
5 votes165 views2 answers
Copy data from one database to another
SQL
0 vote193 views1 answer
Check if mysql db is used
SQL
0 vote170 views1 answer
Gcloud sql instance list
SQL
1 vote190 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
1 vote187 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
1 vote219 views1 answer
How not to sort by average rating
SQL
0 vote170 views1 answer
Group by sql not ordering issues
SQL
23 votes179 views4 answers
How to uninstall postgresql in ubuntu
SQL
11 votes187 views3 answers
How to get last row of table in sql
SQL

Share