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 votes140 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote159 views1 answer
Get created time of database psql 8
SQL
0 vote140 views1 answer
Char vs varchar2 in sql
SQL
0 vote138 views1 answer
Oracle list datafiles
SQL
0 vote171 views1 answer
Inner join distinct
SQL
-1 vote95 views1 answer
Mysql how to set update or create
SQL
8 votes130 views3 answers
Postgresql connection string c#
SQL
2 votes142 views2 answers
Mysql count rows returned
SQL
0 vote154 views1 answer
Postgres get running query
SQL
0 vote143 views1 answer
Default value false mysql
SQL