Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 02 Jan 2009 18:13:22 +0100
From:      Jos Chrispijn <kernel@webrz.net>
To:        APseudoUtopia <apseudoutopia@gmail.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: MySQL version upgrade [SOLVED]
Message-ID:  <495E4B32.10203@webrz.net>
In-Reply-To: <27ade5280901020804l6bb8e89ehdcccc670634babb3@mail.gmail.com>
References:  <495E3551.40507@webrz.net> <27ade5280901020804l6bb8e89ehdcccc670634babb3@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help

[APseudoUtopia] Uit een eerder bericht van 2-1-2009 17:04 ::
> I'd recommend that you read up on the MySQL documentation on the
> subject of upgrading.
> I don't mean to be mean, but it's not exactly a FreeBSD issue :-P
I ofcourse was referring to the ports part of the whole story, sorry for 
not being clear about this.
What I did:

- Upgrade the MySQL client port and its dependencies first.
- Upgraded mysql-client
  %> portupgrade -o databases/mysql50-client -f mysql-client-\*
- Upgrade mysql-server
  %> portupgrade -o databases/mysql50-server -f mysql-server-\*
- Recompiled everything else that depends on mysql-client so that they 
all link against the upgraded shlib:
  %> portupgrade -Nfi -r mysql-client-\* -x mysql-client -x mysql-server
- Restarted my mysql-server and ran the mysql-upgrade program:
  %> mysql_upgrade -v -b /usr/local -d /var/db/mysql -u root

Then I checked /var/db/mysql/mysite.err to see if there were any obvious 
problems (...):

090102 17:58:45
[Warning] mysql.user table is not updated to new password format; 
Disabling new password usage until mysql_fix_privilege_tables is run

So I did a fix on my SQL tables:
  %> mysql_fix_privilege_tables --password=my_password

mysite.err: 
090102 18:07:39  mysqld started
090102 18:07:39  InnoDB: Started; log sequence number 0 2232580
090102 18:07:39 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.75'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: 
mysql-server-5.0.75

After this I tested all mysql client programs and am happy again :-)

-- Jos Chrispijn



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?495E4B32.10203>