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 vote130 views1 answer
Pl sql disable trigger
SQL
0 vote115 views1 answer
Select value from previous row in postgresql
SQL
1 vote154 views3 answers
Postgresql crete view
SQL
0 vote144 views1 answer
Remove transient options sql wordpress
SQL
17 votes148 views2 answers
Mysql date to string
SQL
0 vote146 views1 answer
Running percentage of total postgres
SQL
0 vote146 views1 answer
Sql insert from excel
SQL
0 vote129 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote94 views1 answer
Expose db in virtualbox
SQL
0 vote137 views1 answer
If column value is null then in mysql
SQL