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

1 vote163 views2 answers
Rebuild index sql server
SQL
0 vote161 views1 answer
Raiserror nowait sql server
SQL
0 vote156 views1 answer
Automate mysql cli query
SQL
0 vote175 views1 answer
Postgres get database encoding
SQL
2 votes180 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote167 views1 answer
Sqlite referential integrity
SQL
8 votes184 views1 answer
See all users mysql
SQL
0 vote180 views1 answer
Create schema sql server
SQL
2 votes163 views6 answers
In in sql
SQL
0 vote221 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL