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

2 votes333 views2 answers
Postgres select duplicate columns
SQL
14 votes360 views3 answers
Trim sql
SQL
0 vote315 views1 answer
How to get n result in sql
SQL
0 vote340 views1 answer
T-SQL Never ending DELETE
SQL
5 votes359 views2 answers
Mysqldump password
SQL
0 vote365 views1 answer
Sql select column name like from multiple tables
SQL
8 votes349 views3 answers
Connect python to mysql
SQL
0 vote321 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote298 views3 answers
Mysql calculate age from date of birth
SQL
0 vote380 views1 answer
Use mysql in java program
SQL