We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
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.