You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Error 1045 mysql new installation on OSX 10.9.3

after new mysql-5.7.4-m14-osx10.7-x86_64 installation,


I typed "/usr/local/mysql/bin/mysql" I got "ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: NO)"

I type "ps auxww | grep mysql", I got"

_mysql 224 0.0 6.6 3188416 552216 ?? S 7:58pm 0:01.50 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/Dongs-MacBook-Pro.local.err --pid-file=/usr/local/mysql/data/Dongs-MacBook-Pro.local.pid --socket=/var/mysql/mysql.sock --port=8888

root 65 0.0 0.0 2461016 1064 ?? Ss 7:58pm 0:00.04 /bin/sh /usr/local/mysql/bin/mysqld_safe --user=mysql

dongzhong 594 0.0 0.0 2432784 604 s000 S+ 8:56pm 0:00.00 grep mysql"


I type "sudo nano /Library/LaunchDaemons/com.mysql.mysql.plist", I got

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-$

<plist version="1.0">

<dict>

<key>KeepAlive</key>

<true/>

<key>Label</key>

<string>com.mysql.mysqld</string>

<key>ProgramArguments</key>

<array>

<string>/usr/local/mysql/bin/mysqld_safe</string>

<string>--user=mysql</string>

</array>

</dict>

</plist>

I also have turned on my internet sharing but still access denial. Please help me

Posted on Jun 30, 2014 6:28 PM

Reply
Question marked as Top-ranking reply

Posted on Jul 20, 2014 1:56 PM

Take a look at this article.

http://www.howtoforge.com/reset-forgotten-mysql-root-password

I tried this with mysql 5.7.4 (Milestone 14) and OS X 10.10 (Yosemite) and it works. It should work on 10.9 too (though I haven't tried it on Mavericks).


5.7.4 installs with a randomly generated password for mysql root. On Linux RPM installs, this initial password is stored in /etc/mysql/.mysqlsecret - which you are supposed to use for the initial login. Couldn't find it's equivalent anywhere on OS X. Will file a bug report with MySQL.

2 replies
Question marked as Top-ranking reply

Jul 20, 2014 1:56 PM in response to codeisfun

Take a look at this article.

http://www.howtoforge.com/reset-forgotten-mysql-root-password

I tried this with mysql 5.7.4 (Milestone 14) and OS X 10.10 (Yosemite) and it works. It should work on 10.9 too (though I haven't tried it on Mavericks).


5.7.4 installs with a randomly generated password for mysql root. On Linux RPM installs, this initial password is stored in /etc/mysql/.mysqlsecret - which you are supposed to use for the initial login. Couldn't find it's equivalent anywhere on OS X. Will file a bug report with MySQL.

Error 1045 mysql new installation on OSX 10.9.3

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.