Am 20.12.2013 19:13, schrieb Frank Röhm: >> i would make a backup of the datadir, delete the database and use >> "mysql_upgrade --force" after that because this database don't contain >> any persistent data and should be automatically created > > I cannot delete it, Access denied! > > I did on the commandline as root: > > MariaDB [(none)]> DROP DATABASE information_schema; > ERROR 1044 (42000): Access denied for user 'root'@'localhost' to > database 'information_schema'
i thought more about * stop server * backup datadir * delete the db-folder from filesystem * start mysqld * not 100% if it starts at all and re-creates it, thats why backup before trying this try i "repair table" on any table in this meta-db! the following command may do the same easier mysqlcheck -h localhost --check-upgrade --all-databases --auto-repair --user=root -p > But a look into my permissions, I get all 'Y' for: > SELECT * FROM mysql.`user` u where User = 'root' > So I think I have a big problem now, havent I? not really, it does not affect the data what maybe interesting to post * stop mysqld * make the mysqld-log empty * start mysqld * post the complete output of the mysqld-log
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
