좋아요, 저는 MySQL Server 5.5.37에서 Percona Server 5.6으로 마이그레이션하기로 결정했습니다. 나는 다음과 같이 MySQL 서버를 제거했습니다.
sudo apt-get --purge remove mysql-server mysql-server-5.5 mysql-server-core-5.5 mysql-client mysql-client-core-5.5 mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
rm -rf /var/lib/mysql
rm -rf /etc/mysql
이제 내 문제는 다음과 같습니다. MySQL Server 5.6을 설치하려고 하면 해당 프로세스가 진행되고 비밀번호를 묻는 경우 Cannot set MySQL "root" 비밀번호가 표시됩니다. "설치"한 후에는 MySQL이 시작되지 않고 권한이 거부됩니까?.
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 35 not upgraded.
brandon@brandon-DB:~$ sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5 mysql-common
mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
libmldbm-perl libnet-daemon-perl libplrpc-perl libsql-statement-perl tinyca mailx
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5 mysql-common
mysql-server mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 10 newly installed, 0 to remove and 35 not upgraded.
Need to get 0 B/8,955 kB of archives.
After this operation, 96.3 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 167760 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.5.37-0ubuntu0.14.04.1_all.deb ...
Unpacking mysql-common (5.5.37-0ubuntu0.14.04.1) ...
Selecting previously unselected package libmysqlclient18:amd64.
Preparing to unpack .../libmysqlclient18_5.5.37-0ubuntu0.14.04.1_amd64.deb ...
Unpacking libmysqlclient18:amd64 (5.5.37-0ubuntu0.14.04.1) ...
Selecting previously unselected package libdbi-perl.
Preparing to unpack .../libdbi-perl_1.630-1_amd64.deb ...
Unpacking libdbi-perl (1.630-1) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../libdbd-mysql-perl_4.025-1_amd64.deb ...
Unpacking libdbd-mysql-perl (4.025-1) ...
Selecting previously unselected package libterm-readkey-perl.
Preparing to unpack .../libterm-readkey-perl_2.31-1_amd64.deb ...
Unpacking libterm-readkey-perl (2.31-1) ...
Selecting previously unselected package mysql-client-core-5.5.
Preparing to unpack .../mysql-client-core-5.5_5.5.37-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-client-core-5.5 (5.5.37-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-client-5.5.
Preparing to unpack .../mysql-client-5.5_5.5.37-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-client-5.5 (5.5.37-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server-core-5.5.
Preparing to unpack .../mysql-server-core-5.5_5.5.37-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-server-core-5.5 (5.5.37-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1) ...
Setting up mysql-common (5.5.37-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 168116 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.5_5.5.37-0ubuntu0.14.04.1_amd64.deb ...
Unpacking mysql-server-5.5 (5.5.37-0ubuntu0.14.04.1) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.5.37-0ubuntu0.14.04.1_all.deb ...
Unpacking mysql-server (5.5.37-0ubuntu0.14.04.1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Processing triggers for man-db (2.6.7.1-1) ...
Setting up libmysqlclient18:amd64 (5.5.37-0ubuntu0.14.04.1) ...
Setting up libdbi-perl (1.630-1) ...
Setting up libdbd-mysql-perl (4.025-1) ...
Setting up libterm-readkey-perl (2.31-1) ...
Setting up mysql-client-core-5.5 (5.5.37-0ubuntu0.14.04.1) ...
Setting up mysql-client-5.5 (5.5.37-0ubuntu0.14.04.1) ...
Setting up mysql-server-core-5.5 (5.5.37-0ubuntu0.14.04.1) ...
Setting up mysql-server-5.5 (5.5.37-0ubuntu0.14.04.1) ...
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.5 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.5; however:
Package mysql-server-5.5 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Processing triggers for libc-bin (2.19-0ubuntu6) ...
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for ureadahead (0.100.0-16) ...
Errors were encountered while processing:
mysql-server-5.5
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
모든 데이터베이스/테이블을 덤프하고 별도의 HDD에 보관했습니다. 이것은 또한 내 주요 생산 기계가 아닌 개발 기계입니다. 또한 MySQL_Config 및 MySQL_Data도 백업했습니다.
편집: 내 컴퓨터에 MySQL Server 5.6을 설치할 수 있었습니다!
답변1
을 구성한 mysql-server-5.5다음 를 설치합니다 mysql-server.
sudo dpkg --configure mysql-server-5.5