Mac Error 1045 (28000): Access Denied For User 'root@localhost'@'localhost' (using Password: Yes)

by

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO) on MAC OSX

I’m trying to reinstall mysql on my MAC OS X Yosemite. for this I followed the instruction as mentioned below
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/MySQL*
vim /etc/hostconfig and removed the line MYSQLCOM=-YES-
rm -rf ~/Library/PreferencePanes/MySQL*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*

I also tried
brew uninstall mysql

When I attempt to login as root WITHIN the pod (kubectl exec -it. stable/mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) #. Access denied for user 'root'@'localhost' (using password: YES). Any further update will cause the issue/pull request to no longer be.

2003 tmnt season 5 episode 6. Season 6 List of Teenage Mutant Ninja Turtles (2003 TV series) episodes The Ninja Tribunal arc was the fifth season of the 2003 Teenage Mutant Ninja Turtles animated series. It was originally intended to be the final season of the series, as its arc concluded the main series storyline. Watch Teenage Mutant Ninja Turtles (2003) - Season 5, Episode 6 - Membership Drive: The Justice Force is expanding, and ofcourse Turtle Titan wants to join. At the same time Stockman finds the. Teenage Mutant Ninja Turtles (2003) Season show reviews & Metacritic score: The Justice Force is expanding, and ofcourse Turtle Titan wants to join. At the same time Stockman finds the remains of Nano. Nano is alive again, but is he rea.

after this I installed mysql using homebrew using command brew install mysql.
After installation when I tried to run mysql -u root It throws the following error

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using
password: NO)

I didn’t set password for mysql.I don’t know what’s going wrong.Any suggestion will be appreciated. Thank you

Solutions/Answers:

Solution 1:

I installed mysql with homebrew and got the same problem as you because mysql has had an existing database with an existing password there. See this article for more details.

Solution 2:

Now sql generates an aliatory password that appears in the last screen.

we can change it

Solution 3:

I have resolved this issue for myself.

Please check my github with this link: https://github.com/LeVanTuan/access_sql

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using
password: YES/NO)

Fix bug access denied on macos 10.12 (Sierra)

install mysql (https://dev.mysql.com/downloads/mysql/) if already
installed, skip this step

Update password of ‘root’ to access.

Open Terminal (Launchpad -> Other -> Terminal or (Command + space) ->
Type ‘terminal’ )

Then type follow below:

export PATH=$PATH:/usr/local/mysql/bin/

sudo mysqld_safe –skip-grant-tables

then, restart Terminal (quit then open again)

then, keep type:

export PATH=$PATH:/usr/local/mysql/bin/

mysql -u root mysql

FLUSH PRIVILEGES;

ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘123456’;

q

sudo /usr/local/mysql/support-files/mysql.server start

extra: start mysql: sudo /usr/local/mysql/bin/mysqld_safe
–skip-grant-tables stop mysql: sudo /usr/local/mysql/support-files/mysql.server stop

I hope it will help you

References