Here are the steps to follow to fix it on Mac OS X 10.10.5 and MySQL v.5.7.10 • Stop mysqld: The easiest way to stop mysqld is via MySQL in “System Preferences”. Just open it, look for MySQL and hit “Stop MySQL Server” button. If you didn’t install this utility, you need to go with launchctl tool. Had the same problem with 5.7.9 and took me a long time to figure out the correct procedure to reset the 'root' password. Follow these instructions (taken with some minor corrections) from. Thanks to the author of artfulsoftware.com for this 1. In a terminal window stop MySQL (or use control panel) sudo /usr/local/mysql/support-files/mysql.server stop 2. Start the MySQL without privilege tables sudo mysqld_safe --skip-grant-tables 3. IN ANOTHER COMMAND WINDOW start the mysql client mysql 4. Find name of admin user (probably 'root'), update the password: select user,host,authentication_string from mysql.user; 5. Reset authentication_string; for admin user 'root' (or whatever the name is). ![]() Note: you cannot create users when running with skip-grant-tables) update mysql.user set authentication_string=PASSWORD('new_pass') where user='root'; flush privileges; exit; 6. Stop mysqld, in another command window mysqladmin shutdown 7. Accessing MySQL on a Mac To use MySQL, everything is done in the Terminal, under Applications > Utilities > Terminal. Once Terminal is loaded, create an alias for MySQL. Apr 24, 2018 - This article is based on macOS High Sierra version: 10.13.4 and hopefully. Now, you may probably get permission denied error, which looks like this. Mysql> Td ameritrade app for mac. ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'. Restart MySQL: sudo /usr/local/mysql/support-files/mysql.server start.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |