mysql issues

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

mysql issues

Postby Termanater13 » 22. February 2007 21:51

its says the php admin can not connect to the MYSL and I have no idea how to fix it.
Termanater13
 
Posts: 16
Joined: 20. February 2007 18:29

Postby Wiedmann » 22. February 2007 21:54

the php admin

You mean "phpMyAdmin"?

can not connect to the MYSL

This is the complete error message?

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

Postby Termanater13 » 22. February 2007 21:57

yes I do mean PHPmyadmin.

when I head to http://localhost/phpmyadmin/ I get this on the screen
phpMyAdmin - Error

Cannot load mysql extension. Please check your PHP configuration. - Documentation
Termanater13
 
Posts: 16
Joined: 20. February 2007 18:29

Postby Wiedmann » 22. February 2007 22:00

Cannot load mysql extension. Please check your PHP configuration.

You have installed XAMPP like you can read on the homepage (or readme_en.txt)?
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Termanater13 » 22. February 2007 22:18

I followed the readme for my OS and its still not working, Im still geting the same error code
Termanater13
 
Posts: 16
Joined: 20. February 2007 18:29

Postby Wiedmann » 22. February 2007 22:25

I followed the readme for my OS

Can you explain what you have done?

BTW:
- OS version?
- XAMPP version?
- installed with: installer/sfx/zip?
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Termanater13 » 22. February 2007 22:33

Wiedmann wrote:
I followed the readme for my OS

Can you explain what you have done?

BTW:
- OS version?
- XAMPP version?
- installed with: installer/sfx/zip?


OS: windows 98SE
XAMPP: 1.6.0
installed with a intaller

and I followed this copped strait from the readme_en.txt file
* MYSQL NOTES:

(1) The MySQL server can be started by double-clicking (executing) mysql_start.bat. This file can be found in the same folder you installed XAMPP in, most likely this will be C:\xampp\.
The exact path to this file is X:\xampp\mysql_start.bat, where "X" indicates the letter of the drive you unpacked XAMPP into. This batch file starts the MySQL server in console mode. The first intialization might take a few minutes.
Do not close the DOS window or you'll crash the server!
To stop the server, please use mysql_shutdown.bat, which is located in the same directory.

(2) To use the MySQL Daemon with "innodb" for better performance, please edit the "my" (or "my.cnf") file in the C:\xampp\mysql\bin directory or for services the c:\my.cnf for windows NT/2000/XP. In there, activate the "innodb_data_file_path=ibdata1:30M" statement. Attention, "innodb" is not recommended for 95/98/ME.
To use MySQL as Service for NT / 2000 / XP, simply copy the "my" / "my.cnf" file to "C:\my", or "C:\my.cnf". Please note that this file has to be placed in C:\ (root), other locations are not permitted. Then execute the "mysql_installservice.bat" in the mysql folder.

(3) MySQL starts with standard values for the user id and the password. The preset user id is "root", the password is "" (= no password). To access MySQL via PHP with the preset values, you'll have to use the following syntax:

mysql_connect("localhost", "root", "");

If you want to set a password for MySQL access, please use of MySQL Admin.
To set the passwort "secret" for the user "root", type the following:

C:\xampp\mysql\bin\mysqladmin.exe -u root -p secret

After changing the password you'll have to reconfigure phpMyAdmin to use the new password, otherwise it won't be able to access the databases. To do that, open the file config.inc.php in \xampp\phpmyadmin\ and edit the following lines:

$cfg['Servers'][$i]['user'] = 'root'; // MySQL User
$cfg['Servers'][$i]['auth_type'] = 'http'; // HTTP authentification

So first the 'root' password is queried by the MySQL server, before phpMyAdmin may access.
Termanater13
 
Posts: 16
Joined: 20. February 2007 18:29

Postby Wiedmann » 22. February 2007 22:40

Can you execute the file "setup_xampp.bat" and post what happens?

After that:
Can you post from the "httpd.conf" the line with "ServerRoot" and from "php.ini" the line with "extension_dir"?
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Termanater13 » 22. February 2007 22:51

Wiedmann wrote:Can you execute the file "setup_xampp.bat" and post what happens?

After that:
Can you post from the "httpd.conf" the line with "ServerRoot" and from "php.ini" the line with "extension_dir"?


this should be it

setup_xampp.bat: invalid directory
extension_dir = "C:\Program Files\xampp\php\ext"
serverRoot "C:/Program Files/xampp/apache"
Termanater13
 
Posts: 16
Joined: 20. February 2007 18:29

Postby Wiedmann » 22. February 2007 22:59

setup_xampp.bat: invalid directory

That's all?

BTW:
Can you see something about MySQL in phpinfo()?
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Termanater13 » 22. February 2007 23:02

no I can not, and the mysql is running
Termanater13
 
Posts: 16
Joined: 20. February 2007 18:29

Postby Wiedmann » 22. February 2007 23:34

setup_xampp.bat: invalid directory

That's all?

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

Postby Termanater13 » 22. February 2007 23:47

is there any thing I can do to fix it
Termanater13
 
Posts: 16
Joined: 20. February 2007 18:29

Postby Wiedmann » 22. February 2007 23:58

I don't know, if you don't answer questions completely...
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Termanater13 » 23. February 2007 00:22

Termanater13 wrote:
Wiedmann wrote:Can you execute the file "setup_xampp.bat" and post what happens?

After that:
Can you post from the "httpd.conf" the line with "ServerRoot" and from "php.ini" the line with "extension_dir"?


this should be it

setup_xampp.bat: invalid directory
(php.ini) extension_dir = "C:\Program Files\xampp\php\ext"
(extension) serverRoot "C:/Program Files/xampp/apache"


in here has all the answers you asked for exept I added the filee they came from, what else do I need to give so I can get some help I did not add the file it came from since I fugured you could figure it out since you asked one thing from each file. ass for the mysql in the phpinfo() like I said I could not find a thing even with it running. and the XMAPP says its running.
Termanater13
 
Posts: 16
Joined: 20. February 2007 18:29

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 93 guests