Is the wordpress 1-click installation using mysql or mysqld?

November 4, 2019 103 views
MySQL WordPress

Hello there.

I’m desperately trying to troubleshoot my “Error establishing a database connection” error since even after a restart, where the memory should be empty, my website is no longer loading.

Therefore, I’ve been playing around with the mysql error file and mysql settings. I have a lot of files to choose from inside of /etc/mysql. Yet my the biggest file and only file with actual config is inside of /mysql.conf.d/ and named “mysqld.cnf”.

The problem however is, that service mysqld start ends in “Failed to start mysqld.service: Unit mysqld.service not found.

Does that mean that my 1-click wordpress installation is using mysql instead of mysqld?

2 Answers

mysql is mysqld, specifically mysql is the application mysqld is the executable name for the service.

The /etc/mysql folder contains configuration files, /var/lib/mysql/ contains the database files, /var/log/mysql/ contains the log files…

And finally /usr/sbin/mysqld which is the actual program, which is started by a service named mysql.service

This file is located in /lib/systemd/system

If systemctl start mysql does not work, you may be missing files, configuration may be incorrect

@richieframe has mapped out the files for you nicely, now to deal with the startup issue.

Try using the command sudo systemctl start mysql to invoke a startup of the MySQL Server.

Should this fail then look for ‘ERROR’ in the mysql error log. This should be found at the path described in your configuration file.

If you get a successful startup it’s worth looking at the log anyway to ensure that there were no peripheral issues with starting MySQL. This is considered best practice.

Good luck,

Andmoo

Have another answer? Share your knowledge.