php无法远程连接数据库,请大神指导
$active_group = 'default';$active_record = TRUE;
/application/configure/database.php:
$db['default']['hostname'] = '172.16.69.128:3306';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'codeigniter';
$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;
显示的错误:
A Database Error OccurredUnable to connect to your database server using the provided settings.Filename: core/Loader.phpLine Number: 346
ps:
$db['default']['hostname'] = '172.16.69.128:3306';是我虚拟机里面的ip地址,但是我外面用mysql-workbench可以连接虚拟机里面的数据库,应该不是权限问题,我有个%的host
mysql> select host,user,password from user;
+-----------------------+------+----------+
| host | user | password |
+-----------------------+------+----------+
| localhost | root | |
| localhost.localdomain | root | |
| 127.0.0.1 | root | |
| ::1 | root | |
| % | root | |
+-----------------------+------+----------+
5 rows in set (0.01 sec)
如果我将项目拷贝到虚拟机里面,不报错,但是没有任何数据出来。就是空白的,求大神帮忙
页:
[1]