SQLSTATE[HY000] [2002]

#open /etc/mysql/mysql.conf.d/mysqld.cnf 
#and change
#bind-address            = 127.0.0.1
#to
#bind-address            = 0.0.0.0

#then grant root all privaleges to root
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Similar codes

0 vote213 views1 answer
How to create notes in mysql
SQL
1 vote171 views1 answer
How to unlock table in mysql
SQL
2 votes167 views1 answer
Mysql virtual column
SQL
1 vote155 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
1 vote230 views1 answer
Oracle previous year
SQL
1 vote155 views1 answer
Sql delete row with auto increment
SQL
0 vote179 views1 answer
How to get first 10 records of a table in mysql
SQL
-1 vote254 views5 answers
Left join
SQL
0 vote181 views2 answers
SQL Server Standard
SQL
3 votes158 views1 answer
Oracle revoke grant
SQL