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?
mysql/shell acess
Collapse
Unconfigured Ad Widget
Collapse
X
-
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.
Last edited by admin; 08-14-2015, 11:37 AM.Jason
---------
Technical Support Group
AccuWebHosting.Com
Windows Website Hosting
Linux Website Hosting
-
-
The other way is SHELL access. However, we are not providing shell access with any account.Last edited by admin; 08-14-2015, 11:38 AM.Jason
---------
Technical Support Group
AccuWebHosting.Com
Windows Website Hosting
Linux Website Hosting
Comment
-
-
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.
Comment
-
Comment