MySQl problem

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

MySQl problem

Postby jerafini » 10. February 2009 15:36

i got the error 1000A1F7 in module 'LIBYSQL>DLL' i found the my.ini.set up. but it's popup and go fastly. i can't abel to delet ethe pass word
jerafini
 
Posts: 2
Joined: 10. February 2009 15:21

Re: MySQl problem

Postby jerafini » 10. February 2009 15:41

hi pls help out.

how can i delete the password in the my.ini.Setup. curser can't go in
jerafini
 
Posts: 2
Joined: 10. February 2009 15:21

Re: MySQl problem

Postby Wiedmann » 10. February 2009 16:27

i got the error 1000A1F7 in module 'LIBYSQL>DLL'

Don't start the program "WinMySQLAdmin" (admin button in CP) and remove it from your startup folder.
Wiedmann
AF Moderator
 
Posts: 17107
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MySQl problem

Postby sv_vanan » 03. September 2009 10:15

Hi,

I'm beginner to Xampp, i've created the database (helpdesk) using localhost\phpMyadmin and can see the database files in MySQL->Data folder. Then i've created the user interface in localhost\index.php, now the problem is i can't save the data from the user interface to the database. Anyone can advice why i can't connect to the database?

Error Message:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\xampp\htdocs\registerprocess.php on line 3
Could not connect: Can't connect to MySQL server on 'localhost' (10061)

The config.php file that i've used is as below:

<?php
$host= "localhost";
$pass="";
$login="";
$db= "helpdesk";
?>

The registerprocess.php is as below:
<?php
include ("config.php");
$con = mysql_connect($host,$login,$pass);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($db, $con);

mysql_query("INSERT INTO user (`UName`,`UPass`,`UDName`,`UType`)
VALUES('".$_POST["UName"]."', '".$_POST["UPass"]."', '".$_POST["UDName"]."', '".$_POST["UType"]."')");
mysql_close();
header("Location:default.html")
?>
sv_vanan
 
Posts: 1
Joined: 03. September 2009 10:00

Re: MySQl problem

Postby Altrea » 03. September 2009 10:37

connect to a mysql_server without a mysql_login_user will be very difficult ;)

try

$login="root";

instead of an empty string
or better, create a new user with password in phpmyadmin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
free software according to purpose of usage
XAMPP 1.8 for local development/testing only
Zend Server 6 (free) for production environments
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 4496
Joined: 17. August 2009 13:05
XAMPP Version: 1.8.0
Operating System: W7Ux64

Re: MySQl problem

Postby Wiedmann » 03. September 2009 11:52

Can't connect to MySQL server on 'localhost' (10061)

Just start the MySQL server.
(Or allow connections to it in your firewall.)
Wiedmann
AF Moderator
 
Posts: 17107
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 9 guests