Question
Is the wordpress 1-click installation using mysql or mysqld?
- Posted on November 4, 2019
- MySQLWordPress
Asked by xfabioreims
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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
@richieframe has mapped out the files for you nicely, now to deal with the startup issue.
Try using the command
sudo systemctl start mysqlto 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
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