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 vote200 views1 answer
Sql reverse order of results
SQL
0 vote221 views2 answers
Mysql dump structure only
SQL
3 votes222 views1 answer
Start mysql server by terminal in linux
SQL
2 votes188 views2 answers
Compare date mysql
SQL
0 vote233 views1 answer
Openquery update linked server
SQL
0 vote208 views1 answer
Google sheets filter rows above current cell
SQL
0 vote208 views1 answer
Java sql connection
SQL
3 votes206 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote202 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote214 views2 answers
How to use aggregate functions in sql
SQL