Detailed explanation of common MySQL operation commands in Linux terminal

# chkconfig --list List all system services # chkconfig --list | grep on List all started system services # chkconfig --list mysqld 
# whereis mysql View the file installation path # which mysql Query the path where the running file is located (folder address)
usr/bin/mysql refers to: the running path of mysql var/lib/mysql refers to: the storage path of mysql database files usr/lib/mysql refers to: the installation path of mysql

# vi /etc/profile
# export MYSQL_HOME=/usr/local/mysql
# export PATH=$PATH:$MYSQL_HOME/bin

# service mysqld start Start MySQL
# service mysqld restart Restart MySQL
# service mysqld stop

# -u root -p /mysql -h localhost -u root -p DatabaseName; Enter MySQL
 MySQL> show databases; List databasesMySQL> create database XXX; Create database XXX
 MySQL> use databaseName; Use database databaseName
 MySQL> show tables; List tablesMySQL> create table mytablename (ID int auto_increment not null primary key,usename varchar(20),password varchar(64),sex varchar(10),address varchar(20)); Create tableMySQL> drop table mytablename; Delete tableMySQL> drop database databasename; Delete database

MySQL> insert into mytablename values('','zhangsan','123456','fomale','guiyanag'); InsertMySQL> select * from mytablename; Find verification resultsMySQL> select * from mytablename where ID = '1'; Accurate searchMySQL> update mytablename set address = 'shanghai' where username = 'zhangsan'; Change zhangsan's address to shanghai
MySQL> delete from mytablename where ID = '1'; Delete records

grant select On database.* to username@localhost identity by 'password'

MySQL> grant select,insert update,delete on *.* to user_1@"%" identity by "123456";

MySQL> grant select,insert update,delete on *.* to user_2@localhost identity by "123456";

MySQL> -u user_1 -p -h IP address;