Codeigniter 连接到使用 centOS 和 mariadb 作为数据库管理的 SSH 服务器的可能设置是什么?

2022-01-15 00:00:00 mariadb php mysql mysqli codeigniter

我使用的服务器是ssh连接，由centOS运行，它使用LAMP作为平台.

The server I'm using is an ssh connection, which is ran by centOS, it uses LAMP as platform.

因为是centOS，mariadb是它唯一可用的数据库管理.我无法通过 sudo yum install mysql-server 命令安装 mysql.

Because it is centOS, mariadb is the only available database management for it. I cannot install mysql via sudo yum install mysql-server command.

我在本地使用 codeigniter 创建了一个项目.

I've created a project using codeigniter in my local.

我无法连接到数据库.错误给出如下:

I'm having trouble connecting to the database. The error gives like:

A PHP Error was encountered

Severity: Warning

Message: mysqli::real_connect(): (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Filename: mysqli/mysqli_driver.php

我的 codeigniter 中的 db 设置是:

The db setting in my codeigniter is:

$active_group = 'default';
$query_builder = TRUE;

$db['default'] = array(
    'dsn'   => '',
    'hostname' => '*server-ip-address*',
    'port' => '*server-port-number*',
    'username' => 'root',
    'password' => 'root@999',
    'database' => 'listingapp_db',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

我只是想也许我的数据库设置有误.

I just thought that maybe my database setting is wrong.

这与 dbdriver 设置有关吗?我尝试将 mysqli 更改为 mariadb，仍然没有进展.

Has it something to matter with the dbdriver setting? I tried changing mysqli to mariadb, still no progress.

什么可能是可以与服务器的centOS mariadb 共同使用的有效设置?

What could possibly be the valid setting that could co-inside with the server's centOS, mariadb?

我尝试 sudo iptables -vnL 检查防火墙，结果如下:

I tried sudo iptables -vnL to check firewall and this is the result:

Chain INPUT (policy DROP 10924 packets, 630K bytes)
 pkts bytes target     prot opt in     out     source               destination
40905 5353K ACCEPT     tcp  --  *      *       0.0.0.0/0            0.0.0.0/0            tcp dpt:80
1860K 2702M ACCEPT     all  --  *      *       0.0.0.0/0            0.0.0.0/0            state RELATED,ESTABLISHED
    0     0 DROP       tcp  --  *      *       0.0.0.0/0            0.0.0.0/0            tcp flags:0x3F/0x00
    4   172 DROP       tcp  --  *      *       0.0.0.0/0            0.0.0.0/0            tcp flags:!0x17/0x02 state NEW
    0     0 DROP       tcp  --  *      *       0.0.0.0/0            0.0.0.0/0            tcp flags:0x3F/0x3F
  158  9480 ACCEPT     all  --  lo     *       0.0.0.0/0            0.0.0.0/0
  445 28059 ACCEPT     icmp --  *      *       0.0.0.0/0            0.0.0.0/0
   57  2800 ACCEPT     tcp  --  *      *       0.0.0.0/0            0.0.0.0/0            tcp dpt:2202

Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination

Chain OUTPUT (policy ACCEPT 1133K packets, 103M bytes)
 pkts bytes target     prot opt in     out     source               destination

推荐答案

我现在已经解决了我的问题.打开我使用的端口，然后在mysql中授予root用户权限.

I have now fixed my issue. It's a matter of opening the port I used then granting privilege to the root user in mysql.

相关文章