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

8 votes131 views3 answers
Oracle auto_increment
SQL
3 votes132 views1 answer
How to check schema privileges in oracle
SQL
0 vote143 views1 answer
Changing name of column and datatype in sql
SQL
19 votes146 views6 answers
Mysql if null
SQL
4 votes134 views6 answers
Second max salary in sql
SQL
31 votes144 views3 answers
Sql count
SQL
0 vote135 views4 answers
How to get max salary in each department in sql
SQL
22 votes119 views2 answers
Mysql show all tables
SQL
2 votes147 views1 answer
Merge firstname and lastname in sql oracle
SQL
18 votes128 views3 answers
Mysql number format
SQL