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

1 vote324 views3 answers
Union in sql
SQL
1 vote309 views1 answer
How to get mysql db size
SQL
2 votes306 views1 answer
Possgress drop if exists table
SQL
1 vote310 views2 answers
Select only columns that are not empty oracle sql
SQL
0 vote317 views1 answer
Mysql select field if condition
SQL
7 votes303 views1 answer
Query delete duplicates
SQL
0 vote323 views1 answer
How to add unique key constraint in mysql
SQL
0 vote308 views1 answer
Oracle create package specification
SQL
4 votes318 views2 answers
Postgres update single column
SQL
0 vote311 views1 answer
Truncate a table then insert data
SQL