Related

Product Now Available: Managed MySQL Databases Product
How to solve Mysql database connection error frequently after wordpress installation? Question Question
MySQL job will not start - database list could not be retrieved? Question Question

Question

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

Posted November 4, 2019 514 views
MySQLWordPress

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?

Add a comment
xfabioreims
By:
xfabioreims

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
richieframe November 5, 2019

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

Reply Report
andmoo November 5, 2019

@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

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help