mySQL?

[Asday]

<?php

$sqlCon=mysql_connect("localhost", "asday", "***");
if (!$sqlCon)
{
die("Fark! " . mysql_error());
}
else
{
mysql_query("CREATE DATABASE people");
}
?>

 

outputs:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'asday'@'localhost' (using password: YES) in C:\xampp\htdocs\SQL\index.php on line 3
Fark! Access denied for user 'asday'@'localhost' (using password: YES)

 

What's wrong?

[Vibralux]

Are you on shared hosting?

[Asday]

On localhost - Dedicated hosting.

 

I don't understand that.  Geniuses near me told me.

[Yesideez]

Have you set the correct permissions for the user to access the database?

[Asday]

Have you set the correct permissions for the user to access the database?

 

How do I do that?

 

(googling didn't help)

[Yesideez]

If you go to cPanel you can set them from there.

[keeB]

Permission issue.

 

 GRANT ALL ON <database>.<tablename> TO Asday 

[Yesideez]

Thanks keeB, I can never remember how to set it in PHP.

[Asday]

That won't help, as I can't connect to the database.

 

Also, can't find cPanel, but mySQL did ask for a username and pass when I started it up. 

[Yesideez]

Have you got MySQL and PHP installed on your computer or are you running live?

[Asday]

Everything's local.

 

Put it this way, if I suddenly lost the internet, everything (that works now) would still work.

[Yesideez]

1. Have you created a user and set a password for it?

2. Have you got the correct username and/or password?

3. Are the permissions set?

4. If you installed WAMP go into cPanel which gives you access to phpMyAdmin. From there you can check everything via a GUI which will make everything a lot easier.

[Asday]

1. Have you created a user and set a password for it?

2. Have you got the correct username and/or password?

3. Are the permissions set?

4. If you installed WAMP go into cPanel which gives you access to phpMyAdmin. From there you can check everything via a GUI which will make everything a lot easier.

 

1)  Yes

2)  Yes

3)  Don't know

4)  Didn't install WAMP

 

(Going home now, so no PC)

[Asday]

(Going home now, so no PC)

 

(Back now!)

[keeB]

By default, the mysql root password is empty.

 

To check this out, open the command prompt and do the following:

 

cd c:\path\to\mysql\bin

mysql -u root

 

If this logs you in, then you need to do the following

GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

 

Also, make sure to update the root password:

 

UPDATE mysql.user SET password = PASSWORD('new_pass') where mysql.user = 'root';

 

Good luck

[Asday]

By default, the mysql root password is empty.

 

To check this out, open the command prompt and do the following:

 

cd c:\path\to\mysql\bin

mysql -u root

 

If this logs you in, then you need to do the following

GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

 

Also, make sure to update the root password:

 

UPDATE mysql.user SET password = PASSWORD('new_pass') where mysql.user = 'root';

 

Good luck

 

Would that be Linux or windoze command prompt?

[keeB]

If you're running Linux, mysql should be in the PATH by default.

 

so in that case, it would just be

mysql -u root

 

In windows, if not apart of the PATH, you must open a command prompt at c:\program files\mysql server 5.0\bin (or equivalent) and run the same command

mysql -u root