# mysqladmin -u root -ptmppassword shutdown # mysql -u root -ptmppassword ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ Note: You can also use “/etc/rc.d/init.d/mysqld stop” to shutdown the server. To start the server, execute “/etc/rc.d/init.d/mysql start”
Continue Reading →Use mysqladmin reload or mysqladmin refresh command to reload/refresh the privilege or the granst tables. # mysqladmin -u root -ptmppassword reload; Refresh command will flush all the tables and close/open log files. # mysqladmin -u root -ptmppassword refresh
Continue Reading →Use mysqladmin drop command to drom mysql database. # mysqladmin -u root -ptmppassword drop testdb Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed. Do you really want to drop the ‘testdb’ database [y/N] y Database “testdb” dropped # mysql -u root -ptmppassword Welcome […]
Continue Reading →You can use mysqladmin create command to create a mysql database. # mysqladmin -u root -ptmppassword create mydb # mysql -u root -ptmppassword Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 705 Server version: 5.1.25-rc-community MySQL Community Server (GPL) Type ‘help;’ or ‘\h’ for help. Type ‘\c’ […]
Continue Reading →You can use mysqladmin processlist for get process list. mysqladmin -u root -p processlist Enter password: +—-+——+———–+——————-+———+——+——-+——————+ | Id | User | Host | db | Command | Time | State | Info | +—-+——+———–+——————-+———+——+——-+——————+ | 75 | root | localhost | prodtheloopwebapp | Sleep | 945 | | | | 77 | root | […]
Continue Reading →You can get mysql server system variables using mysqladmin variables command mysqladmin -u root -p variables Enter password: +—————————————————+————————————————————————————————————————+ | Variable_name | Value | +—————————————————+————————————————————————————————————————+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | autocommit | ON | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | /Applications/MAMP/Library | | […]
Continue Reading →Use mysqladmin extended-status command to view all the mysql server status variable and it’s current value. mysqladmin -u root -ptestpassword extended-status +——————————————+————-+ | Variable_name | Value | +——————————————+————-+ | Aborted_clients | 0 | | Aborted_connects | 1 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use […]
Continue Reading →To find current status of mysql you can use mysqladmin status with username and password. # mysqladmin -u root -ptestpassword status Uptime: 93516 Threads: 2 Questions: 49 Slow queries: 0 Opens: 54 Flush tables: 1 Open tables: 47 Queries per second avg: 0.0 The status command displays the following information: Uptime: Uptime of the mysql […]
Continue Reading →Apart from giving the ‘Server version’, this command also displays the current status of the mysql server. mysqladmin -u root -p version Enter password: /Applications/MAMP/Library/bin/mysqladmin Ver 8.42 Distrib 5.5.9, for osx10.6 on i386 Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. […]
Continue Reading →You can use mysqladmin ping for this. Type following command on your terminal and give your password. It will show you the status of mysql server. # mysqladmin -u root -p ping Enter password: mysqld is alive
Continue Reading →