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 vote227 views1 answer
Mysql row generator
SQL
0 vote238 views1 answer
Drop database using terminal postgres
SQL
1 vote214 views2 answers
Mysql trim whitespace
SQL
18 votes242 views3 answers
Get the list of all tables in sql server
SQL
0 vote236 views1 answer
Remove transient options sql wordpress
SQL
0 vote220 views1 answer
Mysql create table like
SQL
0 vote244 views1 answer
Mysql update from select on same table
SQL
0 vote226 views2 answers
Close external port 3306 with iptables
SQL
13 votes212 views2 answers
Display users in mysql
SQL
2 votes234 views1 answer
Query to check cpu utilization in oracle database
SQL