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