In the example below, you can combine process-list, status and version command to get all the output together as shown below. # mysqladmin -u root -ptmppassword process status version +—-+——+———–+—-+———+——+——-+——————+ | Id | User | Host | db | Command | Time | State | Info | +—-+——+———–+—-+———+——+——-+——————+ | 43 | root | localhost | […]
Continue Reading →# mysqladmin -u root -ptmppassword stop-slave Slave stopped # mysqladmin -u root -ptmppassword start-slave mysqladmin: Error starting slave: The server is not configured as slave; fix in config file or with CHANGE MASTER TO
Continue Reading →First identify the hanging MySQL client process using the processlist command. # mysqladmin -u root -ptmppassword processlist +—-+——+———–+—-+———+——+——-+——————+ | Id | User | Host | db | Command | Time | State | Info | +—-+——+———–+—-+———+——+——-+——————+ | 20 | root | localhost | | Sleep | 64 | | | | 24 | root | […]
Continue Reading →# mysqladmin -u root -ptmppassword flush-hosts # mysqladmin -u root -ptmppassword flush-logs # mysqladmin -u root -ptmppassword flush-privileges # mysqladmin -u root -ptmppassword flush-status # mysqladmin -u root -ptmppassword flush-tables # mysqladmin -u root -ptmppassword flush-threads flush-hosts: Flush all information in the host cache. flush-privileges: Reload the grant tables (same as reload). flush-status: Clear status […]
Continue Reading →# 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 →