![]() Once you’ve done that just exit the console “exit ” close the safe_mysqld execution and restart your MySQL server. Replace “YOUR_PASSWORD” with your desired password. Write the reset query into the console as follows UPDATE user SET Password=PASSWORD(‘YOUR_PASSWORD’) WHERE Host=’localhost’ AND User=’root’. This opening up the MySQL console and opening the mysql table so we can update MySQL root user. Now when safe_mysqld running in one Terminal window, open up another Terminal window and execute /usr/local/mysql/bin/mysql mysql. If you have installed MySQL5, fire up Terminal window and execute /usr/local/mysql/bin/mysqld_safe -skip-grant-tables For older versions of MySQL, execute the following command /usr/local/mysql/bin/safe_mysqld -skip-grant-tables You can do that using the preference pane if you have that installed or you can stop it using Terminal sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop Feel free to use TextEdit if you are not familiar with vi. sudo cp /etc/apache/nf /etc/apache/ diff /etc/apache/-update /etc/apache/nf Now edit the Apache configuration. So to fix this had to update my root password and here is how l did it First, create a backup and compare the two configuration files for differences. After that do launchctl load ~/path/to/ a strange issue where mysql started asking for a password for my local mysql after updating my mysql2 gem. Install Stuff Step 2 SQL Management Tool Now that you have an operational MySQL server. ![]() If you actually want to make mysql start at boot time, you can take that plist and copy it, delete the KeepAlice line, replace the string values under ProgramArguments with /usr/local/bin/rver and start. Step 1 is complete when the MySQL instance bubbles go from red to green. If you want to follow my steps, this is what you need to do: launchctl unload ~/Library/LaunchAgents/Īnd whenever you want to start the mysql server, use rver start. Rather, I just use the rver tool to start, stop, and restart mysql. The solution I came up with is to not use launchd for mysql from brew. I don't know if actually because of that is different from what you control with rver. ![]() It basically doesn't work, because (from my poor understanding) mysqld is now managed by launchd, and it is mysqld_safe. Ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents Following homebrew caveats, did you setup launchd? To have launchd start mysql at login: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |