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 Best 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 Best 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 ID.