mysql5.7升级到mariadb-server-10.0
5.7############################..............................................................................................] The file /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.7 and a new data directory will be initialized at /var/lib/mysql. Please manually export/import your data (e.g. with mysqldump) if needed. 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 triggers for man-db (2.7.5-1) ...#################################################...............................................................................................] Processing triggers for systemd (229-4ubuntu21.2) ... Processing triggers for 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 config file /etc/apparmor.d/usr.sbin.mysqld ... Installing new version of config file /etc/init.d/mysql ... Installing new version of config file /etc/logrotate.d/mysql-server ... Installing new version of config file /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 triggers for systemd (229-4ubuntu21.2) ...#################################################################################......................................................] Processing triggers for 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 password for 'root'@'localhost'=password('root'); MariaDB [mysql]> select user, plugin from mysql.user; +------+-------------+ | user | plugin | +------+-------------+ | root | unix_socket | +------+-------------+ 1 row in set (0.00 sec) update mysql.user set authentication_string=PASSWORD('root'), plugin='mysql_native_password' where user='root'; flush privileges;
Mariadb修改root密码 - KeithTt - 博客园
https://www.cnblogs.com/keithtt/p/6922378.html
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
解决方案：
mysql - ERROR 1698 (28000): Access denied for user 'root'@'localhost' - Stack Overflow
https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost
MySQL ERROR 1698 (28000) 错误 - leolztang - 博客园
https://www.cnblogs.com/leolztang/p/5094930.html
