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 vote198 views1 answer
Python connect microsoft sql server
SQL
2 votes366 views5 answers
Unique in sql server
SQL
3 votes188 views4 answers
Stop MySQL
SQL
0 vote199 views3 answers
How to increase size of column in sql
SQL
6 votes183 views2 answers
Mysql version check cmd
SQL
-1 vote187 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
1 vote213 views1 answer
T-SQL / AZURE Reseed
SQL
1 vote205 views1 answer
Age postgres
SQL
51 votes633 views6 answers
Installing mysql on ubuntu
SQL
0 vote199 views1 answer
Import sql in postgresql
SQL