php - Codeigniter SSH 连接到远程 MySQL 数据库

Question

我正在尝试使用 Codeigniter 远程连接到我们的实时数据库。但是我收到错误:

Message: mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'10.54.9.20' (using password: YES)

Database.php 配置文件:

$db['default'] = array(
'dsn'   => '',
'hostname' => 'xx.xx.xxx.xxx',
'username' => 'username',
'password' => 'password',
'database' => 'database',
'dbdriver' => 'mysqli',
'dbprefix' => '',
'pconnect' => TRUE,
'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE, //tried changing this to TRUE
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);

我在本地主机中使用数据库没有问题，但是在使用远程配置时出现错误。

需要帮助。谢谢大家!

Answer 1

从本地主机登录并运行以下命令:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'YOUR_PASSWORD' WITH GRANT OPTION;

FLUSH PRIVILEGES;

现在尝试远程访问。