Search this site

Tuesday, February 4, 2014

Enable login in phpmyadmin

Now I want to enable login in my phpmyadmin

First change root password (both) using phpmyadmin
Then after you change it, it will send you an error message
Open this file
C:\xampp\phpMyAdmin\config.inc.php
Change the line 19
$cfg['Servers'][$i]['auth_type'] = 'config';
To
$cfg['Servers'][$i]['auth_type'] = 'cookie';
And also line 23
$cfg['Servers'][$i]['AllowNoPassword'] = true;
To
$cfg['Servers'][$i]['AllowNoPassword'] = false;
After that restart you apache
Done
 

Change phpmyadmin's URL in XAMPP windows

I just setting my phpmyadmin in windows
I installed it using XAMPP

And I want to change the phpmyadmin's URL
default: 127.0.0.1/phpmyadmin and I want to change it to 127.0.0.1/myownlink

It's not hard
just open this file
C:\xampp\apache\conf\extra\httpd-xampp.conf
 In line 99
Alias /phpmyadmin "C:/xampp/phpMyAdmin/"
Change it to
 Alias /myownlink "C:/xampp/phpMyAdmin/"

And don't forget to restart your apache in XAMPP
Done