[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
freebsd-questions@freebsd.org mailing list
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"

Reply via email to