Using mysqli_connect to check if an MySQL is running without credentials?

Question

I need to check if MySQL is running in a PHP script, so I thought about using mysqli_connect

The only problem is, I don't want it to require MySQL login details. Is it possible to log in without an account? If I log in with no password, or a made up username and password, does the "access denied" prove that MySQL is running?

Is there a better way to do this? If not, what MySQL permissions can I give to an account so I can log in but can't do anything?

Have you tried making a username/password combo and revoking all privileges? — MonkeyZeus
– MonkeyZeus, Commented Jan 22, 2014 at 20:32

xate · Accepted Answer · 2014-01-22 20:32:13Z

1

You will receive a "DB Exception" when you address a database, which is not existing, deactivated or whatever.

Access Denied provides, that MySQL is running - checked your username and password and gave a response.

Access Denied = Database up - you are right!

answered Jan 22, 2014 at 20:32

xate

6,3723 gold badges20 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Digital Chris · Accepted Answer · 2014-01-22 20:40:50Z

0

I think what you're looking for is

mysqladmin ping

Check whether the server is available. The return status from mysqladmin is 0 if the server is running, 1 if it is not. This is 0 even in case of an error such as Access denied, because this means that the server is running but refused the connection, which is different from the server not running.

You can run this from php, or direcly in a cron job and test for 0.

answered Jan 22, 2014 at 20:40

Digital Chris

6,1771 gold badge22 silver badges29 bronze badges

Collectives™ on Stack Overflow

Using mysqli_connect to check if an MySQL is running without credentials?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related