Cannot connect remote database mysql

madip · Post by **madip** » Fri Feb 06, 2015 8:30 pm

Hi,
i'm tryng to connect an hosting website to my database on a VPS based on vesta panel.
From my local pc i can connect to remote database on VPS by command line.
But when i try to connect via http protocol (php web site) to remote database the response is
Can't connect to MySQL server on 'xxx.xxx.xxx.xxx'
Can anyone help me?

Post by **skurudo** » Sun Feb 08, 2015 1:45 am

May be you need check access to port 3306 first?

And then change your my.cnf files ->
[mysqld]
bind-address = your-server-external-ip

Save and close the file and restart mysql

madip · Post by **madip** » Wed Feb 11, 2015 7:13 am

thanks it works.
If i create user in phpmyadmin it doesn't work.
If if create user db in vestacp no problems.
thanks

Post by **skurudo** » Sun Feb 15, 2015 5:43 pm

madip wrote: If i create user in phpmyadmin it doesn't work.
If if create user db in vestacp no problems.

I think answer in one word - priviliges

Vesta Control Panel - Forum