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 vote189 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote178 views1 answer
Codeigniter dbforge add index
SQL
0 vote229 views1 answer
Redshift running queries
SQL
2 votes182 views2 answers
Get all columns from table sql
SQL
1 vote169 views1 answer
Mysql find tables with column name
SQL
0 vote193 views1 answer
Datagrip execute procedure
SQL
0 vote204 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
12 votes179 views4 answers
Psql command not found
SQL
2 votes177 views1 answer
Mysql clear screen
SQL
1 vote228 views1 answer
Oracle create program if not exists
SQL