Now that the login password has been set, we can kill the safe server: $ killall mysqld You may notice that in MySQL 5.7.6+ the password field has been changed to authentication_string. Mysql> UPDATE user SET authentication_string=PASSWORD('') WHERE User = 'root' Next we will enter the MySQL command line and ask the server to change the remove the password for the "root" user. We use the -skip-grant-tables option to prevent permission errors when trying to update the password later. Now that MySQL has stopped running, you can start the mysqld_safe process. Lines prefixed with "mysql >" are entered in the MySQL command line client.Īlso unload the launchctl file, if you have one, to prevent the server restarting: $ launchctl unload ~/Library/LaunchAgents/.Lines prefixed with "$" are a terminal command.Run the following highlighted steps in the Terminal. Personally after installing through Homebrew I did not know the default password and wanted to set up the server to accept the root user with no password, for my development environment. This new version of MySQL has some security features and syntax changes that may be confusing. This is an upgrade from the 5.6.x versions that brew would install on previous OS X versions. The MySQL version that will be installed through Homebrew for El Capitan is currently version 5.7.9. Published on Wednesday 18th of November, 2015 Login as root with no password on MySQL 5.7.9 with El Capitan (Homebrew)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |