Announcement

Collapse
No announcement yet.

mysql/shell acess

Collapse

Ads on showthread pages

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

  • mysql/shell acess

    WordPress Hosting on SSD Servers
    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, 12:36 PM.

  • #2
    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, 12:37 PM.
    Jason
    ---------
    Technical Support Group
    AccuWebHosting.Com
    Windows Website Hosting
    Linux Website Hosting

    Comment


    • #3
      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, 12:38 PM.

      Comment


      • #4
        The other way is SHELL access. However, we are not providing shell access with any account.
        Last edited by admin; 08-14-2015, 12:38 PM.
        Jason
        ---------
        Technical Support Group
        AccuWebHosting.Com
        Windows Website Hosting
        Linux Website Hosting

        Comment


        • #5
          oh okay. thanks for the info. I understand myphpadmin a lot better now anyway. thanks again.
          Last edited by admin; 08-14-2015, 12:39 PM.

          Comment


          • #6
            ASP.Net Hosting starts @ $3.18/Mo.
            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

            Working...
            X
            Sign up for a News Letter Click here to sign up