Allow external access to mysql

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Source: stackoverflow.com

Similar codes

0 vote153 views1 answer
Sql date with year
SQL
0 vote122 views4 answers
Sql year
SQL
0 vote147 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
10 votes125 views2 answers
Tsql merge example
SQL
-1 vote123 views5 answers
Online sql to linq generator
SQL
3 votes135 views2 answers
How to delete git repo locally
SQL
1 vote115 views1 answer
Stop mysql server mac
SQL
10 votes132 views4 answers
Mysql one week ago
SQL
4 votes83 views1 answer
And or sql order of operations
SQL
3 votes150 views5 answers
Duplicate table sql
SQL