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 [email protected]
503 King Farm Blvd #101 Home (240)-246-7240
Rockville, MD 20850-6667 Mobile (413)-427-5334
