Arch Linux

passbe

Member

Registered: 2009-03-14

Posts: 74

Website

[SOLVED] phpmyadmin update broken

i am using a lamp setup on my local machine for web development. i have been using phpmyadmin for the last 3 weeks every day for atleast 5 hours without a hitch. i believe my box may have updated phpmyadmin, and now for the life of me i cannot get it to work. the error i recieve:

 MySQL said: Documentation
Cannot connect: invalid settings.

ok fair enough so its my configuration, but i have changed nothing in mysql or the configuration file, heres my configuration:

$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = True;

now running the following command:

mysql -h localhost -u root -p

allows me to login with those credentials (root with no password). so why is phpmyadmin not working ?

ps: also is there a way of enabling some sort of logging system with phpmyadmin.

Last edited by passbe (2009-06-22 05:42:45)

passbe

Member

Registered: 2009-03-14

Posts: 74

Website

Re: [SOLVED] phpmyadmin update broken

too anyone who has the same problem as me, the phpmyadmin guys have added another failsafe configuration item for blank passwords, therefore to login without any passwords for root you now must specify two options:

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = True;
$cfg['Servers'][$i]['AllowNoPassword'] = True;