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 vote365 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
59 votes581 views6 answers
Alter table sql
SQL
5 votes374 views2 answers
Sql constraint check value in list
SQL
1 vote357 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
3 votes314 views1 answer
System.debug apex
SQL
1 vote339 views1 answer
Oracle case
SQL
-3 votes437 views8 answers
Sql to c# linq converter online
SQL
0 vote325 views1 answer
Sql select non unique
SQL
1 vote338 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote339 views1 answer
Sum values by month mariadb
SQL