CodeIgniter 无法连接到数据库

发布于 2025-01-05 16:41:38 字数 1402 浏览 1 评论 0 原文

我有一个项目在我的本地服务器（xampp）上完美运行：

PHP 5.3.8
MYSQL 5.5.16
APACHE 2.2.21

现在，我尝试使其在 Web 服务器上运行，但 CodeIgniter 无法连接到数据库。我尝试连接此代码并且工作正常：

$link =  mysql_connect('localhost', 'user', 'pass');
if (!$link) {
    die('No pudo conectarse: ' . mysql_error());
}
echo 'Conectado  satisfactoriamente';

但 CI 说：

无法使用提供的设置连接到您的数据库服务器。

CI 数据库配置文件的设置如下：

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'user';
$db['default']['password'] = 'pass';
$db['default']['database'] = 'database';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

在这里，您可以看到基本的 MySQL 连接和 phpinfo()

http://guatrache.gov.ar/test.php

在这里，您可以看到来自 CI 的错误消息：

http://guatrache.gov.ar/index.php

感谢您的宝贵时间。

PD：网络服务器有：PHP 5.3.9，MYSQL 5.1.60

原文

I have a project working perfectly on my local server (xampp) with:

PHP 5.3.8
MYSQL 5.5.16
APACHE 2.2.21

Now, i try to make it work on the web server and CodeIgniter couldn't connect to database.
I try to connect with this code and works ok:

$link =  mysql_connect('localhost', 'user', 'pass');
if (!$link) {
    die('No pudo conectarse: ' . mysql_error());
}
echo 'Conectado  satisfactoriamente';

but CI says:

Unable to connect to your database server using the provided settings.

The settings on CI database config file are:

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'user';
$db['default']['password'] = 'pass';
$db['default']['database'] = 'database';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

here, you can see working the basic MySQL connection and the phpinfo()

http://guatrache.gov.ar/test.php

and here, you can see the error message from CI:

http://guatrache.gov.ar/index.php

Thanks for your time.

PD: The web server has: PHP 5.3.9, MYSQL 5.1.60

分享到QQ

分享到微博