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 vote133 views1 answer
The fetch keyword oracle
SQL
2 votes125 views1 answer
How to find table table in stored procedure sql server
SQL
1 vote129 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote124 views1 answer
Convert .mdf to .bak
SQL
2 votes133 views2 answers
Create temporary table in mysql
SQL
2 votes118 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
8 votes116 views2 answers
Change name of colum in sql table
SQL
0 vote116 views1 answer
Mysql repair a table
SQL
0 vote117 views1 answer
Oracle webcenter content search enginer
SQL
14 votes123 views3 answers
Alter foreign key
SQL