Langsung ke konten utama

Postingan

Menampilkan postingan dengan label mySQL server; Can't connect; port '3306' ;Error code (10060)

Failed to connect to mySQL server: Can't connect to MySQL server on '3306' (10060)

  Solution to Connecting remotely when you get Error 10060 All process for remote login. Remote login is off by default.You need to open it manually for all ip..to give access all ip GRANT ALL PRIVILEGES ON * . * TO 'root' @ '%' IDENTIFIED BY 'password' ; Specific Ip GRANT ALL PRIVILEGES ON * . * TO 'root' @ 'your_desire_ip' IDENTIFIED BY 'password' ; then flush privileges; You can check your User Host & Password SELECT host, user ,authentication_string FROM mysql.user; Now your duty is to change this bind - address = 127.0 .0 .1 You can find this on sudo nano / etc / mysql / mysql.conf.d / mysqld.cnf if you not find this on there then try this sudo nano / etc / mysql / my.cnf comment in this #bind - address = 127.0 .0 .1 Then restart Mysql sudo service mysql restart Now enjoy remote login