On trying to start mysql.server start
./usr/local/bin/mysql.server: line 264: kill: (12262) - No such process ERROR!
On trying to connect mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- Stop MySQL / MariaDB.
- Go to
/usr/local/var/mysql - Delete
ib_logfile0&ib_logfile1files. - Try to start now, It should work 😎
There are many cases for mariadb or any other service to stop working properly on the computer.
causes
They can be the specific cause in this type of problems and for that a generic question in the communities to it does not always lead you to the answer/solution valid since the causes are several/different.
In my case I have followed the guidelines above but it did not solve the problem. And one of those was to execute the process of direct call to mariadb and its handler that uses the socket by default, this when executed tells you which threads and dependencies it has, it draws you technically where everything happens, besides showing you how it works.
# mysqldpreview it is important to see
# mysqld --verbose --help | grep “socket”To locate exactly where your configurations are in the system and what values they are taking.
My specific case was a memory error and a break when initializing services and dependencies which broke everything and had no service and could not schedule a three hours!!!
It is solved by making a backup of the tc.log file (same path in #coment) delete the last one and run
# mysqldso that the instances in mysql.servers regenerate the paths and processes to regenerate the path and be able to start the service with the correct configuration without breaking or forcing any process to act arbitrarily because that is the workflow where there is a problem you have to investigate to solve it and start everything again well.
Do yourself a favor as a developer read the warnings that the prompt returns and the errors that cause them, it will help you a lot.
Happy code.