Back to Blog
![]() ![]() Mysql>GRANT SELECT ON mysql.db TO ' controlusername 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 er TO ' controlusername SELECT (Host,Db, User,Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO ' controlusername have now successfully installed the software on a multi-user environment. Mysql>GRANT USAGE ON mysql.* TO ‘controlusername IDENTIFIED BY ' 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 Now for multi-user environments were there are more than one user, you should update the configuration file as: For the single-user environment, you have to update the configuration file as: $cfg ='config' Now you need to change the settings of this configuration file to match your requirement. Now we need to rename the configuration file present inside the phpMyAdmin folder from .php to. If you installed Apache under C:/Apache for example, you'll need to copy the above folder into C:/Apace/htdocs. You'll need to rename the file to “phpMyAdmin.” Then copy this folder to the Apache installation folder and place under the htdocs subdirectory. Now extract the contents of the zip file and you'll obtain a folder named phpMyAdmin-x.y.z based on the version downloaded. phpMyAdmin is provided in multiple languages so you can download your required language file from this. You'll see that the installation files are present in archive form. Īfter completing the Apache installation, you are now ready to install phpMyAdmin in your machine. Now we just need to follow the steps mentioned here. ![]() 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.įor the Apache installation, we need to download the required version of Apache setup from this link. You will need to perform an additional installation of the Apache Web server. PhpMyAdmin can also be manually installed by following this installation procedure. All you need to do is to download the wamp executable setup file and initiate the installation file. 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. In this article, you will learn how we can install phpMyAdmin on the Windows Platform. Many open source content management systems have developed their backend to hold their database in the MySQL language because of its special features. It is also one of the most widely used open-source relational management systems. ![]() MySQL is the base database system used by phpMyadmin. 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. ![]() It uses any browser to handle the database as you load all the databases either from a local server or from remote servers. PhpMyAdmin is a free open source MySQL database management tool used widely by many developers. ![]()
0 Comments
Read More
Leave a Reply. |