Murray, This is the mysql root password. MySQL has no knowledge of your OS password.
Marius -- Marius Schamschula > On Oct 27, 2017, at 11:26 AM, Murray Eisenberg <[email protected] > <mailto:[email protected]>> wrote: > > 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] > <mailto:[email protected]> > 503 King Farm Blvd #101 Home (240)-246-7240 > Rockville, MD 20850-6667 Mobile (413)-427-5334 > >
