放本机比较好.
如果你在本机上装有APACHE+PHP, 就用phpmyadmin, 如果没有就用mysqlfront.
phpmyadmin其实就是一个PHP程序, 如果你会写PHP就应该懂得怎么让其运行.
抄以前写的一点文章, 修改一点
*****
*(4)*设置phpMyadmin
*****
首先修改:
$cfgPmaAbsoluteUri = '';
改成你的phpmyadmin所在的目录
$cfgPmaAbsoluteUri = 'http://localhost/myadmin/';
需要修改一下目录下的config.inc.php文件,把
$cfgDefaultLang = 'en';
改为
$cfgDefaultLang = 'zh';
这样就成中文版的了
还有这里:
$cfgServers[$i]['host'] = 'localhost'; // 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'] = ''; // MySQL control user settings
// (this user must have read-only
$cfgServers[$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)
$cfgServers[$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfgServers[$i]['user'] = 'root'; // MySQL user
$cfgServers[$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
$cfgServers[$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed
// at left frame
// It may also be an array
// of db-names
$cfgServers[$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfgServers[$i]['bookdb'] = ''; // Book db - leave blank for no book support
$cfgServers[$i]['booktable'] = ''; // Book table - leave blank for no book support
$cfgServers[$i]['relation'] = ''; // table to describe the relation between links (see doc)
// - leave blank for no relation-links support
这里是有关登录MYSQL服务器的设置. 注释写得很明白了. 填入你的MYSQL服务器, 用户名, 密码, 就可以在本机管理了.
如果你在本机上装有APACHE+PHP, 就用phpmyadmin, 如果没有就用mysqlfront.
phpmyadmin其实就是一个PHP程序, 如果你会写PHP就应该懂得怎么让其运行.
抄以前写的一点文章, 修改一点
*****
*(4)*设置phpMyadmin
*****
首先修改:
$cfgPmaAbsoluteUri = '';
改成你的phpmyadmin所在的目录
$cfgPmaAbsoluteUri = 'http://localhost/myadmin/';
需要修改一下目录下的config.inc.php文件,把
$cfgDefaultLang = 'en';
改为
$cfgDefaultLang = 'zh';
这样就成中文版的了
还有这里:
$cfgServers[$i]['host'] = 'localhost'; // 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'] = ''; // MySQL control user settings
// (this user must have read-only
$cfgServers[$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)
$cfgServers[$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfgServers[$i]['user'] = 'root'; // MySQL user
$cfgServers[$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
$cfgServers[$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed
// at left frame
// It may also be an array
// of db-names
$cfgServers[$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfgServers[$i]['bookdb'] = ''; // Book db - leave blank for no book support
$cfgServers[$i]['booktable'] = ''; // Book table - leave blank for no book support
$cfgServers[$i]['relation'] = ''; // table to describe the relation between links (see doc)
// - leave blank for no relation-links support
这里是有关登录MYSQL服务器的设置. 注释写得很明白了. 填入你的MYSQL服务器, 用户名, 密码, 就可以在本机管理了.
把phpMyAdmin目录拷贝到服务器上,配置好用户名,密码和主机名,将$cfgServers[$i]['auth_type']的值改为cookie,这样每次访问时就必须输入用户名和密码(同连接数据库的用户名和密码)。