use phpmyadmin to manage a remote mysql on bitnami redmine

 

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!