I was using CentOS as a web server and while it worked fine i wanted to use a debian based server. I downloaded the Heron LTS iso and installed it, rather than install a LAMP system from the install i did a basic install so i could install the AMP parts manually. All went well until i wanted to restore my mysql databases. I use phpmyadmin to create databases because i’m lazy and it’s easy to click the priveleges link, add the usename/password job done but when i used the mysql command to import the .sql files, this is where it went tits up. For some reason it kept giving me
ERROR 1045 (28000) : Access denied for user: ‘myusername@localhost’ (Using password: YES)
I knew the username and password was correct but apprently it’s something to do with the user information being wrong in the user table….don’t ask me what, i gave up after a while and installed debian etch which i knew would work straight away…….
I’ll figure it out but until i do, debian which i think is actually quicker on my machine than CentOS will stay on it.
Related posts:
I had the same problem when I upgraded to Hardy. I figured there was some compatibility issue between MySQL and phpMyAdmin. I ended up creating my user accounts via the command line. I posted about it here: http://tinyurl.com/4mc4ux Once I’d done that, phpMyAdmin worked fine.