Mysql -uroot error 1045 (28000): access denied for user 'root'@'localhost' mac

broken image
broken image

I am able to access mysql via a MySQL client and a non-root user. After restarting, trying mysql -u root still produces the same error. I then restart the computer (killing the process with CMD + C doesn’t work). Then from in mysql: update er set password_expired = 'N', authentication_string=PASSWORD('newpassword') where user = 'root' I opened a second tab and entered: mysql -u root To try and resolve it I stopped mysql from ‘System Preferences’, then from terminal typed: sudo mysqld_safe -skip-grant-tables From terminal I enter: mysql -u rootĮRROR 1045 (28000): Access denied for user (using password: NO) I’m on Mac OSX (Sierra 10.12.3) trying to create a new database and user.

broken image

I’ve tried multiple solutions from StackOverflow but haven’t had any success.

 

PreviousNext
Cookie Use
We use cookies to improve browsing experience, security, and data collection. By accepting, you agree to the use of cookies for advertising and analytics. You can change your cookie settings at any time. Learn More
Accept all
Settings
Decline All
Cookie Settings
Necessary Cookies
These cookies enable core functionality such as security, network management, and accessibility. These cookies can’t be switched off.
Analytics Cookies
These cookies help us better understand how visitors interact with our website and help us discover errors.
Preferences Cookies
These cookies allow the website to remember choices you've made to provide enhanced functionality and personalization.
Save