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 vote274 views1 answer
Sample in sql
SQL
0 vote283 views3 answers
Mysql delete if not in another table
SQL
3 votes285 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote303 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
10 votes283 views4 answers
Inner join in update query mysql
SQL
0 vote311 views1 answer
Creating h2 database in relative directory eclopse
SQL
1 vote315 views1 answer
Update substring in mysql
SQL
0 vote272 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote290 views1 answer
Null column as zero in mysql
SQL
0 vote291 views1 answer
How to move a column to different spot mysql
SQL