MYSQL惯用经典命令

MYSQL常用经典命令

1.停止mysql

kill -9 `ps -ef | grep mysqld_safe| grep -v grep| awk ‘{print $2}’`

kill -9 `ps -ef | grep ‘mysqld’ | grep -v grep| awk ‘{print $2}’`

2.启动mysql

cd /usr/local/mysql-5.4.1-beta-linux-x86_64-glibc23

/bin/sh bin/mysqld_safe –user=mysql &

3.启动apache

cd /usr/local/apache-tomcat-5.5.27/bin

./startup.sh

停止apache

cd /usr/local/apache-tomcat-5.5.27/bin

./shutdown.sh

4.给指定IP增加访问权限。

Use mysql

Select * from user

| Host | User | Password   | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | ssl_type | ssl_cipher      | x509_issuer     | x509_subject    | max_questions | max_updates | max_connections | max_user_connections |

‘10.137.6.44’, ‘mysql’, ‘*E74858DB86EBA20BC33D0AECAE8A8108C56B17FA’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ”, ‘BINARY, 0 Bytes’, ‘BINARY, 0 Bytes’, ‘BINARY, 0 Bytes’, 0, 0, 0, 0

insert into user values (‘10.137.6.44’, ‘mysql’, ‘*E74858DB86EBA20BC33D0AECAE8A8108C56B17FA’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ‘Y’, ”, ‘BINARY, 0 Bytes’, ‘BINARY, 0 Bytes’, ‘BINARY, 0 Bytes’, 0, 0, 0, 0);

5.导出数据

mysqldump -u mysql –password=mysql –default-character-set=gbk webdb > webdb.sql

6.导入数据

mysql -u mysql –password=mysql –default-character-set=gbk webdb < mcip_2011-09-01.sql