Date: Thu, 18 Jul 2013 04:09:41 GMT From: Chris H <bsd-lists@1command.com> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/180624: mysql_upgrade man, and upgrade/install info missing manditory information Message-ID: <201307180409.r6I49fh4021980@oldred.freebsd.org> Resent-Message-ID: <201307180410.r6I4A0pd042362@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 180624 >Category: ports >Synopsis: mysql_upgrade man, and upgrade/install info missing manditory information >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Thu Jul 18 04:10:00 UTC 2013 >Closed-Date: >Last-Modified: >Originator: Chris H >Release: 8.4-STABLE >Organization: >Environment: FreeBSD udns 8.4-STABLE FreeBSD 8.4-STABLE #3: Tue Jul 2 13:41:21 PDT 2013 root@udns:/usr/obj/usr/src/sys/AMD64 amd64 >Description: I recently performed an upgrade/update, which required upgrading mysql-server from mysql-server-5.5.30 --> mysql-server-5.5.32. At the end of the process, the message indicated it was necessary to perform mysql_ugrade(1). Doing so, led to the following: mysql_upgrade -u root --verbose Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed _extremely_ informative -- no? So what to do? A quick check of the server, and the databases indicate all appear to normal. Conclusion; dismiss the mysql_upgrade(1) as being broken, and forget about it. The man(1) pages reveal nothing pertinent, in fact they are essentially the same page as: http://dev.mysql.com/doc/refman/5.5/en/mysql-upgrade.html with one _major_ exception; the user comments at the end. In particular; the one at the end: mysql_upgrade -u root -p The -p makes all the difference. But unlike: mysql -u root add ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) The omission of the -p does _not_ provide an informative error, as mysql, and all of it's other utilities _do_. Please make references to this in both the mysql_upgrade(1) man(1) page && the install/upgrade message emitted at the end of the install/upgrade. Additional reference: http://forums.freebsd.org/showthread.php?t=40884 Thank you for all your time, and consideration. >How-To-Repeat: Attempt to upgrade mysql-server, or upgrade mysql-client 5.5 >Fix: print a message after the upgrade has finished, indicating that the options -u root -p MUST be used when executing mysql_upgrade. This information should also be included within the man page(s). >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201307180409.r6I49fh4021980>