VPS侦探论坛

 找回密码
 注册
查看: 146|回复: 3

Cetons8 安装lnmp1.7后升级mysql失败

[复制链接]
发表于 2020-6-6 14:52:59 | 显示全部楼层 |阅读模式



lnmp安装可以正常使用 但是升级到mysql 8的时候 提示升级成功 但是进入phpmyadmin的时候 提示错误
SQL 查询: 编辑
SELECT `CHARACTER_SET_NAME` AS `Charset`, `DESCRIPTION` AS `Description` FROM `information_schema`.`CHARACTER_SETS`
MySQL 返回:
#1449 - The user specified as a definer ('mysql.infoschema'@'localhost') does not exist


安装日志在这里 http://tmp.link/f/5edb36e80b555
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2020-6-7 08:46:00 | 显示全部楼层


mysql -uroot -p 输入密码登陆后执行
SET GLOBAL innodb_fast_shutdown = 1;
quit;

/usr/local/mysql/bin/mysql_upgrade -u root -p
在看一下
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2020-6-8 10:33:27 | 显示全部楼层



我试了一下 还是不行 提示这个
  1. mysql: [Warning] Using a password on the command line interface can be insecure.
  2. Welcome to the MySQL monitor.  Commands end with ; or \g.
  3. Your MySQL connection id is 61
  4. Server version: 8.0.20 Source distribution
  5. Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
  6. Oracle is a registered trademark of Oracle Corporation and/or its
  7. affiliates. Other names may be trademarks of their respective
  8. owners.
  9. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  10. mysql> SET GLOBAL innodb_fast_shutdown = 1;
  11. Query OK, 0 rows affected (0.00 sec)
  12. mysql> quit;
  13. Bye
  14. [root@centosmysql /]# /usr/local/mysql/bin/mysql_upgrade -u root -p
  15. Enter password:
  16. The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.
  17. To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade.
  18. The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the
  19. MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand.
  20. It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server
  21. upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manual
  22. ly rectify the problem.
复制代码
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2020-6-8 16:35:54 | 显示全部楼层



升级phpmyadmin到最新版试试,不行就不清楚什么问题了
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2020-7-2 13:52 , Processed in 0.061214 second(s), 26 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表