Hello! I have the following problem with the database. What I realized from the error is that it is because the host is on localhost. So I shut down the mariadb service, enter the mysql console in safe mode, change the host to 127.0.0.1. I try to start the service again but it doesn’t work. But while the service is off I manage to log in from phpMyAdmin. So I restart the server, the database starts but again the host is autoconfigured to localhost.
according to chatGpt the problem is due to a third party software that manages the database, so here it is. Any ideas?
hello maestro, a pleasure to greet you. Look, when I connect to the mysql console if I don’t indicate the host it tells me ERROR 1045 (28000) access denied for root@localhost. On the other hand if I indicate the host. mysql -h 127.0.0.1 -u root … Login without problems
maybe not related — somewhere is documented a quirk with mysql, and possibly some other software packages — localhost is treated differently than 127.0.0.1 – specifying localhost tells the software to connect to a unix socket, such as /var/lib/mysql/mysql.sock but 127.0.0.1 has the software connecting thru the network stack, typically on port 3306.