MysqlServer Status & Control on MacOSX

Hello all,

Is there any way of checking the status of the mysql server on mac from xojo ? i need to use server status , server start and server stop .

So far i tried with shell but not to much progress and so far i have to run something like

[code] dim sh As New Shell

sh.Execute “osascript -e 'do shell script “” sudo /usr/local/mysql/support-files/mysql.server status”" with administrator privileges '"
[/code]

and all the time the user has to input the password,

I was looking for something like one time password input and the rest the app does the job.

Thanks in advance.

Why not try to .Connect to it?

Hello,

Well because the app has to be able to control the server, start , stop, status install, uninstall

and it seems that this is the only way to doit .

A shell running the various mysqld commands is probably what you need

https://dev.mysql.com/doc/refman/5.5/en/automatic-start.html