Results 1 to 1 of 1

Thread: [How To] Make separated PHPMyAdmin access

  1. #1
    AndrewGlow is offline Master Glow Jedi
    Join Date
    Sep 2009
    Posts
    1,244

    Default [How To] Make separated PHPMyAdmin access

    Hello,

    PHPMyAdmin is already installed in cPanel and can be used to work with your databases. Anyway, if you use the PHPMyAdmin that is integrated in cPanel, you will have to login using cPanel details and you will have access to all databases.

    But in case you want to share access for only one or several databases, there is still a solution!

    First of all, you need to install PHPMyAdmin separately:

    1. Login to cPanel and search for "Softaculous". Click on it.

    Click image for larger version. 

Name:	admin1.jpg 
Views:	1231 
Size:	308.9 KB 
ID:	328


    2. At Softaculous scripts auto-installer enter "PHPMyAdmin" in search field and press "Enter".

    Click image for larger version. 

Name:	admin2.jpg 
Views:	1133 
Size:	331.4 KB 
ID:	329


    3. Click on "Install" button. You will need to enter domain name, folder to install and your email. After that confirm installation by hitting the "Install" button again.

    Click image for larger version. 

Name:	admin3.jpg 
Views:	1060 
Size:	247.9 KB 
ID:	330


    4. You will get an email with link to access your newly installed script. It will be like "yourdomain.com/folder/". Click on that link.

    Ready! Now you have a separate PHPMyAdmin installation. If you already have MySQL username/password, you can enter them and login to manage databases.

    Otherwise, you need to create a new database and user:

    1. Find "MySQL databases" icon in cPanel.

    2. In "Create New Database" field enter database name and click on "Create Database".

    Click image for larger version. 

Name:	admin4.jpg 
Views:	1147 
Size:	244.7 KB 
ID:	331


    3. Same way add a new MySQL user in "Add New User" field. Enter name and password.

    Click image for larger version. 

Name:	admin5.jpg 
Views:	1076 
Size:	56.8 KB 
ID:	332


    4. Now you need to allow new user to access database you have created. Find "Add User to Database" field and choose what user should have access to the database. You can allow one user to have access to several databases, just repeat these steps for several times.

    Click image for larger version. 

Name:	admin6.jpg 
Views:	955 
Size:	33.3 KB 
ID:	333


    5. You will see the "Manage User Privileges" area, where you will be able to choose what things user can do with the database.

    Click image for larger version. 

Name:	admin7.jpg 
Views:	1118 
Size:	182.9 KB 
ID:	334


    6. Bingo! Now go to PHPMyAdmin login page and enter MySQL username (not database name!) and password.

    Click image for larger version. 

Name:	admin8.jpg 
Views:	1161 
Size:	84.9 KB 
ID:	335

    7. In case you see blank page instead of phpMyAdmin login page, please try to create php.ini file in installation folder and add following line:

    disable_functions = allow_url_fopen, escapeshellarg, escapeshellcmd, ini_alter, passthru, popen, proc_open, proc_close, proc_terminate, proc_get_status, proc_nice, show_source, system

    This will enable readfile() function for phpMyAdmin, since it can't operate without this function.

    If this doesn't help, please open a new ticket and our support will assist you within 10-15 minutes.
    Last edited by AndrewGlow; 01-18-2014 at 06:32 AM.
    Have no fear,
    GlowHost is Here!

Similar Threads

  1. Empty 0r Truncarte table in phpmyadmin
    By jamison in forum General Support
    Replies: 1
    Last Post: 09-01-2011, 08:38 AM
  2. phpMyAdmin Questions
    By wrave in forum cPanel Topics
    Replies: 6
    Last Post: 01-05-2008, 06:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16