Remote mysql on cpanel

[Jamie.k]

Hi,

I added my ip to remote mysql, but i still couldn't connect to it remotely.
I used my domain as host but that didn't work. So what's the host of the database if i want to connect remotely?


Greetings, Jamie

[WebScHoLaR]

Make sure that you have added that IP that is assigned to you when you connect to Internet. You can verify it at What Is My IP Address - Shows Your IP Address. Once you add the IP, reassign the database user to the database and it will work fine.

[arunsv84]

Hi,

Are you getting any error message? If yes, please paste it here. Also if you cant connect, please contact your hosting provider and ask them to grant permission to your ip . If you have root access to server please execute the following command in mysql.

grant all on databasename.* to databaseuser@yourip identified by 'databasepass';

Replace databasename, databaseuser, databasepass and yourip.

Make sure to use the port number as 3306. You can see it yourself by running the following command as root:

netstat -lpn | grep mysql

The hostname would probably be your domain name or hostname of your server or your server IP.

Hope this helps. Cheers !

[Jamie.k]

I added the right ip address, and i'm not getting any errors.
I can enter phpmyadmin with cpanel etc, but just remotely doesn't work.
And with remotely i mean, i have a gameserver on my vps that tryes to connect to the db on my shared hosting package with cpanel. I don't have root acces i only have cpanel.

I can't do this without cpanel?

If you have root access to server please execute the following command in mysql.
grant all on databasename.* to databaseuser@yourip identified by 'databasepass';
Replace databasename, databaseuser, databasepass and yourip.

[dalem]

you shared host is probably running a firewall and port 3306 is blocked
have them white list your VPS IP

[rkj]

Hello,

Dynamic Ips wont work as it keeps changing. Make sure you have a static IP and also make sure its added in the whitelist on your firewall.