Re: How to prepare a corrupted MySQL system
and this is what happened.
thelma@origen:~$ mysqld stop
mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13 - Permission denied)
2016-10-10T16:28:08.711945Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-10T16:28:08.712024Z 0 [Warning] Can't create test file /var/lib/mysql/origen.lower-test
2016-10-10T16:28:08.712052Z 0 [Note] mysqld (mysqld 5.7.15-0ubuntu0.16.04.1) starting as process 1896 ...
2016-10-10T16:28:08.714496Z 0 [Warning] Can't create test file /var/lib/mysql/origen.lower-test
2016-10-10T16:28:08.714515Z 0 [Warning] Can't create test file /var/lib/mysql/origen.lower-test
2016-10-10T16:28:08.714551Z 0 [ERROR] failed to set datadir to /var/lib/mysql/
2016-10-10T16:28:08.714559Z 0 [ERROR] Aborting
2016-10-10T16:28:08.714567Z 0 [Note] Binlog end
2016-10-10T16:28:08.714609Z 0 [Note] mysqld: Shutdown complete
thelma@origen:~$ su -
Password:
root@origen:~# mysqld stop
2016-10-10T16:28:38.243263Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-10T16:28:38.243987Z 0 [Note] mysqld (mysqld 5.7.15-0ubuntu0.16.04.1) starting as process 1926 ...
2016-10-10T16:28:38.245790Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
2016-10-10T16:28:38.245811Z 0 [ERROR] Aborting
2016-10-10T16:28:38.245826Z 0 [Note] Binlog end
2016-10-10T16:28:38.245868Z 0 [Note] mysqld: Shutdown complete
root@origen:~# mysqld --init-file=/home/thelma/Documents/Computer_files_MySQL./mysql-init.txt
2016-10-10T16:29:25.140856Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-10T16:29:25.141425Z 0 [Note] mysqld (mysqld 5.7.15-0ubuntu0.16.04.1) starting as process 1935 ...
2016-10-10T16:29:25.142903Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
2016-10-10T16:29:25.142925Z 0 [ERROR] Aborting
2016-10-10T16:29:25.142947Z 0 [Note] Binlog end
2016-10-10T16:29:25.142996Z 0 [Note] mysqld: Shutdown complete
root@origen:~#
Subject
Written By
Posted
Re: How to prepare a corrupted MySQL system
October 10, 2016 10:32AM
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.