MAMP & Dreamweaver MX

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:

Quote:

---

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:

Code:

---

$ mysql -uroot -p

---

It will then prompt you for a password, before logging into localhost.