I'm trying to install wordpress for the first time ubuntu just to play around with it.
Apache, php and mysql all appear to be installed OK and working.
Wordpress (installed via ubuntu package manager) gives "Error establishing a database connection".
I can log on to mysql as root
mysql --user=root --host=localhost --password=mypass wordpress
That seems to work OK but I cant log on as user wordpress.
I have tried creating the user in diffgerent ways.
Firstly, thru phpmyadmin. I log in as root, select localhost and click 'add new user'. I stick in user wordpress and the password twice, DO NOT click the confusing generate button, choose ioption to create a database with same name and grant all privileges etc and click add user.
I can't log in using the password I just created.
I have tried creating user via the mysql prompt. I can create a user with no password and log in ok. But if I provide a password then I cant log in :)
I have logge din as root, changed the password but to no avail.
mysql client api is 5.5.24
I'm sure I'm making some basic mistake but I really need an expert to help me get sorted. It really shouldnt be this hard!