Cannot connect remote database mysql
Cannot connect remote database mysql
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?
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?
Re: Cannot connect remote database mysql
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
And then change your my.cnf files ->
[mysqld]
bind-address = your-server-external-ip
Save and close the file and restart mysql
SOLVED Re: Cannot connect remote database mysql
thanks it works.
If i create user in phpmyadmin it doesn't work.
If if create user db in vestacp no problems.
thanks
If i create user in phpmyadmin it doesn't work.
If if create user db in vestacp no problems.
thanks
Re: SOLVED Re: Cannot connect remote database mysql
I think answer in one word - priviligesmadip wrote: If i create user in phpmyadmin it doesn't work.
If if create user db in vestacp no problems.