I just sidestepped a rather large catastrophe - I had someone guess a password and upload a php file into the home directory of a wordpress site. I suspected they might have dumped the wp-config and got the db username/pw so I thought I would change the pw. big mistake! before I could log in with my user via mysql -u myuser -p and my password. after changing the password in ispconfig db users, suddenly mysql -u myuser -p did not recognize the myuser! I added a myuser1 in ispconfig, and in the mysql.user table it is NOT listed! 'myuser' is there but not 'myuser1'! now the root password in /...ispconfigpath/ .conf file is there and is correct. mysql -u root -p rootpassword works fine! but for some reason ispconfig does not seem to be affecting the mysql.user table at all. surely it should? not only did the new password not work (all wordpress sites using that database user gave databaseconnection error)., but I could not put in old password, or do anything! also addition oddness I used phpmyadmin to manually alter the mysql.user table (which I've done before for a forgotten password) - and I see the hash for root user (zzzzzzz) and I know what root user pw is and I put that pw in 'myuser' password, pick MD5 and save it. but in the table the created hash looks nothing like the hash that is shown for root! and copying the hash in root to myuser and saving (which then shows passwords the same in the mysql user,host,password dump - but the root password which should work now for myuser - is not recognized! I had to find a different database user, and put ITS password into the affected websites and change the dbuser in each database to the new user to get the sites back up! what on earth could be going on?? VERY odd. what a week from hell this has been!