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

7 votes195 views1 answer
Append column sql
SQL
0 vote197 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote203 views2 answers
Generate sql trigger through ef migration
SQL
0 vote216 views1 answer
Intellij idea add mysql connector
SQL
0 vote221 views3 answers
How to assign custom id in mysql
SQL
3 votes195 views1 answer
Oracle transaction commit rollback example
SQL
1 vote205 views1 answer
Sqlite check if row exists
SQL
0 vote721 views1 answer
T sql less than date
SQL
0 vote225 views1 answer
How to run mysql on terminal mac
SQL
2 votes331 views1 answer
Mysql create user with remote access
SQL