Skip to main content

mysqladmin command and mysqlshow command usage and examples 

mysqladmin command

1)Change MySQL root password 

mysqladmin -u root -ptmppassword password 'newpassword'

2) Check MySQL server is up or not 

mysqladmin -u root -p ping

3) Find MySQL server version 

mysqladmin -u root -ptmppassword version

4) Show the current MySQL servers status

mysqladmin -u root -ptmppassword status

5) Find the values of status variables

mysqladmin -u root -ptmppassword extended-status

6) Find the values of MySQL system variables 

mysqladmin  -u root -ptmppassword variables

7) Show all the running process/queries in MySQL databases 

mysqladmin -u root -ptmppassword processlist

8) Create MySQL database 
mysqladmin -u root -ptmppassword create testdb

9) Delete database 

mysqladmin -u root -ptmppassword drop testdb

10) Shutdown the MySQL server 

mysqladmin -u root -ptmppassword shutdown

11) Kill MySQL client process

mysqladmin -u root -ptmppassword kill 20

(20 is the process id with the process list) 

mysqlshow command

1) Show all the databases 

mysqlshow  -u root -ptmppassword

2) Show the tables on a database 

mysqlshow -v -v -u root -ptmppassword mydb_name

Comments

Post a Comment

Popular posts from this blog

WiFI connection

    root@kali:~# iw dev root@kali:~# ip link set wlan0 up root@kali:~# iw wlan0 scan root@kali:~# wpa_passphrase blackMOREOps >> /etc/wpa_supplicant.conf root@kali:~# wpa_supplicant -i wlan0 -c /etc/wpa_supplicant.conf root@kali:~# iw wlan0 link root@kali:~# dhclient wlan0 root@kali:~# ping 8.8.8.8 (Where wlan0 is wifi adapter and blackMOREOps is SSID) (Add Routing manually) root@kali:~# ip route add default via 10.0.0.138 dev wlan0    
Post a Comment
Read more

Modsecurity block rule for XMLRPC and wp-login attack

SecAction phase:1,nolog,pass,initcol:ip=%{REMOTE_ADDR},initcol:user=%{REMOTE_ADDR},id:5000134  <Locationmatch "/wp-login.php">  SecRule user:bf_block "@gt 0" "deny,status:401,log,id:5000135,msg:'ip address blocked for 5 minutes, more than 10 login attempts in 3 minutes.'"  SecRule RESPONSE_STATUS "^302" "phase:5,t:none,nolog,pass,setvar:ip.bf_counter=0,id:5000136"  SecRule RESPONSE_STATUS "^200" "phase:5,chain,t:none,nolog,pass,setvar:ip.bf_counter=+1,deprecatevar:ip.bf_counter=1/180,id:5000137"  SecRule ip:bf_counter "@gt 10" "t:none,setvar:user.bf_block=1,expirevar:user.bf_block=300,setvar:ip.bf_counter=0"  </Locationmatch>  SecAction phase:1,nolog,pass,initcol:ip=%{REMOTE_ADDR},initcol:user=%{REMOTE_ADDR},id:5000234  <Locationmatch "/xmlrpc.php">  SecRule user:bf_block "@gt 0" "deny,status:401,log,id:5000235,msg:'ip address blocked for 5 m...
Post a Comment
Read more

Apache tuning documentation

Apache bench marking ======================= Things or checklist to be considered before the test     CPU: avoid power-saving mode. cpufreq-set -g performance.     File descriptors: raise the limit to (at least) the number of concurrent connections you wish to handle, using ulimit -n in your shell, or setrlimit(RLIMIT_NOFILE) in your server. Beware, some systems forbid you to raise the limit, you might need to investigate a bit to find how to unlock it.     Disable the logs of your server (you do not want to lose time logging thousands of requests instead of answering them).     Raise /proc/sys/net/somaxconn to the number of concurrent connections you want to handle. To understand why this is necessary, read the technical report or the excellent paper Measuring the Capacity of a Web Server (Banga and Druschel, Usenix 97). More on the fascinating topic of the accept() queue can be found in accept()able Strategies for Im...
Post a Comment
Read more