cabriofahrer
Well-Known Member
Wollte mein System mittels "pkg upgrade" upgraden. Bezüglich mysql steht in UPDATNG Folgendes:
Die Schritte
# pkg set -o databases/mysql56-client:databases/mysql57-client
# pkg set -o databases/mysql56-server:databases/mysql57-server
Hatte ich deshalb vor dem Upgrade ausgeführt. In pkg info -D mysql57-server steht:
Ein # mysql-upgrade ergibt aber eine Fehlermeldung:
Was nun?
Code:
20190701:
AFFECTS: users of databases/mysql56-(server|client)
AUTHOR: ale@FreeBSD.org
The default MySQL version has been updated from 5.6 to 5.7.
If you compile your own ports you may keep 5.6 as the default version by
adding the following lines to your /etc/make.conf file:
#
# Keep MySQL 5.6 as default version
#
DEFAULT_VERSIONS+=mysql=5.6
If you wish to update to the new default version, you need to first stop any
running server instance. Then, you will need to follow these steps, depending
on installed packages.
# pkg set -o databases/mysql56-client:databases/mysql57-client
# pkg set -o databases/mysql56-server:databases/mysql57-server
# pkg upgrade
Die Schritte
# pkg set -o databases/mysql56-client:databases/mysql57-client
# pkg set -o databases/mysql56-server:databases/mysql57-server
Hatte ich deshalb vor dem Upgrade ausgeführt. In pkg info -D mysql57-server steht:
Code:
$ pkg info -D mysql57-server
mysql57-server-5.7.27:
On install:
Initial password for first time use of MySQL is saved in $HOME/.mysql_secret
ie. when you want to use "mysql -u root -p" first you should see password
in /root/.mysql_secret
MySQL57 has a default %%ETCDIR%%/my.cnf,
remember to replace it wit your own
or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.
On upgrade:
Remember to run mysql_upgrade the first time you start the MySQL server
after an upgrade from an earlier version.
Ein # mysql-upgrade ergibt aber eine Fehlermeldung:
Code:
# mysql_upgrade
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
Was nun?