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 vote320 views1 answer
Mariadb change column type
SQL
0 vote266 views2 answers
Mysql disable foreign key checks
SQL
-1 vote293 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote313 views1 answer
Typical max-connect-errors mysql
SQL
8 votes291 views2 answers
Mysql get first x characters
SQL
0 vote297 views1 answer
Vbscript connect mssql
SQL
3 votes272 views1 answer
Mssql remove column
SQL
3 votes350 views1 answer
Apex call duration
SQL
0 vote296 views1 answer
Mssql dockere
SQL
0 vote266 views1 answer
Sql describe
SQL