急!如何使用phpmyadmin管理远程主机中的mysql

由 careful314 在 06-02-2003 17:54 发表:

急!如何使用phpmyadmin管理远程主机中的mysql

请问,如何使用phpmyadmin管理远程主机中的mysql

phpmyadmin中应如何设置操作


由 maowei 在 06-02-2003 23:31 发表:


请您首先下载PhpMyAdmin软件,将此文件包解压,找到其中的一个文件:config.inc.php(或者如config.*等,该文件名会因PhpMyAdmin版本不同而有所差别)

修改以下配置:

$cfgServers[1]['host'] = 'localhost'; // MySQL hostname

$cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port

$cfgServers[1]['socket'] = ''; // Path to the socket - leave blank for default socket

$cfgServers[1]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')

$cfgServers[1]['stduser'] = ''; // MySQL standard user settings (this user must have read-only

$cfgServers[1]['stdpass'] = ''; // access to the "mysql/user" and "mysql/db" tables)

$cfgServers[1]['adv_auth'] = FALSE; // Use advanced authentication?

$cfgServers[1]['user'] = '******'; // MySQL user

$cfgServers[1]['password'] = '******'; // MySQL password (only needed with basic auth)

$cfgServers[1]['only_db'] = '******'; // If set to a db-name, only this db is displayed at left frame

Published At
Categories with 服务器类
Tagged with
comments powered by Disqus