mysql startup script was not found

I'm receiving this error message after upgrading webmin recently can you give me detailed instructions on how to fix please?

I need to modify the max allowed packet for MySQL but I can't access the module via Webmin anymore after the update. I do know that MySQL is running but I can't access it from the Webmin console.

The MySQL startup script (/usr/local/bin/safe_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 FreeBSD ports.

Status: 
Active

Comments

Does the script /usr/local/etc/rc.d/mysql-server exist on your system? If so, try editing the file /etc/webmin/mysql/config and adding the following lines at the end :

start_cmd=/usr/local/etc/rc.d/mysql-server forcestart
stop_cmd=/usr/local/etc/rc.d/mysql-server forcestop

Hi Jamie I wasn't able to find that directory on my system. I'm running FreeBSD 8.0. Is there another way I can fix the mysql module so I can see it in the webmin gui? This problem started happening after I upgraded webmin a few weeks ago.

Sorry, I forgot that on FreeBSD the file is actually /usr/local/etc/webmin/mysql/config

Thanks I found the location, do I still add the same 2 commands you listed below in the config file?

never mind I think I got it, I'll reply if I still have trouble thanks Jamie!

Yes, please add those lines.

Hi Jamie I tried this but its still not working. Just so I'm clear mysql is running but I can't modify mysql within the gui.

Another thing you may want to verify is to look in Webmin -> Servers -> MySQL -> Module Config -> System Configuration, and there, you may want to check that the paths listed there are the correct paths for your system.