Managing a MySQL database with phpMyAdmin
Overview
The following guide will show you how to access phpMyAdmin for your (gs) Grid-Service, and how to perform some basic operations on your databases. as the root MySQL user, "admin." This is necessary for performing higher-level database tasks, such as importing an SQL backup file or changing permissions on a database user.
End of Life Warning
This service has a pending End of Life. Please move to a current service as soon as possible. For more information, please see: (dv) Dedicated-Virtual 4.0: Migration Information.
Accessing phpMyAdmin for your (gs) Grid-Service
You can access phpMyAdmin directly by visiting the following URL:
https://s00000.gridserver.com/.tools/phpMyAdmin/index.php
Log in with your database username and password. If you receive a login error, please try clearing your browser cache.
You can also access phpMyAdmin from the AccountCenter.
- Log into your AccountCenter.
-
Select your primary domain name from the Domains tab, see Figure 1.
Figure 1. -
Click on Manage Databases, see Figure 2.
Figure 2. -
Click on the Admin button next to your database, see Figure 3. phpMyAdmin will launch in a new window.
Figure 3. -
Log into phpMyAdmin with your database username and password, see Figure 4.
Figure 4.We recommend to create a new Database User. This way, you will not interfere with existing applications.
NOTE:
phpMyAdmin will often keep incorrect login information cached in your browser. If you get a login error, please try clearing your browser cache. See Errors logging into phpMyAdmin for details on this error. If you still receive an error, please reset your database password. Not sure how? Read: Changing the password for a Database User.
You will now be able to administer your databases through phpMyAdmin. Your session will time out after 30 minutes of inactivity.
Troubleshooting
Accessing phpMyAdmin for your (dv) Dedicated-Virtual Server
-
Log into the Plesk Server Administration Panel. See Figure 1:
Figure 1. The Plesk Server Administration Panel. -
Click on Tools & Utilities on the left. See Figure 2:
Figure 2. Click on Tools & Settings. -
In the Applications & Databases section, click on Database Servers. See Figure 3:
Figure 3. Click on Database Servers. -
Then, click on Local MySQL server. See Figure 4:
Figure 4. Click on Local MySQL server. -
Click on the Databases tab. See Figure 5:
Figure 5. Click on the Databases tab. -
Next, click on Webadmin. See Figure 6:
Figure 6. Click on Webadmin.If nothing happens, you need to enable pop-ups in your browser. Check the help documentation for your browser.
-
phpMyAdmin will open in a new window (see Figure 7). You can now proceed to administrate your databases as the "admin" user with full access.
Figure 7. The phpMyAdmin user interface.
TIP:
If phpMyAdmin does not launch properly, please make sure your popup blocker is disabled for your site.
- Log into Plesk.
- Click on the Server tab.
-
Click on Database Servers, see Figure 1.
Figure 1. -
Click on Local MySQL Server, see Figure 2.
Figure 2. -
Click on the Databases tab, see Figure 3.
Figure 3. -
Click on DB WebAdmin. You may have to enable pop-ups, see Figure 4.
Figure 5. -
phpMyAdmin will load in a new window. You can now proceed to administrate your databases as the "admin" user with full access. See Figure 6.
Figure 6.
Basic operations
CAUTION:
Before making any changes to your database(s), please consider making a backup:
Here are some basic operations you can perform on your databases and tables in phpMyAdmin:
-
Select the database you want to use from the list on the left. See Figure 587.
Figure 5.Figure 8.Figure 7. -
Select the tables you want to use. When optimizing or repairing, you should select Check All. See Figure 698.
Figure 9. Click for a larger view.
Figure 6.Figure 8. -
In the "With selected" dropdown menu, select one of the following in Figure 7109:
Figure 7109.CAUTION:
The "Empty" and "Drop" actions will remove content from your database. Please do not do this unless you are sure you want to remove this content.
- Empty - This will empty all data from the selected tables.
- Drop - This will drop (delete) the selected tables.
- Check Table - This will check the tables for errors.
- Optimize Table - This will perform some basic table optimizations.
- Repair Table - This will attempt to repair your tables.
- Analyze Table - This will analyze your tables.
NOTE:
Exporting and then re-importing your database may improve its optimization. This article explains in detail how to export and import MySQL databases:
1. KrondaThe instructions regarding reaching phpMyAdmin from your account center seem to no longer apply, as I cannot find the Manage Databases link anywhere on the main page for our domain. You may want to update these instructions.
2. Elite Hello Kronda. Thanks for your comment. The instructions are correct. I did add screen captures to help navigate you to your (gs) Control Panel. Hope this helps! Let us know :)
3. AnonymousIs it possible to just go straight to phpmyadmin within dv4.0 rather than having to go through plesk? cheers
4. Elite Yes, it is possible. Please see our Community Wiki article: http://wiki.mediatemple.net/w/(dv)_4.0_-_Making_It_Better_::_Web_Accessible_phpMyAdmin