I upgraded from Debian 6 to 7 and during the upgrade, MySQL asked for new root password, I was little confused but typed it anyways. I guess this created a new database called 'mysql', because now there is 'wordpress' and 'mysql' directories:
# ls /var/lib/mysql/ debian-5.1.flag debian-5.5.flag ibdata1 ib_logfile0 ib_logfile1 mysql mysql_upgrade_info performance_schema wordpress
I queried the 'wordpress' database (correct one) with mysql-client and seems like data is still there. However, it doesn't load anything from the 'wordpress' database when I go to my website (except the index.php page). My admin page and media content is also unavailable, so I'm guessing it's a MySQL side problem.
My wp-config.php is correct, I haven't touched it (uses the wordpress DB). I have no idea where to look for.
Here is how my page looks like:
Edit: It's not about the permissions. I tried the other DB called mysql and it went in to the WordPress installation as it should. Both mysql and wordpress have the same rights. Also mysql_upgrade fails:
Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed