Apache Friends Support Forum

latest xampp, windows 8 x64

I have changed config.inc.php

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

I have setup root password via security
that works!
but after that I created a new user (zacken) via phpadmin

Code: Select all

    zacken    %    Ja    ALL PRIVILEGES    Ja    Ändra privilegier Ändra privilegier   Exportera Exportera

Ja = yes
but I can't login to mysql via

Code: Select all

mysql -u root -h 127.0.0.1 -P 3306 -p

if I give password it's say

Code: Select all

ERROR 1045 (28000): Access denied for user 'zacken'@'localhost' (using password: YES)

without password it works , I guess I logon as guest with no privilige

but why can't I use second user zacken?
what do I missing?

Sven-Åke

Change host of that user from % (any) to localhost
More to read viewtopic.php?f=16&t=52384&p=201304#p201304

Change host of that user from % (any) to localhost

Thanks

Sven-Åke