GRANT ALL PRIVILEGES ON *.*

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

GRANT ALL PRIVILEGES ON *.*

Postby spotter » 29. April 2014 09:26

Hi everyone, I am trying to create a root user in phpmyadmin, and grant all privileges.

i am executing the following sql command

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' WITH GRANT OPTION;

the sql query is accepted, but when i try to connect to the database i get the error
Access denied for user 'root'@'localhost' (using password: YES)

please help
spotter
 
Posts: 1
Joined: 29. April 2014 09:21
Operating System: windows server 2008

Re: GRANT ALL PRIVILEGES ON *.*

Postby JJ_Tagy » 29. April 2014 11:16

Looks like it is telling you your password is wrong. Maybe you shouldn't manually enter a hash.
JJ_Tagy
 
Posts: 678
Joined: 30. January 2012 13:44
Operating System: Windows 10 Pro x64

Re: GRANT ALL PRIVILEGES ON *.*

Postby Altrea » 29. April 2014 13:25

Don't use the Wildcard (%) for host.
Read more about priority of MySQL users here: 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: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: hthnightwolf and 60 guests