Questions about MySQL on unmanaged VPS

Hi guys, I've bought a VPS unmanaged, this means I don't have cPanel/WHM.

I've some issues with MySQL, I cannot give me own access to login remotely (ussing apps like navicat, and others) and administrate my databases. In addition, I cannot install scripts as WordPress due the connection cannot be established.

Could someone help me?


Regards!

 

You need to give privileges to your MySQL user to connect remotely.

 

Google is your friend! http://kb.liquidweb.com/enable-remote-mysql-connections-in-cpanel/
When you have done that, allow it an hour or so then check if it's working.

 

Did you even read the question ? He does not have cPanel/WHM.

 

I thought he meant the software is not installed yet because he ordered an unmanaged service.

 

Yes, I don't have cPanel and I don't wanna buy it, it's a extra quote out of my budget.

I've read about the remote connections adding the ip in some files in mysql.conf but the main issue is that my IP it's dynamic.

Any idea?


Regards! 

 

Then you can use % in GRANT command. Using % will allow anyone from any place (having password) in the world connect to your MySQL. Refer to MySQL Manual.

 

You can connect to your mysql server over ssh(or even over http i think). That would mean you wouldnt need to have a public mysql server.

Another option would be to firewall the mysql port and only allow yourself through. Even with dinamic ip you can use something like dyndns.