![]() ![]() Mysql>GRANT USAGE ON mysql.* TO IDENTIFIED BY 'pmapass' If we have edited for Muti-User(untrusted) environment then go to mysql command prompt and perform the following steps to create mysql user - 'pma' identfied by pass 'pmapass'.For a multiuser (untrusted) environment, update as:.If we type in into the browser, we can bypass login sesstion and go directly into myadmin: For a single-user (root or trusted) environment (This is my case), update as:.For a personal server running behind a firewall, config may be desirable whereas a multi-user facility (such as an ISP) will want to use cookie or http. There are a number of authentication methods we may want to choose depending on our specific needs.Step 8) You need to grant all database privileges to this user.įinally, you have to uncomment / add lines in config.inc. PhpMyAdmin requires a dedicated MySQL account. Open the authorization window (localhost/phpmyadmin/) and login with root account. The received file ( ) you should save to the root directory of phpmyadmin ( C:\inetpub\wwwroot\phpmyadmin). Step 6)Save the settings and then the server will redirect to the previous page. ![]() If necessary, you can specify other settings. ![]() Step 5) Enter the verbose name of the DB server, and then the server hostname. To configure the connection settings click on the “New Server” button. Step 3) To solve this problem you should create folder ( C:\inetpub\Step 4) Return to the config window. Visit localhost/phpmyadmin/setup/ in your browser.ĭuring your first session you may see an error message as below This file can be created manually (simply use a text editor), also user can use using GUI. Step 2 ) Before you connect to the DB server, you should create a configuration file. You cannot login just yet, we have to configure the setup. This can be any folder you wish to create in your IIS default or another site.įor this example we will consider it as C:\inetpub\wwwroot\phpmyadminĪfter Installation of phpMyAdmin, open a browser and check browser for you will see a window like this: You should download a file with all languages (the file name ends with *all-languages.7z or *all-languages.zip).Įxtract the files from the archive to phpmyadmin folder Step 1) Considering you have already have IIS Windows server with PHP support and have a running instance of MySQL.ĭownload the latest version of phpMyAdmin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |