MySQL Forums
Forum List  »  General

Re: Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Karen Goh
Date: June 01, 2021 10:06PM

Hi Peter,

I followed the steps described in that step and did this below:

# server_type=3
mysqld --defaults-file="my.ini" --skip-grant-tables --shared-memory


C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.23 MySQL Community Server - GPL

Copyright (c) 2000, 2021, 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

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select host,authentication_string,plugin from mysql.user where user='root';
ERROR 1142 (42000): SELECT command denied to user 'root'@'localhost' for table 'user'
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION

I still can't get it work. Hope you could advise me further. Tks.

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.