Which password on mysql upgrade?

[Marius Schamschula]

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 <murrayeisenberg at gmail.com <mailto:murrayeisenberg at gmail.com>> 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			murrayeisenberg at gmail.com <mailto: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...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20171027/306f0151/attachment.html>