I'm trying to go through the wordpress installation guide from MySQL Client (as found in the ( wordpress codex) and I'm having problems doing the basic steps.
I'm using a Macbook and accessing MySQL from iTerm. I want to have a local wordpress installation on this machine for site development.
When I go through the tutorial mentioned above and type the following command into iTerm:
mysql -u adminusername -p (substituting adminusername for 'nickadams' my username on this machine) it prompts me for a password.
If I use general password for my useraccount (typically used when I 'sudo' a command, for example) it throws up the error:
ERROR 1045 (28000): Access denied for user 'nickadams'@'localhost' (using password: YES)
If I try the above command again while leaving the password prompt blank, it lets me into mysql, but when I try the next command in the tutorial
CREATE DATABASE databasename; I get another error message:
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'wordpress'
I'm not too sure what I'm doing wrong here. Any suggestions?