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 vote358 views1 answer
Sql check for null and empty string
SQL
1 vote330 views1 answer
MySQL AND Operator
SQL
0 vote365 views1 answer
Oracle webcenter content search enginer
SQL
0 vote382 views1 answer
Oracle last connexion
SQL
1 vote347 views1 answer
Set statiscis on in ssms
SQL
0 vote392 views1 answer
Sql select sum group by id laravel join
SQL
0 vote364 views1 answer
Mysql return column names when table is empty
SQL
3 votes341 views2 answers
Sqlite show table definition
SQL
0 vote342 views1 answer
Sql select all tables from database change url
SQL
2 votes342 views2 answers
Get all columns from table sql
SQL