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 vote181 views1 answer
Create bdd mysql
SQL
0 vote238 views1 answer
Mac os zsh: command not found: mysql
SQL
2 votes216 views1 answer
Sqlite3 show columns name
SQL
0 vote179 views1 answer
Oracle table free space
SQL
0 vote178 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote175 views1 answer
Mysql master slave setup with keepalived
SQL
15 votes187 views4 answers
Pl sql
SQL
7 votes206 views3 answers
Sql server check if temp table exists
SQL
0 vote175 views1 answer
Mysql grant grant option
SQL
0 vote216 views3 answers
Mysql keyword search
SQL