Answers for "sql query to check if mysql db is running properly"

how to check if mysql server is running

- Linux, choose:
sudo service mysql status
mysqladmin -u root -p status
/etc/init.d/mysql status

-- Windows, choose:
C:> "C:Program FilesMySQLMySQL Server 5.7binmysqlshow"
C:> "C:Program FilesMySQLMySQL Server 5.7binmysqlshow" -u root mysql
C:> "C:Program FilesMySQLMySQL Server 5.7binmysqladmin" version status proc
C:> "C:Program FilesMySQLMySQL Server 5.7binmysql" test

Posted by: Guest on April-21-2021

check if mysql db is used

SELECT UNIX_TIMESTAMP(MAX(UPDATE_TIME)) as last_update FROM information_schema.tables WHERE TABLE_SCHEMA='replace-with-database-name' GROUP BY TABLE_SCHEMA;

Posted by: Guest on January-28-2021

Code answers related to "sql query to check if mysql db is running properly"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql query to check if mysql db is running properly"

Code answers related to "sql query to check if mysql db is running properly"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql query to check if mysql db is running properly"

Code answers related to "sql query to check if mysql db is running properly"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us