All we need is an easy explanation of the problem, so here it is.
i have installed mysql 8.0.12 into one linux node and when i try to give below grant permission to get access from other nodes, i am getting 42000 error
command issued :
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
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 ‘secure1t” at line 1
Any help would be appreciated.
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
You don’t use
IDENTIFIED BY in
GRANT queries, it’s used in
CREATE USER 'root'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
GRANT command reference
CREATE USER command reference
GRANT ALL PRIVILEGES ON your_desired_database_name.* TO 'root'@'localhost';
**This worked for me and will work for you
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂