header ad

Saturday, January 5, 2013

Appserv 2.6.0 phpmyadmin not working

If you’re running the newest version of AppServe (2.6.0)  as a local web server, take note:

When installing, do not install to “localhost”. Instead, you must use 127.0.0.1. If you have already installed it, browse to C:\AppServ\www\phpMyAdmin\config.inc.php and change the server host line from localhost to 127.0.0.1.
See the third post on this forum. I’ve pasted in the post below:
The problem is that you are trying to use named pipe connection. You should use the tcp connection, so
localhost -> 127.0.0.1
https://hu2.php.net/function.mysql-connect
Note: Whenever you specify “localhost” or “localhost:port” as server, the MySQL client library will override this and try to connect to a local socket (named pipe on Windows). If you want to use TCP/IP, use “127.0.0.1″ instead of “localhost”. If the MySQL client library tries to connect to the wrong local socket, you should set the correct path as Runtime Configuration in your PHP configuration and leave the server field blank.
Simply modify this line in the phpmyadmin/config.inc.php
$cfg['Servers'][$i]['host']          = ‘localhost’;
to this:
$cfg['Servers'][$i]['host']          = ’127.0.0.1′;
it worked for me;)
I had this problem recently and that fixed it. If you don’t fix it, you won’t be able to open phpmyadmin or connect to any databases.
I’m also getting this error, but I haven’t troubleshooted that one yet :)
Strict Standards: date() [function.date]: It is not safe to rely on the system’s timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected ‘America/New_York’ for ‘-5.0/no DST’ instead

Web Design Sri Lanka + Web Hosting Sri lanka  + Web Design portfolio


13 comments: