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

31 votes326 views3 answers
SQL Server change column data type
SQL
13 votes339 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
2 votes349 views1 answer
Dbms transaction (psql)
SQL
0 vote340 views2 answers
Faster mysql imports
SQL
0 vote330 views1 answer
Where field is null sql knex
SQL
1 vote322 views1 answer
Create index concurrently postgres
SQL
0 vote318 views1 answer
Prepared statement mysql java delete selected rows
SQL
2 votes348 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote346 views1 answer
View psql output in horizontal scrolling
SQL
92 votes595 views6 answers
Substring
SQL