MySQL Forums
Forum List  »  Newbie

Re: How to prepare a corrupted MySQL system
Posted by: Alan Secker
Date: October 10, 2016 10:32AM

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:~#

Options: ReplyQuote




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.