产品服务AMH 免费服务器主机面板SSL证书 免费SSL证书申请编程助手免费智能写代码、翻译NewAMYSQL 免费MySQL管理工具AMFTP 免费FTP管理客户端

AMH 社区首页

 AMH社区 - 开放自由有价值的社区

[综合话题] AMH备份的密码MYSQL ROOT密码完全正确,测试好几次就是备份提示密码错误

ruizi
铁牌会员
107.10 价值分

ruizi 发表于 2021-07-11 11:43:06
[Linux] AMH 6.0
http://amh.sh

[amdata-2.7 backup]
=============================================================
[OK] amdata-2.7 is already installed.
[OK] amdata-2.7 is already installed.
[mysql-8.0] *******************
mysql: [Warning] Using a password on the command line interface can be insecure.
[Notice] amh Database backup ...
mysql: [Warning] Using a password on the command line interface can be insecure.
amh.amh_process repair status OK
amh.amh_module repair status OK
amh.amh_data repair status OK
mysqldump: [Warning] Using a password on the command line interface can be insec ure.
[Notice] information_schema Database backup ...
mysqldump: [Warning] Using a password on the command line interface can be insec ure.
mysqldump: Dumping 'information_schema' DB content is not supported
[Notice] mysql Database backup ...
mysqldump: [Warning] Using a password on the command line interface can be insec ure.
[Notice] performance_schema Database backup ...
mysqldump: [Warning] Using a password on the command line interface can be insec ure.
[Notice] rzkj-jy Database backup ...
mysqldump: [Warning] Using a password on the command line interface can be insec ure.
[Notice] sys Database backup ...
mysqldump: [Warning] Using a password on the command line interface can be insec ure.
[Notice] zyhyibai365 Database backup ...
mysqldump: [Warning] Using a password on the command line interface can be insec ure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: mysql: [Warning] Using a password on the command line interface can be in secure.[Warning] Using a password on the command line interface can be insecure.

mysql: [Warning] Using a password on the command line interface can be insecure.
[mysql-5.1.73] *******************
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1043 (08S01): Bad handshake
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1043 (08S01): Bad handshake
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1043 (08S01): Bad handshake
ERROR 1043 (08S01): Bad handshake
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1043 (08S01): Bad handshake
[mysql-5.6] *******************
mysql: [Warning] Using a password on the command line interface can be insecure.
[Notice] information_schema Database backup ...
Warning: Using a password on the command line interface can be insecure.
[Notice] mysql Database backup ...
Warning: Using a password on the command line interface can be insecure.
[Notice] performance_schema Database backup ...
Warning: Using a password on the command line interface can be insecure.
[Notice] rzkj-jy Database backup ...
Warning: Using a password on the command line interface can be insecure.
[Notice] zyhyibai365 Database backup ...
Warning: Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
1) info
2) hostname
3) ntp
4) delete
5) exit
评价: 这个话题有价值吗?  没有 (0分)   有, 感谢 (0分)
2021-07-11 11:43:06 1

ruizi
铁牌会员
107.10 价值分

我的系统是DEBIAN
评价: 这个回复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2021-07-11 11:55:19 2

ruizi
铁牌会员
107.10 价值分

Debian 9 (64位)
评价: 这个回复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2021-07-11 11:55:43 3

amysql
创始人
99530.04 价值分

上面报错是mysql-5.1.73无法连接,面板上看mysql-5.1.73是否能正常运行,
另外的,mysql-8.0与mysql-5.6是备份正常的。

另外,
命令端出现,1) info .. 提示时,你可以输入1。
(amdata新版本会优化,这是有些软件升级版本后出现的提示,面板上操作没这个问题)
评价: 这个回复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2021-07-11 12:01:18 4

AMH面板 - 好用高效低占用、安全可靠极稳定

ruizi
铁牌会员
107.10 价值分

希望后期有更新版本,近期估计很难备份到数据库
评价: 这个回复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2021-07-11 15:15:07 5

amysql
创始人
99530.04 价值分

引用:
ruizi 发表于 2021-07-11 15:15:07
希望后期有更新版本,近期估计很难备份到数据库

会更新的,目前这个也不会影响到你数据库备份。
评价: 这个回复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2021-07-11 17:34:26 6

ruizi
铁牌会员
107.10 价值分

引用:
amysql 发表于 2021-07-11 17:34:26
会更新的,目前这个也不会影响到你数据库备份。

很谢谢你
评价: 这个回复有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2021-07-12 12:43:58 7
 1  (总1页)
AMH社区列表
用户服务中心