opencart与mysql数据库的连接

Question

Warning: mysqli::__construct(): (HY000/3118): Access denied for user 'mysql.infoschema'@'localhost'. Account is locked. in C:\Server\data\htdocs\opencart\system\library\db\mysqli.php on line 7

Fatal error: Uncaught Error: mysqli object is already closed in C:\Server\data\htdocs\opencart\system\library\db\mysqli.php:10 Stack trace: #0 

C:\Server\data\htdocs\opencart\install\controller\install\step_3.php(274): DB\MySQLi->__construct('localhost', 'mysql.infoschem...', 'Salah509', 'opencart', '3306') #1

C:\Server\data\htdocs\opencart\install\controller\install\step_3.php(8): ControllerInstallStep3->validate() #2

C:\Server\data\htdocs\opencart\system\engine\action.php(79): ControllerInstallStep3->index() #3 C:\Server\data\htdocs\opencart\system\engine\router.php(67): Action->execute(Object(Registry)) #4 C:\Server\data\htdocs\opencart\system\engine\router.php(56): Router->execute(Object(Action)) #5

C:\Server\data\htdocs\opencart\system\framework.php(165): Router->dispatch(Object(Action), Object(Action)) #6 

C:\Server\data\htdocs\opencart\system\startup.php(104): require_once('C:\\Server\\data\\...') #7 C:\Server\data\htdocs\opencart\install\index.php(37): start('install') #8 {main} thrown in C:\Server\data\htdocs\opencart\system\library\db\mysqli.php on line 10

我刚刚安装了Apache 2.4.46, PHP 8.0.1, mysql 8.0.22和phpmyadmin 5.0.4，当我开始安装opencat 3.0.6并连接数据库时，我收到了这个长错误，请告诉我如何修复它，谢谢

Answer 1

更改以下文件中的代码行：

install/cli_install.php搜索

$db->query("SET @@session.sql_mode = 'MYSQL40'")；替换为$db->query("SET @@session.sql_mode = ''")；

安装/model/install/install.php

搜索

$db->query("SET @@session.sql_mode = 'MYSQL40'")；替换为$db->query("SET @@session.sql_mode = ''")；-

阿拉伯语:在这里

https://forum.opencart.com/viewtopic.php?t=218433