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

10 votes258 views4 answers
How to alter table name in mysql
SQL
1 vote247 views1 answer
Give a column name to values generated from case statement in sql
SQL
1 vote264 views1 answer
Flask sqlalchemy default value
SQL
0 vote262 views3 answers
Database restoring error
SQL
14 votes268 views3 answers
Alter foreign key
SQL
0 vote272 views1 answer
Sql convert unix time to date
SQL
1 vote238 views4 answers
Fatal database postgres does not exist
SQL
0 vote254 views1 answer
Sqlite higher or equal
SQL
0 vote267 views1 answer
PSQL use LIKE with timestamps
SQL
5 votes243 views4 answers
Describe table postgres
SQL