MySQl problem
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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.)