Page 1 of 1

MySQl problem

PostPosted: 10. February 2009 15:36
by jerafini
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

Re: MySQl problem

PostPosted: 10. February 2009 15:41
by jerafini
hi pls help out.

how can i delete the password in the my.ini.Setup. curser can't go in

Re: MySQl problem

PostPosted: 10. February 2009 16:27
by Wiedmann
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.

Re: MySQl problem

PostPosted: 03. September 2009 10:15
by sv_vanan
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")
?>

Re: MySQl problem

PostPosted: 03. September 2009 10:37
by Altrea
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

Re: MySQl problem

PostPosted: 03. September 2009 11:52
by Wiedmann
Can't connect to MySQL server on 'localhost' (10061)

Just start the MySQL server.
(Or allow connections to it in your firewall.)