What is mysql and How to use phpmyadmin

Let’s take a brief tour of What is MySQL and how to use PHPMyAdmin to get a broad overview of its capabilities. This is the home page of a local installation of phpMyAdmin being viewed in a browser. Depending on your set up, you might need to login with a user name and password to get to this page. This is a fresh installation of phpMyAdmin.

It was installed using XAMPP/WAMP on Windows, so you might see a slightly different list of databases on the left here, depending on how you installed.

The Database Server panel at the top right says that the user that’s logged in is root at local host.

Root is the MySQL superuser, which has all privileges, including creating and deleting databases and adding new user accounts. Local host means I’m using a local connection to the MySQL server. Because I’m logged in as root, I can see a full list of all the databases on this server in this column on the left.

Information schema is a virtual database that contains detail about all the databases. “You can’t edit it.”

The next one, mysql, stores details of all user accounts and privileges.

You should never edit this database directly.

The others performance schema, phpmyadmin, and webauth (if you are using XAMPP ) are all created and used directly by phpMyAdmin.

They’re there. You don’t need to bother with them. You’ll create your own database completely separate from that. But they’re used by PHPMyAdmin for certain administrative purposes. The database names are links that take you directly to a tab that displays the structure of the database.

I’m going to click the link of this cdcall (If you are using WAMP, you might not seen this database).

It’s the sample database. It doesn’t matter if you can’t see this, we’re just going to take a very quick look at what you get.

So the first thing that you get is the structure of the database. This particular database has got only one table called CD’s then in action you can browse that table you can see the table structure you can search the table insert new data empty. Removes all the data from that particular table, but leaves the table structure intact and Drop drops the table completely. It wipes it out, not only the table data but also the table structure. You will get a warning. If you click Drop, it’ll tell you that it’s going to delete the database and asks you to confirm it.

If you do that, everything disappears completely. There is no recycle bin or trash in MySQL. Once you delete something, it’s gone forever. As well as dropping tables, you can create new tables down here, and let’s just click this browse.

This shows as the contents of the table. This sample database was created in Germany. That’s why these titles here are in German. You can edit, copy, and delete individual rows. You can even change the value of a particular cell. By double-clicking and then just typing in the new value, and then it will update that particular row within the database.

Something to notice about the tabs at the top is that they are context sensitive. If I click structure now, it won’t take me back to the structure of the database, it’ll take me to the structure of this individual table.

Databases lists all of the databases on the server.

And then we’ll be going through the various options up here as we go through the course. I’m showing you everything in English, but if your native language is different from English, you can open this Language menu. An let’s say you are, Finnish.

You can change everything in, phpMyAdmin. To work in Finnish.

Conclusion:

It’s a browser-based front-end to MySQL that not only allows you to inspect the contents of a database, but also to add new tables, and to insert, update, and delete data.