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 rename the file to

Open file and Change

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


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

then Change

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


$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