mysql 升级maria_mysql5.7升级到mariadb-server-10.0

5.7############################..............................................................................................]

Thefile /var/lib/mysql/debian-5.7.flag indicated a

version that cannot automatically be upgraded. Therefore the

previous data directory will be renamed to/var/lib/mysql-5.7and

a new data directory will be initialized at/var/lib/mysql.

Please manually export/import your data (e.g. with mysqldump) ifneeded.

invoke-rc.d: could not determine current runlevel

Unpacking mariadb-server-10.0 (10.0.38-0ubuntu0.16.04.1) ...

Selecting previously unselected package mariadb-server.##############################.......................................................................................................]

Preparing to unpack .../mariadb-server_10.0.38-0ubuntu0.16.04.1_all.deb ...

Unpacking mariadb-server (10.0.38-0ubuntu0.16.04.1) ...#################################....................................................................................................]

Processing triggersfor man-db (2.7.5-1) ...#################################################...............................................................................................]

Processing triggersfor systemd (229-4ubuntu21.2) ...

Processing triggersfor ureadahead (0.100.0-19) ...

Setting up libdbd-mysql-perl (4.033-1ubuntu0.1) ...################################################.........................................................................................]

Setting up mariadb-client-core-10.0 (10.0.38-0ubuntu0.16.04.1) ...#######################################...................................................................................]

Setting up mariadb-client-10.0 (10.0.38-0ubuntu0.16.04.1) ...##################################################.............................................................................]

Setting up mariadb-server-core-10.0 (10.0.38-0ubuntu0.16.04.1) ...##################################################........................................................................]

Setting up mariadb-server-10.0 (10.0.38-0ubuntu0.16.04.1) ...#############################################################..................................................................]

Installing new version of configfile /etc/apparmor.d/usr.sbin.mysqld ...

Installing new version of configfile /etc/init.d/mysql ...

Installing new version of configfile /etc/logrotate.d/mysql-server ...

Installing new version of configfile /etc/mysql/debian-start ...

invoke-rc.d: could not determine current runlevel############################################################################...............................................................]*Stopping MariaDB database server mysqld [ OK ]

Setting up mariadb-server (10.0.38-0ubuntu0.16.04.1) ...########################################################################............................................................]

Processing triggersfor systemd (229-4ubuntu21.2) ...#################################################################################......................................................]

Processing triggersfor ureadahead (0.100.0-19) ...of script `mysql'overrides LSB defaults (0 1 6).

root@PC-RENGUOQIANG:/etc/init.d#

mysqladmin-uroot -p root

mysql-uroot -proot

SET passwordfor 'root'@'localhost'=password('root');

MariaDB [mysql]> selectuser, plugin from mysql.user;+------+-------------+

| user | plugin |

+------+-------------+

| root | unix_socket |

+------+-------------+

1 row in set (0.00sec)

update mysql.user set authentication_string=PASSWORD('root'), plugin='mysql_native_password' where user='root';

flush privileges;