I am trying to connect my database I created using MAMP to Dreamweaver MX is anyone familiar with the settings I would need to use in Dreamweaver to make a testing server and then connect to the database?
Thanks,
Tom
I don't think that dreamweaver works with a database. You'd make your php (or other) page in DW, then view and that would be what connects, not DW.
I think, anyway. That's how it works with mysql.
In Dreamweaver I can select a testing server and also make a database connection... but can't seem to make that connection... i use localhost <username>root <password>root... still no go :(
I wouldn't know, then. didn't realize it had db integration.
maybe localhost is wrong.
never tried to connect with dw myself, so can't really help, sorry.
Shouldn't be logging in as root.
Are you sure that your password is right? If it is, it shouldn't be; that's a really stupid password, especially for the root account.
Well... it's just on his local machine. But, yeah.
Maybe you're just giving us an example?
Doesn't matter... it's open to the Internet, unless s/he's behind a firewall; even if s/he is, it'll make his/her machine more vulnerable in the possibility that somebody does get past that firewall.
Sure, but I figure once someone's one my computer, there's a lot more important stuff I wouldn't want people getting than the contents of a database. Then again, this database might contain something particularly special.
Either way, though, I'd agree changing it doesn't hurt and probably helps.
Getting past a firewall doesn't always equal gaining access to a computer :) If someone were, for example, to gain access to another machine on the network, it would leave the Mac open.
Eh, that's true. I'm assuming tomy didn't give us his password, though. Right? Help us end this cycle :p
actually dj now that you emtion it... i removed MAMP too many hassles... i installed MySQL and all is working fine... have added a new user with a goo dpassword... Do i just delete the user localhost?
haha, alright.
hmm.... you wouldn't want to delete the user, I don't think, but not use it for security reasons. Let's see what Twey says, he'll know more about that.
No, leave the root user alone, it's needed for maintenence. However, change the password to something very secure. Off-hand, I recommend:
!e2@*T!ix$g8
Obviously this is just an example, and you certainly shouldn't use this password now it's been posted on the Internet.
Guys... ok I put a password on the root, on local host now I can't login into myAdmin at all... it's died... what did I do wrong? This is the error:
Welcome to phpMyAdmin 2.8.1
Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.
Error
MySQL said:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
You need to set your password up correctly with phpMyAdmin. However, I recommend not using phpMyAdmin at all, and instead administering your databases with the simple "mysql" command-line client. You will get a much better feel for the language that way.
i can't access phpMyAdmin now I just keep getting that error... any way to fix it?
actually how can I fix it with the terminal then? i might try and learn it this way like you suggested... i use a mac and can never access my sql though... typing /usr/local/mysql, although if i type this into the terminal /usr/local/mysql/bin/mysqladmin it gives me all the info about MySQL
Just run the "mysql" program, wherever it may be located on your system, with -uusername -p. For example:
$ mysql -uroot -pIt will then prompt you for a password, before logging into localhost.