Problems to connect Mysql...HELP ME!!!!

felipe_lopes

I'm having problems to connect mysql db after insert my host, user and password...
I used all the commmands as I should to and I put my host, username and password into mysql...When I try to open "db_connect.php" it says "Access denied for user:" ... But I used my correct password and user...I check it a million times!!!!!!
Could anyone help me please?? I'm going crazy with that!!!

db_connect.php code:

$connection = mysql_connect("localhost", "myusername", "mypassword") or
die("Couldn't connect.");

if ($connection) {
$msg = "Success!";
}

<HEAD>
<TITLE>MySql Connection</TITLE>
</HEAD>
<BODY>

<? echo "$msg"; ?>

</BODY>

Commands to insert user into Mysql:

opened dos
cd c:\mysql\bin\
mysqld --standalone
mysql
use mysql;
insert into user (host, user, password) values ('localhost', 'myusername', password('mypassword'));

What am I doing wrong???
Thank you

Felipe Lopes

Anon

I had a similar problem with mine and it turned out that my web hosting company had inserted the password wrong (a lower case CAPITAL mix up on one of the letters)

If it was set up by someone else then check that they have entered it correctly or that you are entering the password with the correct case's

Danny

felipe_lopes

It's not that because I'm having that pronblem with mysql installed on my machine, not with a web hosting company :-(

Felipe Lopes

lawnmowerman

I'm not exactly sure how to do it on a Windows machine, but after changing the user, host, or db access tables, you need to do a reload on the server so it reads the changes.

-Rich

[deleted]

Try using the GRANT statement in MySQL to give access. Don't do it by hand.

[deleted]

I doubt it.
Anyway, if you use MySQL's GRANT command you don't have to reload (it would be silly to have to reload a table after adding a record wouldn't it?)

felipe_lopes

Thank you Guys!
I restarted my computer and, I don't know, why my script to connect MySql started to work! Strange, doesn't it?
Thank you!

Felipe Lopes

lawnmowerman

Well, like I said in my original post, you need to reload
the MySQL server so that it re-reads the tables in the mysql database. 🙂

Rebooting, while not the most elegant way to reload a database in MySQL, DID force it to reload 🙂

-Rich

[deleted]

Ya, so in future just use the GRANT statement. Saves you a lot of headaches and re-loads.

felipe_lopes

I don't know how to use the GRANT statements...How should I use it?
Thank you

Felipe Lopes

[deleted]

At the risk of being flamed: Read the manual

http://www.mysql.com/doc/G/R/GRANT.html

felipe_lopes

Thank you Vincent!