Can not connect to mysql
Posted by: patan (202.150.111.---)
Date: January 15, 2007 06:53AM

Hi there,
I just downloaded and installed wamp. In the try is seems like all the services are working fine. I have the two php extension for mysql enable but I get the following error when trying to launch phpmyadmin:

Cannot load mysql extension. Please check your PHP configuration. - Documentation

this is the log from mysql:

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
070115 17:55:20 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070115 17:55:20 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070115 17:55:21 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070115 17:55:21 InnoDB: Started; log sequence number 0 0
070115 17:55:22 [Note] C:\Program Files\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070115 18:14:09 [Note] C:\Program Files\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown

070115 18:14:09 InnoDB: Starting shutdown...
070115 18:14:11 InnoDB: Shutdown completed; log sequence number 0 43655
070115 18:14:11 [Note] C:\Program Files\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

070115 18:14:12 InnoDB: Started; log sequence number 0 43655
070115 18:14:12 [Note] C:\Program Files\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
070115 18:33:21 [Note] C:\Program Files\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown

070115 18:33:21 InnoDB: Starting shutdown...
070115 18:33:24 InnoDB: Shutdown completed; log sequence number 0 43655
070115 18:33:24 [Note] C:\Program Files\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

070115 18:33:25 InnoDB: Started; log sequence number 0 43655
070115 18:33:25 [Note] C:\Program Files\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)

Any clue?
Do I have to set anything by hand?

Just in case: I'm running a xp over an AMD 64bits.

Some help would be really appreciated.
Cheers,
Patan

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: yfastud (72.236.169.---)
Date: January 15, 2007 01:27PM

Did you enable them through tray icon?

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: patan (---.righthemisphere.com)
Date: January 15, 2007 09:47PM

hi there,
they were enable by default.

any clue?
thanks in advance.
patan

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: sjtout (---.tukw.qwest.net)
Date: January 15, 2007 11:18PM

I have this same problem--on a laptop with WinXP Home Edition.

I can reach pages with [localhost]

but can't start the PHPMyAdmin or SQLLiteManager pages --I get the same error and have the same log entry as listed above.

Also, I don't seem to be able to run PHP code in pages. I have a page with 'Hello World' PHP code, and the 'Hello World' is not appearing.

(FYI, here's the code:

<html>
<head>
<title>My First PHP Page</title>
</head>
<body>
<?php
echo "Hello World!";
?>
</body>
</html>


Thank you!

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: sjtout (---.tukw.qwest.net)
Date: January 15, 2007 11:57PM

I just got this working.

I think the problem was that I had tried to install PHP before setting up WAMP.

I went to the control panel --> System --> Advanced --> Environment Variables and removed the PHP element in the Path variable, and then also removed the PHPRC (I think that was it's name) variable. Then removed the PHP folder present previously.

I then uninstalled and reinstalled WAMP

Everything seems to be working fine now. Thank you!

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: patan (---.righthemisphere.com)
Date: January 16, 2007 01:11AM

I had apache, php and mysql installed separatly before.
you mean I have to remove the environment variables and try to install that again, dont you?

will try that and get back to the forum,

cheers
Patan

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: yfastud (---.cable.mindspring.com)
Date: January 16, 2007 04:25AM

Make sure to clean the registry, too

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: patan (---.righthemisphere.com)
Date: January 16, 2007 09:30PM

what is the stuff I have to remove from the registry?

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: yfastud (---.cable.mindspring.com)
Date: January 17, 2007 12:49AM

Search and delete for anything related to apache, mysql, wampapache, and wampmysql

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: patan (---.righthemisphere.com)
Date: January 17, 2007 09:23PM

it works like a charm, thanks

I guess it would be great to have that check in the installer

Patan.

Options: ReplyQuote
Re: Can not connect to mysql
Posted by: yfastud (72.236.169.---)
Date: January 17, 2007 09:46PM

Glad you made it finally

Check my old post here for the idea

[forum.wampserver.com]

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)

Options: ReplyQuote


Sorry, only registered users may post in this forum.