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 vote372 views1 answer
Mysql Selected All Duplicate Rows
SQL
4 votes365 views2 answers
Convert utc to est sql
SQL
1 vote365 views2 answers
List tables sqlalchemy
SQL
0 vote363 views1 answer
Limiting query result using where in sql
SQL
0 vote408 views1 answer
What is metadata in sql
SQL
1 vote382 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
1 vote362 views1 answer
Mysql tables max count
SQL
2 votes399 views1 answer
Q operator in oracle
SQL
0 vote373 views1 answer
Oracle select partition
SQL
1 vote387 views2 answers
Extract weekday from date in sql
SQL