MySQL version upgrade [SOLVED]

[Jos Chrispijn]

[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