![]() Mysql> ALTER USER IDENTIFIED BY 'super-secret-password' Launchctl load /Library/LaunchDaemons/.istĪfter MySQL is started again, you can log into the CLI and reset the password: Restart MySQL, so skip-grant-tables becomes active: Launchctl unload /Library/LaunchDaemons/.ist Save the configuration file! (In vi this is " + :x") Shell> vi /usr/local/mysql/support-files/my-default.cnf You MUST work as root for all the following steps. ![]() A my.cnf can be found in /usr/local/mysql/support-files. Put skip-grant-tables into the mysqld section of the my.cnf. ![]() These problems occur especially, if you have no access to the GUI. Since the Apple OS has a rather peculiar way of starting and stopping MySQL, compared to Linux, you can run into some issues. This one is for all MySQL-DBA's, which are working on macOS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |