Welcome to WebmasterWorld Guest from 54.147.44.93

Forum Moderators: phranque

Message Too Old, No Replies

Mysql 1045 error

     

Steve_Uk

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

10+ Year Member



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

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

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



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

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

10+ Year Member



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

Thanks for reply though ;)

defanjos

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

WebmasterWorld Senior Member 10+ Year Member



Try:
server=localhost;

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

Steve_Uk

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

10+ Year Member



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

Steve_Uk

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

10+ Year Member



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

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

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



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

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

WebmasterWorld Senior Member 10+ Year Member



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

Like:
MySql Server : IP Address

damonpc

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

5+ Year Member



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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month