This article introduces phpMyAdmin and gives a brief overview of how it works.\n\n\n\nphpMyAdmin is free, open source, and was created using the PHP programming language. It was created as a wrapper around the MySql database. PhpMyAdmin is a web interface that gives the user the ability to manage their databases from any device that runs a modern web browser.\n\n\n\nWhat is phpMyAdmin\n\n\n\nphpMyAdmin is a free software tool that is used to administer the MySql data engine. It was created in PHP. It was first released in September 1998. Being very mature, it is well documented and widely used. \n\n\n\nSome of the things you can do with phpMySql are create and test SQL queries, manage databases, and manage users.\n\n\n\nphpMyAdmin is very feature-rich. It is used as a web interface for the MySql data engine and its derivatives.\n\n\n\nI use it often when I need to create a complicated SQL query. SQL stands for Structured Query Language, which is how programmers interface with databases. \n\n\n\nIn the next section, we will dig a little deeper.\n\n\n\nHow Does it Work\n\n\n\nLogin \u2013 To get started one must log in with a MySql username and password. This will give the user access to any databases they have permission to use.\n\n\n\n\n\n\n\nThe phpMyAdmin Home Page - Once logged in you will see the phpMyAdmin Home Page that will look like the following.\n\n\n\n\n\n\n\nIn the upper left area is where you can find the main menu. \n\n\n\n\n\n\n\n\n\n\n\nMain Menu Functionality\n\n\n\nTo return to the home page click the \u201cphpMyAdmin\u201d text.The \u201chome\u201d icon returns to the home page as well.The next icon which looks like a door with a green arrow, is the logout button.The round icon that contains a question mark links to the local phpMyAdmin documentation.The icon that looks like a page with a smaller page over it is linked to the MySql reference manual.The gear is liked to the settings pages.The green icon causes the page to refresh when clicked.\n\n\n\nTop Menu Functionality\n\n\n\nThe top menu will be referred to as tabs in this article.\n\n\n\n\n\n\n\n\n\n\n\nDatabases \u2013 Linked to the databases page.SQL \u2013 Linked to one of the two query building pages. This is the less feature-rich version of the two SQL pages.Status \u2013 Linked to a stats page. User account \u2013 Links to the user account overview page.Export \u2013 Linked to the export database page.Import \u2013 Linked to the import page.Settings \u2013 Linked to a page that provides for import and export configuration.Replication \u2013 Linked to the replication configuration page.Variables \u2013 Linked to the server variables and settings page.Charsets \u2013 Linked to the character settings and collation page.Engines \u2013 Links to the storage engine page.Plugins \u2013 Links to the plugins page.\n\n\n\nHome Page List of Databases and Tables\n\n\n\nOn the left side of the home page, you will see a list of databases. By clicking on a database, it will expand to display the tables within that database.\n\n\n\n\n\n\n\n\n\n\n\nManage Users\n\n\n\nCreate a User:Click the "home" icon, click the \u201cUser accounts\u201d tab, then click \u201cAdd user account\u201d which is about in the middle of the form.Complete the form.Modify a user account:Click the "home" icon, click the \u201cUser Accounts\u201d tab, then click the \u201cEdit privileges\u201d link that is on the same line as the user account you want to modify. On this page you can:Edit the user's privileges.Add privileges to other databases.Grant or revoke global privileges.Change the user\u2019s password.Change the login information (username, hostname, password).Remove a user:Click the "home" icon.Click the \u201cUser Accounts\u201d tab.Click the checkbox next to the user you want to remove.Then select \u201cDrop the databases that have the same names as the users\u201d if you want to remove the database with the same name as the user.Click the \u201cGo\u201d button.\n\n\n\nAbout User Privileges \n\n\n\nUser privileges are what access the user is given. Such as what databases they can see and modify and from where, such as being restricted to the local server.\n\n\n\nManage Databases\n\n\n\n\n\n\n\nCreate a database.Click the "home" icon, click the \u201cDatabases\u201d tab.Enter the Database Name, select the collation, and click the \u201cCreate Button\u201d button.A form will be displayed that allows you to enter the table\u2019s name and the number of fields the table will contain. Complete the form and click on the \u201cGo\u201d button.Complete the form and click the \u201cSave\u201d button.Modify Databases.From the left column of the home page select the database you would like to modify by clicking on the database name. The center panel will show all the tables in the database. From this form, you can branch-off to perform other actions to include creating a new table.Delete or drop a database.From the left column select the database you would like to drop by clicking on the database name. Then click the \u201cOperations" tab.Under \u201cRemove database\u201d click \u201cDrop the database (DROP)\u201d \n\n\n\n\n\n\n\nManage Tables\n\n\n\n\n\n\n\nClick the home icon, then click the \u201cDatabases\u201d tab. You will see a form like the one above.Click the Database you wish to manage. This will take you to the \u201cStructures\u201d tab. You will be on a form like the one below. This is where you manage your tables.\n\n\n\n\n\n\n\nYou can now:\n\n\n\nBrowse \u2013 This allows you to \u201cEdit\u201d, \u201cCopy\u201d or, \u201cDelete\u201d each record. You will see the columns along with their data. You can also export data from this screen.Structure \u2013 From this screen, you can modify the structure of each field \u2013 Change, \u201cDrop\u201d, or you can perform other operations.Search \u2013 This allows you to search your data.Insert \u2013 This is a form that allows you to add a record to the selected table.Empty \u2013 This feature will remove all the records in the table. Be careful with this option.Drop \u2013 Allows for the entire table to be removed\/destroyed. Be careful with this option.\n\n\n\nNote you can also use the list of tables in the left panel to drill down from your database to a table, and the table\u2019s fields.\n\n\n\nAbout Collation\n\n\n\nCollation defines how to sort or how to weigh items in relevance to other items. For more information read the MySql documentation on supported character sets and collations [https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/charset-charsets.html] Notice MySql recommends you test your selected collation to ensure you are getting the results you desire.\n\n\n\nImport Data\n\n\n\nFrom the top menu click on \u201cImport\u201d. A form will appear. Click \u201cChoose File\u201d, which will open dialog page for selecting the file you want to import. To the right of \u201cChoose File\u201d, you will see the max file size that you can import. The value can be adjusted. Modifying this value is outside the scope of this article.Select the \u201cCharacter Set\u201d.Set or unset Partial Imports.Set or unset Enable foreign key check.Set the file format.Set the SQL compatibility mode or leave it at its default of none.Set or unset \u201cDo not use AUTO_INCREMENT for zero values\u201d.Click the \u201cGo\u201d button.\n\n\n\nExport Data\n\n\n\nFrom the top menu click on \u201cExport\u201d. Select the \u201cExport method\u201d:Quick - display only the minimal options.Custom - display all possible options.Select the \u201cFormat\u201d from the drop-down.Click the \u201cGo\u201d button. \n\n\n\nSQL Queries\n\n\n\n\n\n\n\nSQL stands for Structured Query Language. This is another area you will want to become familiar with. SQL is your bread and butter when it comes to working with databases. I use the SQL box to build complex SQL statements.\n\n\n\nThere are two ways to get to the query interface.\n\n\n\nClick the "home" icon, then click the "SQL" tab to get to the plain SQL interface:\n\n\n\nFrom almost any page you can click the table under a database on the left column and then click the \u201cSQL\u201d tab. That will bring up an SQL interface that has a lot of features you will probably find useful. From here you can click any of the buttons that are directly below the query box. The cool part of this is it will create the type of query you want to create based on the table you selected. This is a great way from a beginner to learn SQL. \n\n\n\n\n\n\n\nThe buttons I want to point out are:\n\n\n\n<Select *> - Will create a wild card select (a select pulls data).<Select> \u2013 Will create a select listing all the fields in the table. <Insert> - Will create an insert query. This query contains all the fields of the table (an insert creates a new record and populates it).<Update> - Will create an update query. This query contains all the fields of the selected table and place holders for the data that is to be updated (an update query is used to update data). <Delete> - Will create delete query ( a delete removes a record). <Clear> - Will clear the text box. <Format> \u2013 This will format the query so it can be used within a program.\n\n\n\nphpMyAdmin Documentation\n\n\n\nThere is a lot to know. This article does not cover everything. This link will take you to the phpMyAdmin documentation where you can learn more.\n\n\n\nConclusion\n\n\n\nThere are a number of tools you can use to manage your MySql data, each has different features you might find useful.\n\n\n\nThe nice thing about phpMyAdmin is it is a web application, meaning it runs in a browser. That means you can access phpMyAdmin from any device that runs a modern browser.\n\n\n\nphpMyAdmin is very feature-rich and is a great tool for programmers and system administrators.