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 vote108 views1 answer
Select in select sql
SQL
1 vote115 views2 answers
Get table column names sql laravel
SQL
1 vote108 views1 answer
Group_concat order by
SQL
8 votes106 views2 answers
Select table column name in sql
SQL
1 vote107 views1 answer
How to drop function in sql
SQL
0 vote120 views1 answer
Mysql limit order by
SQL
0 vote120 views1 answer
Datatables server side filter where clause
SQL
0 vote124 views1 answer
Create dump file mysql workbench
SQL
5 votes74 views1 answer
Alter table default value mysql
SQL
8 votes114 views3 answers
Postgres connection string
SQL