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