PHP Codeigniter：为 MySQL 配置设置端口号
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/26716179/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PHP Codeigniter : set Port Number for MySQL Configuration
提问by AHméd Net
Can you explain to me how to set port number for a Database configuration :
你能向我解释如何为数据库配置设置端口号：
class MY_Model extends CI_Model
{
protected static $db2_loaded = false;
protected static $db2 = false;
function __construct()
{
parent::__construct();
if(($this->session->userdata('login_user')!=false) && !self::$db2_loaded)
{
self::$db2_loaded = true;
$config['hostname'] = "localhost";
$config['username'] = "root";
$config['password'] = "";
$config['database'] = $this->session->userdata('bdd_compte');
$config['dbdriver'] = "mysql";
$config['dbprefix'] = "";
$config['pconnect'] = TRUE;
$config['db_debug'] = TRUE;
$config['cache_on'] = FALSE;
$config['cachedir'] = "";
$config['char_set'] = "utf8";
$config['dbcollat'] = "utf8_general_ci";
self::$db2 = $this->load->database($config,TRUE);
}
$this->db = self::$db2;
}
}
Any ideas how should I set a different port number
任何想法我应该如何设置不同的端口号
Thanks!
谢谢！
回答by Pupil
Use the portkey in database.php.
使用中的port密钥database.php。
$db['default']['port'] = 5432;
OR
或者
$db['default']['hostname'] = "mysqlhost.yourdomain.com:3310";
回答by Angel Leon
this work
这项工作
$db['default'] = array( 'hostname' => '99.99.99.99:3337',
$db['default'] = array( 'hostname' => '99.99.99.99:3337',
