Solution for mysql_upgrade errno: 13

Are you upgrading MySQL, and seeing this?

[plain highlight="6,7"]
$ mysql_upgrade
Looking for ‘mysql’ as: mysql
Looking for ‘mysqlcheck’ as: mysqlcheck
Running ‘mysqlcheck’…
….
Could not create the upgrade info file ‘/usr/local/mysql/data/mysql_upgrade_info’
in the MySQL Servers datadir, errno: 13
[/plain]

Solution — run the script as root (so you’ll have permission to write to mysql_upgrade_info).

Related posts:

  1. Apache2, PHP, and MySQL on Mac OS X using MacPorts
    1. Install MacPorts Follow the instructions here: http://www.macports.org/install.php. 2. Install apache2 sudo port install apache2 Note that the macports instructions suggest installing the launchctl script now, but we’ll do that......
  2. HOWTO enable the query log on MySQL on Mac OS X
    Tailing the MySQL query log in real time can be a lifesaver for any developer, and it’s pretty easy to do: Make a file for the mysqld process to write......
  3. Simple MySQL backup to gmail on Ubuntu/Debian
    Backing up your MySQL database (if it’s a reasonable size, like < 100s of MB) can be done with a cronjob that runs mysqldump, gzip, and mpack. First set up......
  4. WordPress upgrade with svn sw
    Most likely, it’s time to upgrade your instance of wordpress (given their releases are every couple weeks). Backup the db and code: mkdir -p ~/.archive mysqldump blog | gzip &amp;amp;gt;......

This entry was posted in Technical HOWTOs and tagged . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">

Additional comments powered by BackType