Issue w- MySQL 5.75 on OSX 10.10 - can't find .mysql_secret 1

[admoore]

I installed MySQL 5.75 on OSX 10.10 and it is up and running successfully; but, following execution of mysql_install_db I can not locate .mysql_secret anywhere... I double checked the home env variable to make sure as well as searched via spotlight etc... It simpley does not seem to exist; but, the data directory WAS created successfully...

Ideas?

TIA,

-Allen M.

 

[jpadie]

Open up terminal.

Type this

sudo find / -n ".mysql_secret"

Enter your password at the prompt and after a while it should give you the path to the file.

Different installation mechanisms may not use the random-password flag. So you might also try that old fruit of root:root as userwd on local installs.

 

[admoore]

Thanks for sudo find suggestion...

Found it at /private/var/root/.mysql_secret but password isn't being accepted for user 'root'@'localhost' (using password: YES)

Re ran mysql_install_db to re-create the data dir and a new random password and it still isn't being accepted...

Not sure what now- restarted daemon and still not accepting root password created in .mysql_secret

Open to ideas...

 

[jpadie]

that is most odd as the installation would normally be run as your user and not as root (which is not typically an enabled account on macs)

there are four solutions that come to mind.

mysql --host=127.0.0.1 --user=root -p

hopefully that should accept the password in the secret file. the difference here is that you are specifying a tcp connection whereas using the localhost keyword causes the client to default to a socket. if there is any possibility of two versions of mysql installed then this could cause confusion.

incidentally running this command

which mysql

could help diagnose this if you see the mysql being located in an unforeseen folder.

the second solution is to rerun the install_db script and suppress the password generation. to do this add the --insecure option to the install statement. or specify where the random password should be written

--random-password-file=/Users/myUser/Desktop/myRandomMysqlPassword.txt

the third is to reset the password

sudo su
killall mysqld
mysqld --skip-grant-tables --skip-networking
mysql
//from the mysql prompt
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES
exit;
//from the terminal
killall mysqld

then restart mysql in the way you normally would (without the security bypasses).

4. uninstall mysql and reinstall it through MAMP. I've been using MAMP for years and not once has it given me any strife.

 

[admoore]

mysqld --skip-grant-tables --skip-networking doesn't seem to work with MySQL 5.75 and doubt it's available w- MAMP. Will probably try to re-install. I need 5.75 for the new GIS functions...

 

[jpadie]

skip grant tables is available:

http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_skip-grant-tables

the version of mamp i have is 5.5.34. i see no difficulty in upgrading that to whatever arbitrary version.

 

[admoore]

reinstalling it fixed it... but for successful install you must un-check the create startup item option with OSX 10.10