1. 连接MYSQL
mysql/bin/mysql -h ip –u 用户名 –p 密码
2. 启动或者关闭MYSQL
./mysql.server start/stop/restart (启动/停止/重启)
3. 退出MYSQL
Exit;
4. 新增用户
Grant select,insert,update,delete on *.* to test1@"%" Identified by "abc";
5. 删除用户
revoke select,insert,update,delete om *.* from test2@localhost ;
6. 创建一个管理员用户
./mysqladmin –u root password 123456
7. 显示数据库
Show databases;
8. 使用某个数据库
Use databasename;
9. 显示数据库中的表
Show tables;
10. 查询一张表数据
Select * from table;
11. 清空表中数据。
Delete from table;
12. 创建数据库
Create database dbname;
13. 删除数据库
Drop database dbname;
14. 备份数据库
Mysql/bin/mysqldump –u root –p databasename > /home/mysql/dump/databasename.sql
15. 导入备份的数据库
Mysql/bin/mysql –u root –p databasename < /home/mysql/dump/databasename.sql
16. 查看mysql状态
Show status;
17. 查看进程
Show processlist;
18. 常用增、删、改,查语句
Insert into table (‘username’) values (‘test’);
Delete from table where id = 1;
Update table set username = ‘1111’ where id = 1;
Select * from table where id = 1;
19. 安装MYSQL
l 常用软件包安装:
yum install gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel*
l 安装
tar xzvf mysql-5.1.39.tar.gz
cd mysql-5.1.39
./configure --prefix=/usr/local/web/mysql.5.1.39 --enable-thread-safe-client --enable-assembler --with-big-tables --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=complex
make
make install
l Mysql用户组
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
./scripts/mysql_install_db --user=mysql --datadir=/usr/local/web/mysql.5.1.39/var
chown -R root /usr/local/web/mysql.5.1.39
chown -R mysql:mysql /usr/local/web/mysql.5.1.39/var
l 启动MYSQL
重启mysql:/usr/local/web/mysql.5.1.39/share/mysql/mysql.server restart
关闭mysql:/ usr/local/web/mysql.5.1.39/share/mysql/mysql.server stop