Jump to content

Recommended Posts

as my title say's PHPMYADMIN remote access to other PC does not work..

 

I tried to connect to my database on another pc by using ON internet Explorer:

 

//[serveripaddress]/phpmyadmin

//[serverhostname]/phpmyadmin

 

the interface of phpmyadmin is being reflected..However when i tried to select the database at the left frame of the phpmyamin.

the lower left frame reflects *default:Page Not Found of IE.. As I know the lower left frame should show the tables of the database i had selected.

 

One thing I had notice when the *default:Page Not Found of IE loads..It redirects to the IP 127.0.0.1 which is the default IP address of LOCALHOST.. I believe this causes the error, Where should I modify the redirection? So when i can remotely access my mysql database..

 

I also used the mysql-gui-tools-5.0-r4 for the remote access but it was also unsuccessful.

 

PLEASE HELP ME>

 

 

Did you do the setup ???

 

 

 

2.6 I get an "Access denied for user: 'root@localhost' (Using password: YES)"-error when trying to access a MySQL-Server on a host which is port-forwarded for my localhost.

 

When you are using a port on your localhost, which you redirect via port-forwarding to another host, MySQL is not resolving the localhost as expected.

Erik Wasser explains: The solution is: if your host is "localhost" MySQL (the commandline tool 'mysql' as well) always tries to use the socket connection for speeding up things. And that doesn't work in this configuration with port forwarding.

If you enter "127.0.0.1" as hostname, everything is right and MySQL uses the TCP connection.

 

 

config.inc.php

 

$cfg['Servers'][$i]['port'] string

    The port-number of your $i-th MySQL-server. Default is 3306 (leave blank). If you use "localhost" as the hostname, MySQL ignores this port number and connects with the socket, so if you want to connect to a port different from the default port, use "127.0.0.1" or the real hostname in $cfg['Servers'][$i]['host'

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.