neo777ph Posted March 1, 2007 Share Posted March 1, 2007 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> Quote Link to comment https://forums.phpfreaks.com/topic/40649-phpmyadmin-remote-access-to-other-pc-does-not-work/ Share on other sites More sharing options...
MadTechie Posted March 1, 2007 Share Posted March 1, 2007 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' Quote Link to comment https://forums.phpfreaks.com/topic/40649-phpmyadmin-remote-access-to-other-pc-does-not-work/#findComment-196654 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.