phpMyAdmin is a free open source MySQL database management tool used widely by many developers. It uses any browser to handle the database as you load all the databases either from a local server or from remote servers. Many database hosting websites provide this as the management tool, as this tool includes different features that are required for comfortable maintenance of the database by database administrators.
MySQL is the base database system used by phpMyadmin. It is also one of the most widely used open-source relational management systems. Many open source content management systems have developed their backend to hold their database in the MySQL language because of its special features.
In this article, you will learn how we can install phpMyAdmin on the Windows Platform.
WAMP Installation :
The easiest way of installation is the wamp software, which provides a combined installation of all the required Web development components -- namely Apache, MySQL, PHP, PHPMyAdmin -- all in just one click installations. All you need to do is to download the wamp executable setup file and initiate the installation file.
phpMyAdmin can also be manually installed by following this installation procedure. You will need to perform an additional installation of the Apache Web server. Apache, which is named for Apache HTTP Server, is one of the most widely used Web server programs because of its many significant features, like multiple website hosting, its compression methods, and other features.
Installing Apache :
For the Apache installation, we need to download the required version of Apache setup from this link -- http://httpd.apache.org/. Now we just need to follow the steps mentioned here: http://httpd.apache.org/docs/2.2/platform/windows.html.
After completing the Apache installation, you are now ready to install phpMyAdmin in your machine. First, get the file from http://www.phpmyadmin.net/home_page/downloads.php.
You'll see that the installation files are present in archive form. phpMyAdmin is provided in multiple languages so you can download your required language file from this. Now extract the contents of the zip file and you'll obtain a folder named phpMyAdmin-x.y.z based on the version downloaded. You'll need to rename the file to “phpMyAdmin.” Then copy this folder to the Apache installation folder and place under the htdocs subdirectory. If you installed Apache under C:/Apache for example, you'll need to copy the above folder into C:/Apace/htdocs. Now we need to rename the configuration file present inside the phpMyAdmin folder from config.sample.ic.php to config.inc.php.
Now you need to change the settings of this configuration file to match your requirement. For the single-user environment, you have to update the configuration file as:
$cfg['Server'][$i]['auth_type'] ='config'; $cfg['Server'][$i]['user'] = 'username'; $cfg['Server'][$i]['password'] = user-password';
Now for multi-user environments were there are more than one user, you should update the configuration file as:
$cfg['Server'][$i]['user'] = '; $cfg['Server'][$i]['password'] = '; $cfg['Server'][$i]['controluser] = 'controlusername'; $cfg['Server'][$i]['controlpass'] = 'controlpasswd';
You also need to make the following command prompt operation to successfully complete the multi-user environment for creating the controller user under username “controlusername” with the password 'controlpasswd'
C:\...\mysql\bin>mysql -u -root -p mysql>GRANT USAGE ON mysql.* TO ‘controlusername '@'localhost' IDENTIFIED BY ' controlpasswd'; mysql>GRANT SELECT ON mysql.db TO ' controlusername '@'localhost'; mysql>GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv) ON mysql.user TO ' controlusername '@'localhost'; mysql>GRANT SELECT (Host,Db, User,Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO ' controlusername '@'locahost'; mysql>quit;
You have now successfully installed the software on a multi-user environment. You can now access this phpMyAdmin by first starting the Apache server and then accessing it with the link “localhost/phpmyadmin " in any browser.You can access this using the credentials provided during the setup. Then, you're done! You've manually set up phpMyAdmin on your machine.