Welcome to WebmasterWorld Guest from 54.196.217.43

Forum Moderators: phranque

Message Too Old, No Replies

Mysql 1045 error

     
6:43 pm on Apr 21, 2004 (gmt 0)

New User

10+ Year Member

joined:Apr 21, 2004
posts:4
votes: 0


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

7:08 pm on Apr 21, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


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.

7:17 pm on Apr 21, 2004 (gmt 0)

New User

10+ Year Member

joined:Apr 21, 2004
posts:4
votes: 0


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

Thanks for reply though ;)

7:31 pm on Apr 21, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Apr 12, 2002
posts:857
votes: 0


Try:
server=localhost;

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

7:31 pm on Apr 21, 2004 (gmt 0)

New User

10+ Year Member

joined:Apr 21, 2004
posts:4
votes: 0


Also, I've searched using the text you advised and it has given me 0 results :(
7:33 pm on Apr 21, 2004 (gmt 0)

New User

10+ Year Member

joined:Apr 21, 2004
posts:4
votes: 0


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

7:35 pm on Apr 21, 2004 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts:15755
votes: 0


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.

7:36 pm on Apr 21, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Apr 12, 2002
posts:857
votes: 0


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

Like:
MySql Server : IP Address

1:05 am on Mar 14, 2008 (gmt 0)

New User

5+ Year Member

joined:Mar 14, 2008
posts: 1
votes: 0


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