If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to Register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
This is my first time with mysql and trying to work with a database. I tried to access mysql through some shell feature in cpanel. I have searched through what I have and looked through these forums, but I can't seem to find out how to get a hold of my hostname/username/password. Any tips for a young new?
You can also access mysql databases remotly by using any third party software like sql yog etc.
In third party software you only have to put following settings.
Mysql server / host name : You can use your domain name or server ip
Mysql port : 3306
Mysql database name : Your database name.
Mysqul database user name : Use database user name which you have assigned to database.
Mysql database user name password : Use correct password.
Last and most important thing add your local machine ip in cPanel >> Remote Database Access Hosts list and if you are using dynamic ip address then put % in "Remote Database Access Hosts" option.