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

5 votes310 views2 answers
Sql number columns
SQL
12 votes308 views10 answers
Google
SQL
0 vote299 views1 answer
Less than and between in sql query
SQL
-1 vote282 views1 answer
Io
SQL
0 vote290 views2 answers
Sql use not in
SQL
1 vote323 views3 answers
How to pass password to mysql command line
SQL
0 vote297 views1 answer
Day of the week sqlite
SQL
6 votes296 views2 answers
Where clause in sql
SQL
16 votes277 views2 answers
Gremove folder from git
SQL
0 vote296 views1 answer
Ksql quickstart docker
SQL