How to manage databases with the Webadmin in Plesk

Parallels Plesk Panel 10 end-user series

How to manage databases with the Webadmin in Plesk

To manage your databases and their contents, use your favorite MySQL, PostgreSQL, or Microsoft SQL Server client or the web-based database management tool accessible from the Panel, also known as the Webadmin.

1) You can find that by going to Websites & Domains.

2) Then Databases.

3) And then choosing a database to edit.

Note that you will need to have a user assigned to the Webadmin in order to access it.

4) Click Webadmin.

5) Since our database is a MySQL database, Plesk has taken us to the phpMyAdmin start page. Use the various tabs and links to manage your database.

This tutorial is complete. You now know how to access the Webadmin for a Database in Plesk.

Modifying fields in database tables with phpMyAdmin

phpMyAdmin series

Modifying fields in database tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin

Now let’s learn how to modify fields in database tables

Select the details table here

Let’s modify the address field

Click the Change icon

Make the changes you want, then click Save

That’s it! We’ve successfully changed the name of the address field to city

This is the end of the tutorial. You now know how to modify fields in a table using phpMyAdmin

Running SQL queries on a database with phpMyAdmin

phpMyAdmin series

Running SQL queries on a database with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin

Now let’s learn how to run SQL queries on a database

Click the database table you wish to run a SQL query on

As demonstrated in another tutorial, you can delete (or drop) a field from a table by selecting it here then clicking the drop icon here

In this tutorial however, let’s demonstrate how to delete this address field using pure SQL commands

Click the SQL button here

Then type the SQL command to delete the address field from the details table. Click Go when finished

That’s it! the SQL command has been executed. Let’s go take a look

The address field is no longer in our details table

You can also click the SQL button directly from the table view (instead of from the database view which is what we did)…..

….. doing so presents a SQL query window that is partially filled in

For more information on learning about SQL query syntax, visit the MySQL documentation available here

This is the end of the tutorial. You now know how to run SQL queries on a database using phpMyAdmin

Renaming database tables with phpMyAdmin

phpMyAdmin series

Renaming database tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin

Now let’s learn how to rename database tables

Click the database table you wish to rename

Then click the Operations button

Enter a new name for the table here

Then click Go

That’s it! The information table has been renamed infotable, and is listed here

This is the end of the tutorial. You now know how to rename database tables using phpMyAdmin

Searching through a database with phpMyAdmin

phpMyAdmin series

Searching through a database with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin

Now let’s learn how to use the Search feature

Click the database you wish to search here

Then click the Search button

Enter words or values to search for in the database. There are several options you can use to refine your search. This database only has one table (details), but if there were more, you could limit your search to specific tables here

When ready, click Go to perform the search

The search found one match. Click Browse

We can now make changes to the record that was found

Here is where you could make changes if you wanted to

Click Go when finished

This is the end of the tutorial. You now know how to use the Search feature in phpMyAdmin