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 vote308 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote313 views1 answer
Sql drop procedure if exists
SQL
0 vote337 views1 answer
Get statis values sql
SQL
0 vote330 views1 answer
Data directory postgresql
SQL
0 vote359 views1 answer
Sql alternative to max statement
SQL
0 vote322 views1 answer
Apex for oracle 11g
SQL
9 votes328 views1 answer
Alter table column change data type to text mysql
SQL
28 votes312 views6 answers
Mysql change user password
SQL
11 votes310 views1 answer
Oracle view ddl
SQL
1 vote316 views1 answer
Mysql strict_trans_tables
SQL