Which password on mysql upgrade?
murrayeisenberg at gmail.com
Fri Oct 27 16:26:57 UTC 2017
I’m upgrading msql56 -> mysql57.
Step 6 in Documentation at https://trac.macports.org/wiki/howto/MySQL <https://trac.macports.org/wiki/howto/MySQL> says:
"If the database exists from a previous installation, you may need to upgrade.”
After unloading mysql57-server, as recommended there I execute:
sudo /opt/local/lib/mysql57/bin/mysql_upgrade -u root -p
After Question: which password should be entered in response to the prompt: my macOS admin account’s password or the mysql root’s password?
Or, if both are required, which do I enter first?
If I just enter my macOS admin account’s password, I get error”
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/opt/local/var/run/mysql57/mysqld.sock' (2)
while connecting to the MySQL server
Upgrade process encountered error and will not continue.
On the other hand, if I start mysql57-server and then execute
mysql -u root -p
and give the mysql database root password, I can successfully interact with the mysql sever (e.g., “show databases”).
Murray Eisenberg murrayeisenberg at gmail.com
503 King Farm Blvd #101 Home (240)-246-7240
Rockville, MD 20850-6667 Mobile (413)-427-5334
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the macports-users