Mysql 1045 error

[Steve_Uk]

Hi all,

I'm using mysql, php and phpmyadmin on Windows server 2003...web edition.

I've sert it up to allow php scripts to run, and phpmyadmin connects to the sql server fine, but when i try and make a sql connection in Dreamweaver, the server returns an error message. Something like.....steve@localhost Using password = yes blah blah blah error 1045.

I've read this around these forums, but never seemed to find an appropiate answer. Like i said....Phpmyadmin works fine, and i can run php scripts on it, it's just when i try and access the database it blocks me. I am entering the correct username and password, and i have full privileges.

Thanks in advance, Steve

[txbakers]

You must be using 4.1.1

There is a known bug that doesn't accept passwords correctly.

Do a search on these forums for mySQL 4.1.1 and you should find the information on it.

[Steve_Uk]

I don't think it is mate. The docs say 4.0.1.8.

Thanks for reply though ;)

[defanjos]

Try:
server=localhost;

The problem can be on the "server" part of connection string.

[Steve_Uk]

Also, I've searched using the text you advised and it has given me 0 results :(

[Steve_Uk]

In the connection box you mean in DW? I have it like this...

Connection name : mycon
MySql Server : localhost
Username : Steve
Password = ****xxxxx
Database = get stuck because this is when it returns the error

[jatar_k]

maybe try connecting as root first in your scripts and see if that works. Then you can assume that it is either a permissions problem or there is something wrong with your user/pass combo.

since ERROR 1045 is Access denied for user:..... it has to be one of those things. Try the root login and then go from there.

[defanjos]

Maybe using the IP address here will work:
MySql Server : localhost

Like:
MySql Server : IP Address

[damonpc]

Just had the same problem for over a week and finally had the ISP guys visit the office to resolve.

After 2 hours it turned out to be a problem with the password. They had used a random password generator that had generated a password with the '+' symbol in it. This worked fine accessing phpMyAdmin page via browser, but not when trying to set up connection via dreamweaver.

Anyway check your passwords and if necessary get them changed!

Hope it helps!

Damon