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 vote119 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
1 vote160 views1 answer
Ora-01950 no privileges on tablespace
SQL
6 votes140 views1 answer
To count number of rows in SQL table
SQL
0 vote125 views1 answer
Setval in postgres
SQL
0 vote112 views1 answer
Sql server inner join convert collation
SQL
3 votes111 views2 answers
Laravel tosql with bindings
SQL
17 votes118 views6 answers
Change column name in sql
SQL
17 votes145 views1 answer
Selecting name that contain certain word in sql
SQL
1 vote102 views1 answer
Tsql random number
SQL
8 votes128 views1 answer
Insert a select statement into a table
SQL