[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
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
