Forum
mysqli::real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
Open and edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distribution.
Add
skip-grant-tables under [mysqld]
Restart MySQL
You should be able to log in to MySQL now using the below command mysql -u root -p
Run mysql>
flush privileges;
Set new password by
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
Go back to /etc/my.cnf and remove/comment skip-grant-tables
Restart MySQL
Now you will be able to login with the new password mysql -u root -p
4 Replies
Decker Bradley·
The substance of the essay is intriguing; I value how well the topic is covered, and I really hope that your work receives geometry dash a lot of attention.
Manning Bennie·
It was a really helpful and very informative blog. It really helps me a lot but if you want to also learn only up something new and interesting.
john cena·
If you want to enjoy the company of a beautiful Call Girls in Goa without spending a fortune, then you should definitely consider hiring a Goa Escorts . Prices for these services vary depending on the escort's level of experience and looks, but you can expect to pay anywhere from Rs. 2000 to Rs. 10,000 for an hour of her time. Of course, the more you're willing to spend, the better the quality of escort you'll be able to book.
