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.
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.
Leave a comment:
-
-
mysql/shell acess
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?Last edited by admin; 08-14-2015, 11:36 AM.Tags: None
-
Leave a comment: