mysql/shell acess

Collapse

Unconfigured Ad Widget

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • linux7802
    replied
    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.

    Leave a comment:


  • ghmyers
    replied
    oh okay. thanks for the info. I understand myphpadmin a lot better now anyway. thanks again.
    Last edited by admin; 08-14-2015, 11:39 AM.

    Leave a comment:


  • Jason
    replied
    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.

    Leave a comment:


  • ghmyers
    replied
    Thanks,

    Yeah I found that out, but now I am also wondering if there is any other way of accessing mysql other than myphpadmin.
    Last edited by admin; 08-14-2015, 11:38 AM.

    Leave a comment:


  • Jason
    replied
    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:


  • ghmyers
    started a topic mysql/shell acess

    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.
Working...
X