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

-1 vote144 views3 answers
My sql alter table
SQL
2 votes145 views1 answer
Add default sql server
SQL
1 vote151 views1 answer
Postgresql can you have null foreign key
SQL
-1 vote135 views2 answers
Get day in sql
SQL
3 votes173 views2 answers
Enter mysql command line
SQL
0 vote178 views5 answers
Select concat alter table mysql
SQL
1 vote136 views2 answers
Mssql show database size
SQL
0 vote153 views1 answer
Joomla execute raw sql
SQL
1 vote145 views1 answer
Mysql size int
SQL
0 vote146 views1 answer
Postgresql if else endif
SQL