{"id":446,"date":"2011-05-06T11:11:42","date_gmt":"2011-05-06T01:11:42","guid":{"rendered":"http:\/\/howden.net.au\/thowden\/?p=446"},"modified":"2011-05-06T11:11:42","modified_gmt":"2011-05-06T01:11:42","slug":"mysql-php-upgrade-centos-server","status":"publish","type":"post","link":"https:\/\/howden.net.au\/thowden\/2011\/05\/mysql-php-upgrade-centos-server\/","title":{"rendered":"MySQL &amp; PHP Upgrade CentOS server"},"content":{"rendered":"<p>I now appear to have a new Linux VPS running with CentOS and Plesk. I wont go into the stupid details of why this has taken 2 weeks to provision, or another 2 days for me to &#8216;fix&#8217; the ip addresses etc, only to find that CentOS has an older version of PHP at 5.1 and MySQL needing to be upgraded to match with PHP 5.3 when I tried to upgrade.<\/p>\n<p>I referenced <a title=\"Montoya upgrade PHP CentOS Plesk\" href=\"http:\/\/www.christianmontoya.com\/2008\/10\/01\/upgrading-php-and-installing-apc-on-centos-5-with-plesk\/\">Christian Montoya&#8217;s blog<\/a> for the update for PHP but found that I had a couple of issues.<\/p>\n<p>The first was that when I ran the yum command for the PHP upgrade it complained about the MySQL support \/ version.<\/p>\n<blockquote>\n<pre>yum update php<\/pre>\n<\/blockquote>\n<p>was changed to include MySQL<\/p>\n<blockquote>\n<pre>yum update php mysql<\/pre>\n<\/blockquote>\n<p>Which did what I needed.<\/p>\n<p>Running the<\/p>\n<blockquote>\n<pre>php -v<\/pre>\n<\/blockquote>\n<p>Advised that the updated 5.3 version was installed but I then found that MySQL was not running.<\/p>\n<p>A quick wade around discovered that \/var\/log\/mysqld.log that there was another error preventing MySQL from starting. This was the message:<\/p>\n<blockquote>\n<pre>\n[ERROR] \/usr\/libexec\/mysqld: unknown option '--skip-bdb'\n<\/pre>\n<\/blockquote>\n<p>Editing the \/etc\/my.cnf file to comment out this option in both the main section and the mysql_safe section of the file fixed this issue and allowed MySQL to start.<\/p>\n<p>Next I had in the mysql log messages like:<\/p>\n<blockquote>\n<pre>[ERROR] Column count of mysql.proc is wrong. Expected 20, found 16. \nCreated with MySQL 50077, now running 50156. \nPlease use mysql_upgrade to fix this error.<\/pre>\n<\/blockquote>\n<p>So trying to use mysql_upgrade as a command by itself fails for user root@local host<\/p>\n<blockquote>\n<pre>\n]# mysql_upgrade\nLooking for 'mysql' as: mysql\nLooking for 'mysqlcheck' as: mysqlcheck\nRunning 'mysqlcheck with default connection arguments\nmysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when \ntrying to connect\nFATAL ERROR: Upgrade failed\n<\/pre>\n<\/blockquote>\n<p>Using the correct username is as simple as <\/p>\n<blockquote>\n<pre>#mysqlupgrade -u <em>username<\/em> -p  [Enter]<\/pre>\n<\/blockquote>\n<p>Which will prompt you for the password and then run the upgrade with the authenticated username.<\/p>\n<p>And that, I hope, completes the backend upgrade so I can run SugarCRM on this server.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I now appear to have a new Linux VPS running with CentOS and Plesk. I wont go into the stupid details of why this has taken 2 weeks to provision, or another 2 days for me to &#8216;fix&#8217; the ip addresses etc, only to find that CentOS has an older version of PHP at 5.1 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,5,10,18],"tags":[],"class_list":["post-446","post","type-post","status-publish","format-standard","hentry","category-apache","category-linux-servers-and-software","category-mysql","category-sugarcrm"],"_links":{"self":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts\/446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/comments?post=446"}],"version-history":[{"count":0,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts\/446\/revisions"}],"wp:attachment":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/media?parent=446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/categories?post=446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/tags?post=446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}