can't login then using second user in mysql

Problems with the Windows version of XAMPP, questions, comments, and anything related.

can't login then using second user in mysql

Postby zacken542 » 09. April 2013 20:56

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
zacken542
 
Posts: 3
Joined: 09. April 2013 16:48
Operating System: windows x64

Re: can't login then using second user in mysql

Postby Altrea » 09. April 2013 21:08

Change host of that user from % (any) to localhost
More to read viewtopic.php?f=16&t=52384&p=201304#p201304
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: can't login then using second user in mysql

Postby zacken542 » 10. April 2013 07:11

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

Thanks

Sven-Åke
zacken542
 
Posts: 3
Joined: 09. April 2013 16:48
Operating System: windows x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 134 guests