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

1 vote151 views3 answers
Psql fatal database does not exist
SQL
9 votes147 views6 answers
Sql insert into
SQL
1 vote135 views2 answers
Mysql trim whitespace
SQL
7 votes141 views6 answers
Nth highest salary in sql
SQL
11 votes160 views2 answers
How to import mysql database command line
SQL
0 vote153 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
8 votes166 views2 answers
Python simple connect to mysql
SQL
0 vote145 views1 answer
Python sql last insertend
SQL
0 vote155 views1 answer
Changing name of column and datatype in sql
SQL
0 vote155 views1 answer
Laravel migration sql dump
SQL