mysql/shell acess

[ghmyers]

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?

[Jason]

Hi,

Inside CPANEL there is an option called "MYSQL DATABASES" & "PHPMYADMIN".

USING "MySQL Database" option you can create mysql database. After creating mysql database, you have to add users to that mysql database. You can do that in the same screen of "MySQL Database".

Once the user and database is created, you can access that database using "PHPMYADMIN" option.

[ghmyers]

Thanks,

Yeah I found that out, but now I am also wondering if there is any other way of accessing mysql other than myphpadmin.

[Jason]

The other way is SHELL access. However, we are not providing shell access with any account.

[ghmyers]

oh okay. thanks for the info. I understand myphpadmin a lot better now anyway. thanks again.

[linux7802]

Re: mysql/shell acess

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.