我的一个项目需要 mysql 服务器 5.7 版本。我使用以下方法将 5.5 版本升级到了 5.7 版本本教程。升级成功,我可以通过命令行使用更新后的版本。但是,mysql 浏览器(mysql-workbench、sqlyog 以及 phpmyadmin)在升级后停止工作。
工作台说道:
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) ...