Eu precisava da versão 5.7 do servidor mysql para um projeto. Eu atualizei da versão 5.5 para 5.7 usando este tutorial . A atualização foi bem-sucedida e eu posso usar a versão atualizada via linha de comando. No entanto, os navegadores mysql (mysql-workbench como sqlyog e phpmyadmin) pararam de funcionar após a atualização.
Workbench diz:
Table 'performance_schema.session_variables' doesn't exist
Eu consigo fazer o login usando o PHPMyAdmin, mas não consigo selecionar nenhum banco de dados. Diz
SELECT * FROM data_dictionary.CHARACTER_SETS
MySQL said: Documentation
#1146 - Table 'data_dictionary.CHARACTER_SETS' doesn't exist
Durante o upgrade, a seguinte mensagem apareceu.
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.
o que me fez pensar que é porque nenhum cliente mysql está disponível agora. Por favor me avise como corrigir isso e colocar meu cliente mysql em funcionamento.
Eu não consigo instalar o libmysqlclient, tentei reinstalar o phpmyadmin sem sorte.
Estou usando o Ubuntu 14.04 (32 bits) versão do MySQL após a atualização:
mysql Ver 14.14 Distrib 5.7.8-rc, for Linux (i686) using EditLine wrapper
Obrigado
Conclua os registros de atualização:
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) ...