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 vote213 views1 answer
Mysql view current queries
SQL
0 vote193 views1 answer
Kill slow queries mysql
SQL
0 vote192 views1 answer
How to query all tables mysql at the same time
SQL
2 votes179 views1 answer
Anonymous block plsql
SQL
1 vote203 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote188 views2 answers
How to generate a unique random number in mysql
SQL
0 vote195 views1 answer
Netstat -tln mysql
SQL
0 vote194 views1 answer
Modifier une valeur sql
SQL
1 vote188 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
4 votes188 views2 answers
Oracle default date format
SQL