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 vote325 views2 answers
Oracle create chain rule
SQL
0 vote322 views1 answer
IIF
SQL
0 vote343 views2 answers
Greater than sql server
SQL
0 vote321 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
-1 vote327 views3 answers
Create temp table in sql
SQL
0 vote347 views1 answer
Calculate age in sql
SQL
0 vote328 views1 answer
Psql list view rules
SQL
0 vote332 views1 answer
Install sql server windows 10
SQL
0 vote335 views2 answers
Plsql regex match whole word
SQL
0 vote334 views1 answer
Add computed column to table sql server
SQL