Unable to determine if daemon is running: No such file
Now I want to show how to solve mysql error like can’t start mysql daemon after downgrade. So let’s start this command how to solve this error or how to start mysql daemon.
- How To Change MySQL Root Password Using Terminal Ubuntu Server
- How To Setup Permanent DNS Nameservers on Ubuntu 19.04
First see this is error message like below image.
Solution :
[[email protected] ~]# service mysqld stop [[email protected] ~]# rm -rf /var/lib/mysql/* [[email protected] ~]# service mysqld start
Now you can change mysql password using temporary password.
[[email protected] ~]# sudo grep 'temporary password' /var/log/mysqld.log
See output like below.
2021-01-12T01:56:12.775427Z 1 [Note] A temporary password is generated for [email protected]: AkYq?.j5-ePJ
So now try to change mysql password using temporary password.
[[email protected] ~]# sudo mysql_secure_installation
Now change mysql password using this steps then login mysql terminal using below command.
[[email protected] ~]# mysql -u root -p
Check mysql version using below command.
[[email protected] ~]# mysqladmin -u root -p version
Output like this below.
mysqladmin Ver 8.42 Distrib 5.7.32, for Linux on x86_64
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 5.7.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 22 min 1 sec
Threads: 1 Questions: 36 Slow queries: 0 Opens: 120 Flush tables: 1 Open tables: 113 Queries per second avg: 0.027
Enjoy mysql service 🙂