From owner-freebsd-doc@FreeBSD.ORG Wed Jul 17 17:06:30 2013 Return-Path: Delivered-To: freebsd-doc@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id CC82B41E for ; Wed, 17 Jul 2013 17:06:30 +0000 (UTC) (envelope-from bsd-lists@1command.com) Received: from udns.ultimateDNS.NET (ultimatedns.net [209.180.214.225]) by mx1.freebsd.org (Postfix) with ESMTP id 9E95DE17 for ; Wed, 17 Jul 2013 17:06:30 +0000 (UTC) Received: from udns.ultimateDNS.NET (localhost [127.0.0.1]) by udns.ultimateDNS.NET (8.14.5/8.14.5) with ESMTP id r6HH6eGl011183 for ; Wed, 17 Jul 2013 10:06:46 -0700 (PDT) (envelope-from bsd-lists@1command.com) Received: (from www@localhost) by udns.ultimateDNS.NET (8.14.5/8.14.5/Submit) id r6HH6Zf7011182; Wed, 17 Jul 2013 10:06:35 -0700 (PDT) (envelope-from bsd-lists@1command.com) Received: from udns.ultimatedns.net ([209.180.214.225]) (UDNSMS authenticated user chrish) by ultimatedns.net with HTTP; Wed, 17 Jul 2013 10:06:35 -0700 (PDT) Message-ID: <277961ac69def97aea03aa52dae647cb.authenticated@ultimatedns.net> Date: Wed, 17 Jul 2013 10:06:35 -0700 (PDT) Subject: mysql_upgrade man, and upgrade/install info missing manditory information From: "Chris H" To: "freebsd-doc" User-Agent: UDNSMS/2.0.3 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-BeenThere: freebsd-doc@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Documentation project List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 17 Jul 2013 17:06:30 -0000 Greetings, 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. --chris