通过phpMyAdmin连接到隧道数据库 [英] Connect to tunneled DB through phpMyAdmin

问题描述

因此，我已将数据库通过隧道传输到127.0.0.1上的3307端口..我可以连接到数据库，并可以使用Ubuntu的MySQL Workbench进行任何操作，但是我真的不喜欢GUI的界面，因此我想使用ol'friend phpMyAdmin.

So I've tunneled the DB to port 3307 on 127.0.0.1 .. I can connect to the database and do whatever I want by using Ubuntu's MySQL Workbench, however I really dislike the interface of the GUI so I want to use the ol'friend phpMyAdmin.

我正在使用的连接参数是:

The connection parameters I am using are:

$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['port'] = 3307;
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type']= 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'myDBuser';
$cfg['Servers'][$i]['password'] = 'myDBpass';

当我转到http://localhost/phpmyadmin时，从下拉列表中选择我的服务器，然后单击执行"，将显示以下错误:

When I go to http://localhost/phpmyadmin, select my server from the dropdown and click Go, the following errors are displayed:

#1045 - Access denied for user 'myDBuser'@'localhost' (using password: YES) 

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

我的登录详细信息是正确的.

My login details are correct.

任何帮助将不胜感激！

推荐答案

我设法通过删除密码并使用无密码登录来使其正常工作.我不知道为什么它可以在不提供密码的情况下登录，但是现在可以正常工作了.谢谢大家的帮助！

I managed to get it working by removing the password and logging in with no password. I don't know why it can log in without proving a password, but its working now. Thank you all for your help!

这篇关于通过phpMyAdmin连接到隧道数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！