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 vote206 views1 answer
Oracle sequence last_number
SQL
0 vote180 views1 answer
Hibernate with springboot mysql
SQL
0 vote188 views2 answers
Null value in column violates not-null constraint
SQL
0 vote196 views1 answer
Show database not empty tables postgres
SQL
0 vote189 views1 answer
Create table if not exist with exceptions
SQL
2 votes205 views1 answer
Postgresql change value in column
SQL
0 vote204 views1 answer
Mysql subtract month from timestamp
SQL
13 votes180 views3 answers
Sql online code
SQL
0 vote198 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote175 views1 answer
Php delete database
SQL