Tags

, , ,

Login into Mysql

mysql

Command : mysql -h localhost -u root -D dbname -p

Create File for recording our activity

tee

Command : tee record.log

Grant Our User to able to access from network

 tee

Command :  GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’;FLUSH PRIVILEGES;

*.* : semua database.semua table
root @’%’ :root @ semua ip

Checking Running Query in our Server

tee

Command : mysqladmin -u root -i 1 processlist

Killing process By Using Command : mysqladmin -u root kill 29

Kil

Advertisements