MariaDB: Webmin MySQL Startup Script /etc/rc.d/init.d/mysqld Was Not Found
MariaDB, the enhanced in-place upgrade of MySQL database management system, is getting more popular each passing day. We decide to upgrade from MySQL, which comes preinstalled in CentOS, to MariaDB 5.5, and subsequently to MariaDB 10, the latest version of MariaDB available now.
However, after installing MariaDB, Webmin and Virtualmin no longer able to manage the MariaDB. When navigating to Webmin -> Servers -> MySQL Database Server, the following error message is shown:
The MySQL startup script /etc/rc.d/init.d/mysqld was not found on your system. Maybe MySQL is not installed, or your module configuration is incorrect.
The package can be automatically installed by Webmin. Click here to have it downloaded and installed using YUM.
Cause
The reason the error occurred because the native MariaDB and MySQL distributions come with mysql.server startup script, which would be installed with the name “mysql” in the /etc/init.d directory automatically in Linux systems using RPM package (MariaDB-server-VERSION.rpm), such as Red Hat Enterprise Linux (RHEL), Fedora, CentOS, Scientific Linux and etc.
However, some vendors provide RPM packages that install a startup script under a different name such as “mysqld”. In fact, it’s such a common practice to install MySQL startup script as “mysqld” that Webmin is looking for mysqld by default for the MySQL startup script name.
Solution
Login to Virtualmin or Webmin, then go to Webmin -> Servers -> MySQL Database Server, then click on Module Config at the top left corner.
Then, select System configuration at the “Configuration category” drop down list. It’s also possible to click on Prev or Next button until arriving at the correct category.
Change the path and name to the correct MariaDB startup script for Command to start MySQL server and Command to stop MySQL server. Normally, the values should be:
Note
Verify that the “mysql” file actually exists in /etc/rc.d/init.d/ directory, or else find out what’s the correct path and file name of the MariaDB startup script, the replace the values accordingly.
Command to start MySQL server: /etc/rc.d/init.d/mysql start Command to stop MySQL server: /etc/rc.d/init.d/mysql stop
Click on “Save” button when done, and Webmin will allow management and configuration of MySQL and MariaDB right away.
LK is a technology writer for Tech Journey with background of system and network administrator. He has be documenting his experiences in digital and technology world for over 15 years.Connect with LK through Tech Journey on Facebook, Twitter or Google+.
