Jump to content
The Uniform Server Community

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


alejc
 Share

Recommended Posts

I can't create a privileged user "foo" password "foo", neither by MySQL console, Nor by PHPMyadmin (USAGE Grant No)

I am running Unicontroller.exe with administrator privileges, but this happens regardless of whether Unicontroller.exe is run with or without administrative privileges. In both cases the result is the same.
The root password is root and has ALL PRIVILEGES (Grant Yes)

SO:Windows 10/11 x64

I tested with versions 15_0_2_ZeroXV and 15_0_1_ZeroXV and both have this problem.

Trying to do it by CMD console:

C:\UniServerZ\core\mysql\bin>mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 8.2.0 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

PD: I disabled UAC but the problem persists

PD: This doesn't happen to me with Xampp or Wamp

How do I fix this problem? Thanks

bug1.png

bug2.png

bug3.png

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...