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

24 votes138 views6 answers
Replace mysql
SQL
5 votes145 views3 answers
Sql server utc to local
SQL
0 vote150 views1 answer
Play framework connection via windows sql server
SQL
0 vote134 views1 answer
Postgres can integer fields be negative
SQL
1 vote132 views1 answer
Truncate left characters mysql
SQL
0 vote147 views1 answer
Mssql + bit + in python orm
SQL
10 votes129 views6 answers
Mysql delete duplicates
SQL
0 vote142 views1 answer
Postgresql print variable
SQL
0 vote135 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote133 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL