xampp for Windows 1.7.0 - no access to myPhpAdmin

Problems with the Windows version of XAMPP, questions, comments, and anything related.

xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby BROE » 25. February 2009 16:14

Having installed xampp 1.7 I am unable to access myPhpAdmin for creation of a database:

# 2003 Server is not answering -
Connection for control user as defined in your configuration failed.

(Translated from a Danish error code text)

I uninstalled a previous version and installed 1.7.0 after cleaning and restarting. Running Vista. Can anyone help? Could it be a bug since quite a few others apparently have trouble with access rights,too?

Thank you and best regards
BROE
BROE
 
Posts: 7
Joined: 25. February 2009 15:53

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby Wiedmann » 25. February 2009 16:22

# 2003 Server is not answering -

Is MySQL running?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby BROE » 25. February 2009 16:23

No - even after reinstallation ...
BROE
 
Posts: 7
Joined: 25. February 2009 15:53

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby Wiedmann » 25. February 2009 16:46

No

Why not?

- if you start MySQL as service, read the Windows event log
- if you your start MySQL as application, use mysql_start.bat to read an error message
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby newbie2244 » 26. February 2009 00:07

I had the same problem - It turned out that I needed to load some .dll's from php.ini (uncomment them) and then insert the
path to PEAR in the path variable. I inserted this -- C:\xampp\PHP\Pear -- into the system path variable and everything worked almost perfectly. Hope this helps.
newbie2244
 
Posts: 49
Joined: 20. February 2009 22:39

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby BROE » 26. February 2009 11:30

-> newbie - thank you - but I would like to avoid fiddling with files - being unfamiliar with xampp at that level ...

-> Wiedmann
My Windows event log says (in Danish, unfortunately)

Problemhændelsesnavn: APPCRASH
Programnavn: apache.exe
Programversion: 2.2.11.0
Tidsstempel for program: 493f5d44
Fejlmodulnavn: ntdll.dll
Fejlmodulversion: 6.0.6001.18000
Tidsstempel for fejlmodul: 4791a7a6
Undtagelseskode: c0000005
Undtagelsesforskydning: 0006814c
OS-version: 6.0.6001.2.1.0.768.3
Landestandard-id: 1030
Yderligere oplysninger 1: b940
Yderligere oplysninger 2: e41a9fc4d02d7632b375a2c9d249a774
Yderligere oplysninger 3: 4103
Yderligere oplysninger 4: 343c0f93a939bdbedbd00295f403436d

So why does it crash? I haven't got a clue. No trouble with earlier versions - considering reinstallation of 1.6.8.
Best regards BROE
BROE
 
Posts: 7
Joined: 25. February 2009 15:53

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby Wiedmann » 26. February 2009 13:12

My Windows event log says (in Danish, unfortunately)
Code: Select all
Programnavn: apache.exe

Well, that's from Apache and not MySQL (and maybe another problem).

Back to your first question:
Are you starting MySQL as service (Svc is checked in Control Panel) or not?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby BROE » 26. February 2009 15:39

I am starting MySQL as service and read the Windows event log. Have also tried mysql_start.bat and mysql_stop.bat - and the information indicates that a file is missing. Reinstallation?
BROE
 
Posts: 7
Joined: 25. February 2009 15:53

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby Wiedmann » 26. February 2009 15:49

and the information indicates that a file is missing.

Which file?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby lmolenaar » 26. February 2009 20:20

I had a problem with php pages as well (including phpmyadmin)
Renaming some files (replacing originals) solved that problem for me.
See last comment of moderator in this topic.

If it does not work you can easily restore the original files
lmolenaar
 
Posts: 6
Joined: 26. February 2009 15:59

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby BROE » 27. February 2009 10:46

->Wiedmann/Imolenaar - thank you!

Wiedmanns recommendation to Imolenaar:
3 additional things to do:
- Rename/copy "libmysql_5.1.51a.dll" to "libmysql.dll" in "\xampp\apache\bin" and "\xampp\php".
- Rename/copy "php_mysql_5.0.51a.dll" to "php_mysql.dll" in "\xampp\php\ext".
- Rename/copy "php_mysqli_5.0.51a.dll" to "php_mysqli.dll" in "\xampp\php\ext".

I checked my folders."libmysql.dll", "php_mysql.dll" and "php_mysqli.dll" already exist in the respective folders along with the _5.1.51a.dll-files. Can I delete the _5.1.51a.dll-files or?

As for the apparently missing file, I could attach a screenshot (pdf-file) of the information from the ...start.bat-file. But it seems that special permission is required.
BROE
 
Posts: 7
Joined: 25. February 2009 15:53

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby Izzy » 27. February 2009 11:21

BROE wrote:I checked my folders."libmysql.dll", "php_mysql.dll" and "php_mysqli.dll" already exist in the respective folders along with the _5.1.51a.dll-files. Can I delete the _5.1.51a.dll-files or?
No you copy the _5.1.51a.dll files then rename the copies of the _5.1.51a.dll to the existing file names and overwrite the existing files with the renamed copies of the _5.1.51a.dll files - any clearer for you?


As for the apparently missing file, I could attach a screenshot (pdf-file) of the information from the ...start.bat-file. But it seems that special permission is required.
When you run the setup_xampp.bat file a console window opens and in the top left corner of the title bar is a small icon.

If you right click on the icon a context menu pops out.

Select Edit then Mark and then drag your cursor over the text to you want to copy.

Go back to the Edit menu again and select Copy.

Now go to your reply text box in the form and right click in the box and select paste.

Job done.
Last edited by Izzy on 12. March 2009 09:52, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby BROE » 27. February 2009 13:39

Thank you - too long since I worked with DOS and C:\ - :-)

The renaming/replacing operation did not work for me. Below you see the start.bat-text before renaming and after.

Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
InnoDB: The first specified data file D:\xampp\mysql\ibdata1 did not exist:
InnoDB: a new database to be created!
090227 13:11:31 InnoDB: Setting file D:\xampp\mysql\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090227 13:11:31 InnoDB: Log file D:\xampp\mysql\ib_logfile0 did not exist: new
to be created
InnoDB: Setting log file D:\xampp\mysql\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090227 13:11:31 InnoDB: Log file D:\xampp\mysql\ib_logfile1 did not exist: new
to be created
InnoDB: Setting log file D:\xampp\mysql\ib_logfile1 size to 5 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
090227 13:11:32 InnoDB: Started; log sequence number 0 0
090227 13:11:32 [Note] Event Scheduler: Loaded 0 events
090227 13:11:32 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL
)

-------------------------------
After renaming and replacing .dll-files:

Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
090227 13:28:35 InnoDB: Started; log sequence number 0 46409
090227 13:28:35 [Note] Event Scheduler: Loaded 0 events
090227 13:28:35 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL
)

- I am going to reinstall 1.6.8 ... Thanks to all rescuers!
BROE
 
Posts: 7
Joined: 25. February 2009 15:53

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby Wiedmann » 27. February 2009 13:42

The renaming/replacing operation did not work for me. Below you see the start.bat-text before renaming and after.

a) renaming these files have nothing to do with the MySQL server, only with the MySQL client in PHP.
b) I see no problems in your "mysql_start.bat" output.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: xampp for Windows 1.7.0 - no access to myPhpAdmin

Postby BROE » 01. March 2009 22:05

Hi again,

My knowledge of the different applications in xampp are limited, unfortunately.

But I managed to reinstall xampp 1.6.8 - although I now have to run it with the mysql.bat and apache.bat files. But luckily - and after a good deal of trouble - I have my databases up and running again. Neither the xampp 1.6.8 nor 1.7.0 console work at all - even though I installed at a different drive. Maybe Vista is the culprit - who knows.

May I be looking forward to xampp 1.7.1? : -). It is after all THE SOFTWARE for dummies like me!

Thanks again and best regards
BROE
BROE
 
Posts: 7
Joined: 25. February 2009 15:53


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 42 guests