add account, but can login

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

add account, but can login

Postby baseball » 31. March 2014 04:30

Dear :
I use xampp-win32-1.8.2-4-VC9-installer.exe in xp

I can login by root.
so, I create a new account :aaa ,password: aaa ,and set ALL PRIVILEGES, and host:%
Now, I want to use aaa to login from phpmyadmin
but it show #1045 Cannot log in to the MySQL server.

so, It can only login by root, not by other account.
baseball
 
Posts: 5
Joined: 28. March 2014 09:26
Operating System: XP

Re: add account, but can login

Postby Altrea » 01. April 2014 05:19

Hi,

The full error message would be helpful...
Change host of that user from % to localhost

Best wishes,
Altrea
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: add account, but can login

Postby baseball » 02. April 2014 01:17

Dear Altrea:
Thx for your help!
baseball
 
Posts: 5
Joined: 28. March 2014 09:26
Operating System: XP


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 18 guests