homepage Welcome to WebmasterWorld Guest from 54.205.254.108
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
Mysql 1045 error
Steve_Uk




msg:666523
 6:43 pm on Apr 21, 2004 (gmt 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

 

txbakers




msg:666524
 7:08 pm on Apr 21, 2004 (gmt 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.

Steve_Uk




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

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

Thanks for reply though ;)

defanjos




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

Try:
server=localhost;

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

Steve_Uk




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

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

Steve_Uk




msg:666528
 7:33 pm on Apr 21, 2004 (gmt 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

jatar_k




msg:666529
 7:35 pm on Apr 21, 2004 (gmt 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.

defanjos




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

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

Like:
MySql Server : IP Address

damonpc




msg:3600111
 1:05 am on Mar 14, 2008 (gmt 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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved