IIS Aid

Creating your phpMyAdmin MySQL user account

Here we'll create the MySQL user account used by phpMyAdmin to perform many of its administrative functions. Simply log into your new phpMyAdmin install using the root account, click on the SQL query window button in the row of buttons in the top left hand side and then enter this query;

Click the Go button and it will create a new user for you. Obviously you'd need to change the "your_password" string to the same as what you have specified in you phpMyAdmin configuration file in the steps above. Next step is to assign the privileges to the phpMyAdmin user on the MySQL database. To do this, copy and paste the following code into the SQL query window. Be sure to delete the previous query first and change the "your_password" string again;

If the query was successful, then you can now close the query window down.

Creating and populating your phpMyAdmin MySQL database

Almost there now! The last thing to do before your phpMyAdmin installation is complete is to import the phpMyAdmin SQL script. However before we do that we'll need to uncomment a few lines so that the correct privileges are created for the phpMyAdmin MySQL user account. Navigate to the scripts directory in your phpMyAdmin root directory, and open the file called "create_tables_mysql_4_1_2+.sql". Scroll down to the section pertaining privileges which should be all commented out and remove the double hyphens (--) from infront of lines 36 and 37. This section should end up with something looking like this;

Save the file, then again in your phpMyAdmin window click on the Home button in the group of buttons in the top left hand side of the screen, and then click on the Import link in the right hand frame towards the bottom of the screen. Once this window opens, click on the Browse button and navigate to the "create_tables_mysql_4_1_2+.sql" file in the scripts directory of your phpMyAdmin install and click the Go button. This browse function only displays local files, so if you phpMyAdmin install is located on a different machine then you'll need to copy the "create_tables_mysql_4_1_2+.sql" file down locally and import it from there.

All Done

That is it! Your phpMyAdmin installation is now complete, and you should now have one of the most powerful MySQL administration tools around at your fingertips ready to use. One last bit of advice I will give is when creating users through phpMyAdmin, be sure to select the "Grant all privileges on wildcard name (username\_%)" option. What this basically does is give administrative privileges to users for the databases that are prefixed with their username, which is a very handy function in a multi user environment. Other than that it is also very highly recommended that you secure your phpMyAdmin installation by using SSL, and I will cover this in a guide later on down the track. If you have any feedback, please feel to leave a comment or post in the forum.