use phpmyadmin to manage a remote mysql on bitnami redmine

原创于 2011-03-03 15:33:00 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#phpmyadmin #mysql #passwords #extension #vmware #user

本文介绍如何通过修改配置文件让phpMyAdmin能够连接到远程MySQL服务器，并详细说明了设置SSH隧道、调整MySQL密码存储方式及使用特定端口映射的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. modify config.inc.php, add the following to let phpmyadmin be aware of the remote mysql
$i++;
$cfg['Servers'][$i]['verbose'] = 'bitnami';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '4306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'http';

2. start sshd on bitnami vmware box.

3. use securecrt to map from port 3306 on bitnami to port 4306 on localhost

4. on bitmani, run the following code in mysql console to adjust password store method

SET old_passwords = 0;
UPDATE mysql.user SET Password = PASSWORD('testpass') WHERE User = 'testuser' limit 1;
SELECT LENGTH(Password) FROM mysql.user WHERE User = 'testuser';
FLUSH PRIVILEGES;

5. visite http://localhost/phpmyadmin , enjoy!