Forums
This topic is locked
Connecting to SQL Database
Posted 20 Feb 2007 00:41:14
1
has voted
20 Feb 2007 00:41:14 Mike Woodard posted:
I am sort of new to this stuff but not a TOTAL rookie. I am trying to get dreamweaver to connect to my MySQL database. I went through the normal procedure and set up the connection but when I click test, I get an error...MySQL Error# 1045
Access denide to user 'xxxx@localhost' (Using Password: YES)
I thought that perhaps my password was wrong so I called tech support at my ISP and confirmed the username and password.
Here is the nutty part....I downloaded SQLyog (a 3rd party MySQL client) and used the same user name and password and it logged in fine.
Anyone out there have any idea as to why this would be happening only in DW? Help!!!
Replies
Replied 17 Mar 2007 07:38:06
17 Mar 2007 07:38:06 alansnoog alansnoog replied:
hi,
try this tip,
SET PASSWORD FOR 'root'@'your_hostname' = PASSWORD('set_password');
<a href="www.softsea.com/">software reviews</a>
try this tip,
SET PASSWORD FOR 'root'@'your_hostname' = PASSWORD('set_password');
<a href="www.softsea.com/">software reviews</a>