I'm trying to connect to mySQL but all it does is showing this message :

Warning: mysql_connect(): Accès refusé pour l'utilisateur: 'kilgayne'@'@localhost' (mot de passe: NON) in c:\program files\easyphp1-8\www\mysql.php on line 9

Warning: mysql_query(): Accès refusé pour l'utilisateur: 'ODBC'@'@localhost' (mot de passe: NON) in c:\program files\easyphp1-8\www\mysql.php on line 10

Warning: mysql_query(): A link to the server could not be established in c:\program files\easyphp1-8\www\mysql.php on line 10
ERROR CONNECTING TO MYSQL!

here's the code i use

mysql_connect("localhost","kilgayne","");
$result=mysql_query("show status");
if ($result==0) echo "ERROR CONNECTING TO MYSQL!";
else echo "CONNECTED!";

now can anybody tell me wtf i'm doing wrong?

From what I see I think you haven't created a user "kilgayne" in the mysql db
try it with "root".

On the other hand, you may have a problem with your configuration files and you will also have to make sure that your php modules are well set.

since you are using easyphp, this should be as easy as 'abc'.

Tip:

While creating users, specify which authority they have, read, write , update, delete, etc.


Hope this helped.


Cheers,

Old_Spen.

yay \o/ it works with "root"! danke schön spen!

i thought the users on mysql were, like, the same that those on the OS (there's only the user Kilgayne on my comp so meh) (and yes, i'm a total newb)

Hello u got a mistake in your connection. thats why u having that error code
Where we have
this
$conn= mysql_connect("localhost","blah_kilgayne","passwor d"); or die cannot connect to db mysql error());
$db = mysql_select_db ("blah_db");
$query = ( blah blah
$result=mysql_query("show status");
if ($result==0) echo "ERROR CONNECTING TO MYSQL!";
else echo "CONNECTED!";

and not

mysql_connect("localhost","kilgayne","");
$result=mysql_query("show status");
if ($result==0) echo "ERROR CONNECTING TO MYSQL!";
else echo "CONNECTED!";


Thats just an example

err thx I guess... but this problem was solved weeks ago :-? so yeah

i'm not having any more problems with mysql. as a matter of fact last week i could finish building the basics of my site. thanks to spen for helping me out :-P