Do you need mysql for phpmyadmin?

No. To use phpMyAdmin, you'll need a client (your local web browser), a web server, and a MySQL instance -- and those three can exist in any combination that works for you. Just mix and match servers. I'd say the most typical installation is a combination web server and MySQL server running on one machine and accessed across the network from another machine. Something common with many shared hosts is having all three on separate machines (obviously your client is your own machine and the host runs MySQL and the webserver on two different machines in this case).

To accomplish this, your servers need to be able to talk to each other and MySQL has to allow access from the web server. Connections from your web browser to the web server are usually unrestricted and without problem. From the web server to MySQL can be difficult if they're not on the same machine because some installations/hosts block the MySQL port at the network level or set MySQL permissions to not allow external access.

So anyway, to answer your question, no, in that case you do not need MySQL installed locally because you'll run phpMyAdmin either on the same server as the MySQL machine or configure phpMyAdmin on your webserver to talk to the MySQL server and won't need to run any server software on your local machine. Hope that makes sense.

Introduction¶

phpMyAdmin is a popular web-based administration tool used to administrate MySQL servers and databases. This tutorial illustrates how to create a new database and a new user to access that database on a MySQL Server using phpMyAdmin.

Prerequisites¶

• You will require a root or DBA user login to the MySQL server, or a user login with permission to create new databases.
• You will need to have access to an instance of phpMyAdmin appropriately configured to administrate the MySQL server.
• If you require a dedicated web server running MySQL and phpMyAdmin please visit our Web Hosting Services page.
  

Using phpMyAdmin Version 3.5.1¶

Browse to your phpMyAdmin URL using your Internet Web Browser, and login using your root or dba user login as shown.

From the main menu choose Databases

In the create database field type in a name for your database. Leave the collation drop down box if you wish to use the default MySQL schema collation. Click Create.

Your database will now be visible on the right hand side under the list of available databases. To setup a new user login to access this database, click on Users in the main menu. Choose the Add User option under the list of available server users.

In the section titledLogin Information - type in a username, localhost and a password in the fields as shown. Optionally you can press the Generate button to create a random password for you.

The section that relates to the users GLOBAL privileges are privileges you want to assign to this user which apply to ALL databases on the server. It is recommended that you do NOT assign these permissions unless you know exactly what you are doing. It is far more secure to assign seperate user logins to each piece of software or website that will require access to only a particular database. Therefore leave this section BLANK, and then click the Add User button.

After the user is created, you can see it listed on the Users page. Click Edit Privileges to assign access to a specific database.

Once again leave the Global Privileges section BLANK. Scroll down to the section titled Database-Specific Privileges. Choose the database you want the user to be able to access from the list, and click GO.

Assign the permissions as shown to provide the user with access to the given database. The following permissions are recommended for compatibility with most modern web-based software applications.

Select, Insert, Update, Delete, Create, Alter, Index, Drop, Create Temporary Tables, Lock Tables

Click GO after selecting the relevant privileges.

If you click on the users Edit Privileges option now, you will see that new privileges for the specific database are now listed as belonging to the user.

Click the Logout option in the top left corner, and test your new user login with phpMyAdmin.

Testing Your User Login¶

Test your new user login by using it to login to phpMyAdmin.

NOTE: phpMyAdmin must be configured in the default cookie authentication mode to be able to login to MySQL server with any username.

If you can only your new database in the list of schema's on the left then your new database and username is most likely ready for use.

Do we need MySQL for phpMyAdmin?

Is phpMyAdmin a MySQL database?

What is needed to install phpMyAdmin?