Posted by:
Tosh
(---.zone5.bethere.co.uk)
I had a working WAMP installation which I used to make a small website a while back, but when I tried to use it again recently it didn't work. In that period I had a separate PHP installation, but apparently that's a big no-no so I've uninstalled and deleted it completely (including the php.ini file). I also wiped and reinstalled WAMP a few times, and tried using the password reset tool.
My wamp is not installed in a directory with spaces (it's just C:\wamp), and my phpMyAdmin "config.inc.php" file is set up to accept "root" with no password, as follows:
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
The full error is:
"Cannot connect: invalid settings.
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."
The wampserver home page says that mysql and msqli are both loaded. If I try to load a page that uses MySQL from my own website, I get this error:
"Fatal error: Call to undefined function mysql_connect()"
I tried reading through similar threads and trying all of the suggestions, hence all of the information that I have listed here, but nothing seems to be working. I would greatly appreciate any help you can give.
Thanks