Follow instructions below: Login to Plesk and make sure that Allow remote connections from any host option is enabled in Tools & Settings > Database Servers > Settings Edit my.cnf/my.ini file changing bind-address parameter to: bind-address = 0.0.0.0 Also, make that skip-networking parameter is not defined. For Linux: /etc/mysql/my.cnf Debian/Ubuntu /etc/my.cnf CentOS/CloudLinux/RHEL For Windows: "%plesk_dir%\MySQL\my.ini" for Plesk databases(port 8306) "%plesk_dir%\Databases\MySQL\my.ini" for Clients databases(port 3306) After that, restart MySQL server. Login to MySQL server. Note : For the access to client's MySQL server on Windows, use PHPMyAdmin: Plesk > Tools & Settings > Database Servers - MySQL DB Admin. Grant the access to remote IP address and login to MySQL. For example, if you want to allow access to database called database for user user with password password and remote IP add
Hi, I’m Deepak Dubey. The founder of this blog. I’m a Full-stack Python Developer | OpenedX professional and part-time blogger. I’m here to write the blogs related to technology stuff like Python, Django , Open-edX, Data Science, machine Learning and many more.