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 votes259 views2 answers
Sql server check port number
SQL
1 vote249 views1 answer
GROUP BY clause; this is incompati
SQL
2 votes253 views1 answer
Select from array in psql
SQL
0 vote255 views1 answer
Change default schema sql server
SQL
1 vote277 views1 answer
Mysql search like order by best match
SQL
0 vote265 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote267 views1 answer
Import big data to mysql
SQL
1 vote242 views1 answer
Minus vs intersect in sql
SQL
8 votes266 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote212 views1 answer
Copy table dbeaver
SQL