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]
mysqld --defaults-file="my.ini" --skip-grant-tables --shared-memory
and
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
owners.
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>
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.
Subject
Written By
Posted
Re: Access denied for user 'root'@'localhost' (using password: YES)
June 01, 2021 10:06PM
Sorry, you can't reply to this topic. It has been closed.
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.