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

11 votes215 views2 answers
Sql rank
SQL
17 votes200 views5 answers
Order by sql
SQL
0 vote170 views2 answers
Postgresql change user role grant
SQL
1 vote272 views4 answers
Alter schema sql
SQL
0 vote197 views1 answer
Sql remove non numeric characters
SQL
0 vote189 views1 answer
Mysql get last 2 month data
SQL
1 vote198 views1 answer
Postgres see sequence current state
SQL
4 votes170 views3 answers
Mysql update with join
SQL
0 vote199 views1 answer
T-SQL Never ending DELETE
SQL
0 vote167 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL