MySQL Forums
Forum List  »  General

Re: Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Peter Brawley
Date: May 27, 2021 10:53AM

Quote

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '%password%' WITH GRANT OPTION;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY '%password%' WITH GRANT OPTION' at line 1

Read again the manual pages on Create User and Grant. Create the user with an Identified By... clause., then no Identified By... clause with Grant.

Don't use wildcards in passwords.

If you can log into WB, issue there ...

select host,authentication_string,plugin from mysql.user
where user='root';

select user();

... and let's see the result.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.