0
Kod:
michal@michal-Latitude-E7270:~$ sudo kill `sudo cat /var/run/mysqld/mysqld.pid`
michal@michal-Latitude-E7270:~$ sudo chown michal /home/michal/mysql-init
michal@michal-Latitude-E7270:~$ mysqld --init-file=/home/michal/mysql-init &
[1] 19683
michal@michal-Latitude-E7270:~$ mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13 - Permission denied)
2020-11-09T16:48:58.783409Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-11-09T16:48:58.783488Z 0 [Warning] Can't create test file /var/lib/mysql/michal-Latitude-E7270.lower-test
2020-11-09T16:48:58.783514Z 0 [Note] mysqld (mysqld 5.7.31-0ubuntu0.18.04.1) starting as process 19683 ...
2020-11-09T16:48:58.786032Z 0 [Warning] Can't create test file /var/lib/mysql/michal-Latitude-E7270.lower-test
2020-11-09T16:48:58.786050Z 0 [Warning] Can't create test file /var/lib/mysql/michal-Latitude-E7270.lower-test
2020-11-09T16:48:58.786357Z 0 [Warning] One can only use the --user switch if running as root
2020-11-09T16:48:58.786383Z 0 [ERROR] failed to set datadir to /var/lib/mysql/
2020-11-09T16:48:58.786417Z 0 [ERROR] Aborting
2020-11-09T16:48:58.786430Z 0 [Note] Binlog end
2020-11-09T16:48:58.786459Z 0 [Note] mysqld: Shutdown complete
[1]+ Kod wyjścia 1 mysqld --init-file=/home/michal/mysql-init
michal@michal-Latitude-E7270:~$ sudo /etc/init.d/mysql restart
[ ok ] Restarting mysql (via systemctl): mysql.service.
michal@michal-Latitude-E7270:~$ mysql -uroot -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
michal@michal-Latitude-E7270:~$
Czyli tylko reinstalacja coś da tak?