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 vote150 views1 answer
How to create an SQL save method in ruby
SQL
0 vote171 views1 answer
Mysql select smaller of two values
SQL
0 vote178 views4 answers
Forenkey code alchemy sql
SQL
13 votes172 views3 answers
Change data type postgresql
SQL
0 vote230 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote121 views1 answer
Mssql view column data type
SQL
5 votes156 views2 answers
Add column postgres with default value
SQL
0 vote165 views1 answer
Set a default value for a column in sqlite
SQL
0 vote174 views1 answer
Load data from text file to mysql database on mac terminal
SQL
2 votes158 views1 answer
Drop table purge
SQL