Can I use Mysql GUI on local machine to administer databases on hostingrails?
- Eggman
- Posts: 3
- Starts: 5
- Wiki Edits: 0
- Location: New York City
I use cocoamysql to do mysql administration on my local machine. Is it possible for me to also administer the databases on my hostingrails account using this local program?
- Vinayan
- Posts: 253
- Starts: 0
- Wiki Edits: 2
Hi Eggman,
Yes, You can access your Hostingrails Mysql database using the cocoamysql. For remote database connection specify your global ip in the "cPanel --> Remote Database Access Hosts". In the cocoamysql dialog box you can specify the your mysql username, mysql password, Server IP and port 3306.
Yes, You can access your Hostingrails Mysql database using the cocoamysql. For remote database connection specify your global ip in the "cPanel --> Remote Database Access Hosts". In the cocoamysql dialog box you can specify the your mysql username, mysql password, Server IP and port 3306.
2008-05-31 05:08 PM
- Joncheck
- Posts: 1
- Starts: 0
- Wiki Edits: 0
Hey Vinayan,
What if your vps does not have cPanel (like mine)? Is there an easy way to enable remote mysql administration? Also, how bad a security risk is opening port 3306?
Thanks
What if your vps does not have cPanel (like mine)? Is there an easy way to enable remote mysql administration? Also, how bad a security risk is opening port 3306?
Thanks
2008-06-02 03:05 PM
- Santhi
- Posts: 234
- Starts: 0
- Wiki Edits: 1
From the mysql prompt you can execute the following command.
------------
mysql> GRANT ALL ON <databasename>.* TO <user>@'<yourIP>' IDENTIFIED BY 'PASSWORD';
Also 3306 is the default mysql port. You need to open the port if you want to access your database remotely.
------------
mysql> GRANT ALL ON <databasename>.* TO <user>@'<yourIP>' IDENTIFIED BY 'PASSWORD';
Also 3306 is the default mysql port. You need to open the port if you want to access your database remotely.