问题描述
我使用的服务器是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.
这篇关于Codeigniter 连接到使用 centOS 和 mariadb 作为数据库管理的 SSH 服务器的可能设置是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！