[報到]想要装PHPBB，但是。。。。斑竹救命啊

[sinid]

前不久申请了带数据库的虚拟空间，但是数据库和空间不是一起的。怎样在远程创建数据库中的表？我想创建两个怎么办？创建好后，怎样调用？

[silverwing]

你要把config設定好，還要能夠create 資料庫。

[NINJA]

如果你是同一個站申請的空間跟mysql(例如host.sk)
那麼該站的首頁應該有鏈接mysql的相關說明
如果空間跟mysql不同一個主機商提供的(例如空間是yahoo的,mysql是sina的)
那麼要確定mysql是不是能夠讓別家主機鏈接

[sinid]

谢谢silverwing和NINJA

空间和数据库是在一家空间提供商申请的，但是空间IP地址和数据库IP地址却不一样。他告诉我要用ODBC创建我所需要的表。应该怎样去做？

有人说可以用PHPMYADMIN来创建表，具体怎样设置？

能说详细一点吗？

[NINJA]

ODBC??這好像是windows的吧..沒有Mysql的嗎?
IP地址不一樣沒關係,只要填入那個ip就可以了.但ODBC我就不瞭解了...

[sinid]

有人说可以用PHPMYADMIN来创建表，具体怎样设置？ 可以详细一点吗？谢谢！

[silverwing]

PHPMYADMIN操作。

http://www.fanqiang.com/a2/b1/

[sinid]

基本上知道了，但是我的数据库是远程的啊。具体应该怎样设置？再次感谢！

我是这样设置的

$i++;
$cfgServers[$i]['host'] = '11.111.11.111';// 我的数据库IP地址
$cfgServers[$i]['port'] = '';
$cfgServers[$i]['socket'] = '';
$cfgServers[$i]['connect_type'] = 'tcp';
$cfgServers[$i]['controluser'] = '';
$cfgServers[$i]['controlpass'] = '';
$cfgServers[$i]['auth_type'] = 'config';
$cfgServers[$i]['user'] = 'sinid';
$cfgServers[$i]['password'] = '1213456';
$cfgServers[$i]['only_db'] = '';
$cfgServers[$i]['verbose'] = '';
$cfgServers[$i]['bookmarkdb'] = '';
$cfgServers[$i]['bookmarktable'] = '';
$cfgServers[$i]['relation'] = '';

但是出现下列提示：


Welcome to phpMyAdmin 2.2.6


Warning: Cannot add header information - headers already sent by (output started at D:\hosts\jn114\phpmyadmin\libraries\auth\config.auth.lib.php:91) in D:\hosts\jn114\phpmyadmin\header.inc.php on line 23
\n
Warning: Cannot add header information - headers already sent by (output started at D:\hosts\jn114\phpmyadmin\libraries\auth\config.auth.lib.php:91) in D:\hosts\jn114\phpmyadmin\header.inc.php on line 24

Warning: Cannot add header information - headers already sent by (output started at D:\hosts\jn114\phpmyadmin\libraries\auth\config.auth.lib.php:91) in D:\hosts\jn114\phpmyadmin\header.inc.php on line 25

Warning: Cannot add header information - headers already sent by (output started at D:\hosts\jn114\phpmyadmin\libraries\auth\config.auth.lib.php:91) in D:\hosts\jn114\phpmyadmin\header.inc.php on line 26

Warning: Cannot add header information - headers already sent by (output started at D:\hosts\jn114\phpmyadmin\libraries\auth\config.auth.lib.php:91) in D:\hosts\jn114\phpmyadmin\header.inc.php on line 27

Warning: Cannot add header information - headers already sent by (output started at D:\hosts\jn114\phpmyadmin\libraries\auth\config.auth.lib.php:91) in D:\hosts\jn114\phpmyadmin\header.inc.php on line 29

Error

MySQL said:


Unknown MySQL Server Host 'http' (0)

[小竹子]

有顏色的部分是要填寫的

代碼: 選擇全部

// The $cfgServers array starts with $cfgServers[1].  Do not use $cfgServers[0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfgServers[$i]['host']          = [color=brown]'xxx.xxx.xxx'[/color]; // MySQL hostname
$cfgServers[$i]['port']          = '';          // MySQL port - leave blank for default port
$cfgServers[$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfgServers[$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfgServers[$i]['controluser']   = '[color=red]account[/color]';          // MySQL control user settings
                                                // (this user must have read-only
$cfgServers[$i]['controlpass']   = '[color=brown]password[/color]';          // access to the "mysql/user"
                                                // and "mysql/db" tables)
$cfgServers[$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?
$cfgServers[$i]['user']          = '[color=red]mysqluser[/color]';      // MySQL user
$cfgServers[$i]['password']      = '[color=brown]mysqluserpass'[/color];          // MySQL password (only needed
                                                // with 'config' auth_type)
$cfgServers[$i]['only_db']       = '[color=red]dbname[/color]';          // If set to a db-name, only