问:需要一个项目的mysql服务器5.7版。我使用本教程从5.5版本升级到5.7 。升级成功,我可以通过命令行使用更新的版本。但是,升级后,mysql浏览器(sqllyog和phpmyadmin以及mysql-workbench)停止工作。
工作台说:
Table 'performance_schema.session_variables' doesn't exist
我可以使用PHPMyAdmin登录,但无法选择任何数据库。它说
SELECT * FROM data_dictionary.CHARACTER_SETS
MySQL said: Documentation
#1146 - Table 'data_dictionary.CHARACTER_SETS' doesn't exist
在升级过程中,出现以下消息。
dpkg: mysql-client-5.5: dependency problems, but removing anyway as you requested:
mysql-workbench depends on mysql-client; however:
Package mysql-client is not configured yet.
Package mysql-client-5.5 which provides mysql-client is to be removed.
这让我觉得是因为现在没有mysql客户端可用。请告诉我如何解决此问题,并使我的mysql客户端启动并运行。
我无法安装libmysqlclient,尝试重新安装phpmyadmin时没有运气。
升级后,我正在使用Ubuntu 14.04(32位)MySQL版本:
mysql Ver 14.14 Distrib 5.7.8-rc, for Linux (i686) using EditLine wrapper
谢谢
完整的升级日志:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'mysql-community-server' instead of 'mysql-server-5.7'
The following extra packages will be installed:
libmecab2 mysql-client mysql-common mysql-community-client mysql-server
The following packages will be REMOVED:
mysql-client-5.5 mysql-client-core-5.5 mysql-server-5.5
mysql-server-core-5.5
The following NEW packages will be installed:
libmecab2 mysql-client mysql-community-client mysql-community-server
The following packages will be upgraded:
mysql-common mysql-server
2 upgraded, 4 newly installed, 4 to remove and 26 not upgraded.
Need to get 24.5 MB of archives.
After this operation, 107 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7-dmr mysql-server i386 5.7.8-rc-1ubuntu14.04 [12.0 kB]
Get:2 http://in.archive.ubuntu.com/ubuntu/ trusty/universe libmecab2 i386 0.996-1.1 [237 kB]
Get:3 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7-dmr mysql-common i386 5.7.8-rc-1ubuntu14.04 [548 kB]
Get:4 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7-dmr mysql-client i386 5.7.8-rc-1ubuntu14.04 [12.0 kB]
Get:5 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7-dmr mysql-community-client i386 5.7.8-rc-1ubuntu14.04 [7,591 kB]
Get:6 http://repo.mysql.com/apt/ubuntu/ trusty/mysql-5.7-dmr mysql-community-server i386 5.7.8-rc-1ubuntu14.04 [16.1 MB]
Fetched 24.5 MB in 10min 46s (37.9 kB/s)
Preconfiguring packages ...
(Reading database ... 1363890 files and directories currently installed.)
Preparing to unpack .../mysql-server_5.7.8-rc-1ubuntu14.04_i386.deb ...
Unpacking mysql-server (5.7.8-rc-1ubuntu14.04) over (5.5.47-0ubuntu0.14.04.1) ...
(Reading database ... 1363890 files and directories currently installed.)
Removing mysql-server-5.5 (5.5.47-0ubuntu0.14.04.1) ...
mysql stop/waiting
Removing mysql-server-core-5.5 (5.5.47-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
(Reading database ... 1363728 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.7.8-rc-1ubuntu14.04_i386.deb ...
Unpacking mysql-common (5.7.8-rc-1ubuntu14.04) over (5.5.47-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-client.
Preparing to unpack .../mysql-client_5.7.8-rc-1ubuntu14.04_i386.deb ...
Unpacking mysql-client (5.7.8-rc-1ubuntu14.04) ...
dpkg: mysql-client-5.5: dependency problems, but removing anyway as you requested:
mysql-workbench depends on mysql-client; however:
Package mysql-client is not configured yet.
Package mysql-client-5.5 which provides mysql-client is to be removed.
(Reading database ... 1363817 files and directories currently installed.)
Removing mysql-client-5.5 (5.5.47-0ubuntu0.14.04.1) ...
Removing mysql-client-core-5.5 (5.5.47-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Selecting previously unselected package mysql-community-client.
(Reading database ... 1363762 files and directories currently installed.)
Preparing to unpack .../mysql-community-client_5.7.8-rc-1ubuntu14.04_i386.deb ...
Unpacking mysql-community-client (5.7.8-rc-1ubuntu14.04) ...
Selecting previously unselected package libmecab2.
Preparing to unpack .../libmecab2_0.996-1.1_i386.deb ...
Unpacking libmecab2 (0.996-1.1) ...
Selecting previously unselected package mysql-community-server.
Preparing to unpack .../mysql-community-server_5.7.8-rc-1ubuntu14.04_i386.deb ...
.
Unpacking mysql-community-server (5.7.8-rc-1ubuntu14.04) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for ureadahead (0.100.0-16) ...
ureadahead will be reprofiled on next reboot
Setting up mysql-common (5.7.8-rc-1ubuntu14.04) ...
Installing new version of config file /etc/mysql/my.cnf ...
Setting up mysql-community-client (5.7.8-rc-1ubuntu14.04) ...
Setting up mysql-client (5.7.8-rc-1ubuntu14.04) ...
Setting up libmecab2 (0.996-1.1) ...
Setting up mysql-community-server (5.7.8-rc-1ubuntu14.04) ...
Installing new version of config file /etc/apparmor.d/usr.sbin.mysqld ...
Installing new version of config file /etc/init.d/mysql ...
No directory, logging in with HOME=/
.....
* MySQL Community Server 5.7.8-rc is started
Processing triggers for ureadahead (0.100.0-16) ...
Setting up mysql-server (5.7.8-rc-1ubuntu14.04) ...
Processing triggers for libc-bin (2.19-0ubuntu6.7) ...
答:尝试使用命令:
须藤mysql_ upgrade -u root -p --force --upgrade-system-tables
然后使用以下命令重新启动mysql服务器:
sudo服务mysqld重新启动
谢谢