WHAT is PHPmyadmin?
Most scripts you use to power your blog, shopping cart or community forum use a combination of PHP and MySQL. PHP is the Web programming language that forms the script, and MySQL is the format of the database that stores information your script needs to run. For instance, the popular blogging script WordPress store posts, comments, links, user data, options and more in your MySQL database. When you need to access that information–to change a password, for example–you use phpMyAdmin.
In short, it is one of the best Web-based, visual tool that lets you browse and edit your MySQL databases. Without it, you could edit your databases and view them in their entirety, in one long text file. If you were familiar with MySQL, you could manually edit anything in your database. However, this process would take longer than with the use of the Web tool. Furthermore, it’s much easier to undo unwanted changes, some of which might break your website, with phpMyAdmin.
In short, it is one of the best Web-based, visual tool that lets you browse and edit your MySQL databases. Without it, you could edit your databases and view them in their entirety, in one long text file. If you were familiar with MySQL, you could manually edit anything in your database. However, this process would take longer than with the use of the Web tool. Furthermore, it’s much easier to undo unwanted changes, some of which might break your website, with phpMyAdmin.
ACCESSING PHPMYADMIN
You can log on to this utility from your host’s control panel. Hosts that use control pane software like cPanel or H-Sphere often include an icon to phpMyAdmin directly from the front page, so you needn’t click around to find it. You may have a list of users, and you can choose the one that you want to log in as if you have more than one. However, your host many not allow multiple users or databases, which will prompt phpMyAdmin to open immediately.
what PHPMYADMIN can do?
Once you have the tool open, you’ll see a lot of information. It can be overwhelming at first, but databases use a structure that makes them easy to navigate once you become familiar with them. The general layout shows the name of your database(s) on the left. Clicking the name will expand to show all your tables. If you use complex or multiple scripts, this list might be quite long. For example, a single database might have multiple blog installations what use different prefixes. If you use the prefixes “blog1_” and “blog2_”, it’s easier to see which tablets belong to which script.
You can simply browse to get a feel for your database. Some information in your tables might not be human-friendly, but other information will make sense to you. The various tabs provide different options. Perform operations with lines of code from the “SQL” tab. phpMyAdmin lets you manually import or export entire databases or tables in a variety of formats as well. You can locate data within your database using the “Search” tab or create, delete and otherwise modify tables from the “Operations” tab.
phpMyAdmin is crucial if you want to understand or modify your MySQL databases; although, it might appear differently to users based on the version or themes that your host uses.
You can simply browse to get a feel for your database. Some information in your tables might not be human-friendly, but other information will make sense to you. The various tabs provide different options. Perform operations with lines of code from the “SQL” tab. phpMyAdmin lets you manually import or export entire databases or tables in a variety of formats as well. You can locate data within your database using the “Search” tab or create, delete and otherwise modify tables from the “Operations” tab.
phpMyAdmin is crucial if you want to understand or modify your MySQL databases; although, it might appear differently to users based on the version or themes that your host uses.
