Linux Common commands

View Linux Current Ip:ifconfig-a
Open Terminal ctrl+alt+t
Show hidden Files Ctrl +h
Show Desktop Ctrl+win+d
Close the current window Alt+f4
Capture fullscreen Print Screen
Intercept window Alt + Print screen

Ps-ef|grep mysqld//view MySQL process, bin
sudo service xx stop/start/restart services on, off, restart
Query the path where the running file is located (folder address)
which MySQL
To view the file installation path
Whereis MySQL

Ps-a|grep MySQL view MySQL process number
Kill-9 8037 (8037 for MySQL process number)

Linux appears: Starting Mysql.manager of Pid-file quit #解决方案: (2nd, 3 steps) http://blog.chinaunix.net/uid-21516619-id-1824983.html

Initial installation: MySQL does not have a password set by default.
Use the mysqladmin command to change the root user password.
Mysqladmin-uroot password root #密码设置为: root

MySQL Command input screen:
--Local connection
[[email protected] bin] #mysql-uroot-p
--Remote connection
[[email protected] bin] #mysql-u liuxw-h xxx.xxx.xxx.xxx-p "LIUXW user name, xxx.xxx.xxx.xxx for IP"

(1) http://www.2cto.com/database/201408/328641.html #如果系统有旧mysql, delete command test to be available
(2) http://my.oschina.net/u/1156660/blog/343154 #在无旧mysql的情况下, installation command test is available

Linux Common commands