MAMP & Dreamweaver MX

[tomyknoker]

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?

[djr33]

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.

[Twey]

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.

[tomyknoker]

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)

[Twey]

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.

[tomyknoker]

i can't access phpMyAdmin now I just keep getting that error... any way to fix it?

[tomyknoker]

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

[Twey]

Just run the "mysql" program, wherever it may be located on your system, with -uusername -p. For example:

$ mysql -uroot -p

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