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: 17102
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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

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: 17102
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 80 guests