Saturday, July 26, 2014

Setup phpMyAdmin for your freshly installed MySQL server

Download phpmyadmin to your machine. Unzip the file. Inside phpmyadmin folder there is a file config.sample.inc.php rename the file to config.inc.php

Open config.inc.php file and Change

$cfg['Servers'][$i]['host'] = 'localhost';

to

$cfg['Servers'][$i]['host'] = '127.0.0.1';




then Change

$cfg['Servers'][$i]['AllowNoPassword'] = false;

to

$cfg['Servers'][$i]['AllowNoPassword'] = true;


Now try opening phpmyadmin inside browser. Since your mysql is freshly installed it will have an empty password. Login phpmyadmin with

Username: root

and leave Password empty. Click Go button and here you go. You have successfully configured your phpmyadmin to work with mysql server.

No comments:

Post a Comment