Configure a remote connection to mysql
MySQL>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
MySQL>FLUSH PRIVILEGES;
When you connect to mysql remotely
mysql -h127.0.0.1 -u root -p
Error:
ERROR 2003 (HY000): Can’t connect to MySQL Server on ‘127.0.0.1’ (111)
Solutions:
sudo vi /etc/mysql/my.cnf
Delete the following line.
#bind-address = 127.0.0.1
sudo /etc/init.d/mysql restart
Read More:
- Mysql 8.0.13 Enabling remote access (ERROR 1064 (42000): You have an error in your SQL syntax; check the manual th)
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
- How To Change ASM SYS PASSWORD
- ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- DVWA Uncaught Error: Call to undefined function mysql_connect() in /Applications/XAMPP/xampp
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- mysqli_ Error() has no return value (Fixed)
- Error 1064 (42000): you have an error in your SQL syntax
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- [How to Fix] Database can’t open file (errno:24)
- How to Fix MySQL error 1005: can’t create table (errno: 150)
- The setobject() method reports an error. The parameter index out of range and MySQL syntax error exception report an error
- ERROR 1265 (01000): Data truncated for column ‘ENABLED’ at row 7
- SQL Server Group sort de duplication row_ number() over ( PARTITION BY t1.col_ 2 ORDER BY 1 )
- Error creating foreign key in MySQL: 1215 cannot add the foreign key constraint