MySQL Forums
Forum List  »  Data Recovery

Some tables read only
Posted by: Thomas Drebert
Date: July 29, 2016 11:13AM


First my Config:
Ubuntu Yakkety Yak (development branch) 16.10
Kernal 4.4.0-33-generic x86_64
MySQL Ver 5.7.13-0ubuntu4 for Linux on x86_64 ((Ubuntu))
MySQL Datadir: /media/thomasd/transfer/mysql/

I can not say exactly how long the problem persists.
But I think it was after a crash.
My first Problem was Ubuntu tell me i am not in sudoers, This i can fix.
But now mysqld can't start. The Error is:

mysqld: Can't change dir to '/media/thomasd/transfer/mysql/' (Errcode: 13 - Permission denied)

All rights in the directory are correct and Appamore is configured correctly.

With the command "mysqld_safe --skip-grant-tables" i can start the mysqld and try to check the Database with "mysqlcheck"

The result, many tables are read only and the mysql.user is read only too.
So i can't revover the root password.
So far I have not found a way the "read only" back off. Create a dump is even not possible.
A new installation did not help.

Does anyone have an idea what to do?


Options: ReplyQuote

Written By
Some tables read only
July 29, 2016 11:13AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.