安装依赖包

yum -y install bison bison-devel zib-devel libcurl-devel libarchive-devel boost-devel gcc gcc-c++  cmake  ncurses  ncurses-devel  dnutls-devel  libxml2-devel  openssl-devel  libevent-devel  libaio-devel

卸载rpm安装的mysql

[root@mail ~]# rpm -e mysql-server-5.0.77-4.el5_4.2 --nodeps

[root@mail ~]# rpm -q mysql mysql-server

创建运行用户，可以不创建宿主文件夹

Useradd -M -s /sbin/nologin mysql  

tar zxf /media/chapter07/mysql-5.1.55.tar.gz

cd /usr/src/mysql-5.1.55/

./configure --prefix=/usr/local/mysql --with-charset=utf8  --with-collation=utf8_general_ci --with-extra-charsets=gbk,gb2312

5.5版本以上使用cmake命令

Cmake .   -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/  -DMYSQL_DATADIR=/usr/local/mysql/mysqldata  -DSYSCONFDIR=/etc/  -DMYSQL_USER=mysql  -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1        -DWITH_MEMORY_STORAGE_ENGINE=1   -DWITH_DEBUG=0        -DWITH_READLINE=1  -DWITH_SSL=system  -DWITH_ZLIB=system  -DWITH_LIBWRAP=0   -DENABLED_LOCAL_INFILE=1     -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock  -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci                  

*如果出错，执行rm -f CMakeCache.txt

make 编译 && make install 安装

mysql-5]#cp support-files/my-medium.cnf  /etc/my.cnf

安装mysql、test和information_schema数据库

cd /usr/local/mysql/bin   

./mysql_install_db --user=mysql  --basedir=  --datadir=

chown -R mysql:mysql /usr/local/mysql

   降低目录权限，增强安全

//ln -s /usr/local/mysql/bin* /usr/local/bin   优化命令执行路径

//ln -s /usr/local/mysql/lib/mysql/* /usr/lib

//ln -s/usr/local/mysql/include/mysql/* /usr/include/

cd /root/mysql-5.1.55/

cp support-files/mysql.server /etc/rc.d/init.d/mysqld  添加服务

/chmod a+x /etc/rc.d/init.d/mysqld

systemctl start mysqld

Systemctl enable mysqld  

chconfig -add mysqld  添加到开机启动  

mysql -u root //

exit

mysqladmin -u root password '123.com' //在命令行中为root用户设置密码

mysql -u root -p123.com

mysql -u root -p student(数据库名)

SHOW MASTER LOGS

执行sql语句时不区分大小写，但必须以；结束。

show databases; 查看数据库列表

use mysql;

select database(); 查看当前数据库

show tables;

create database student; //创建数据库

use student;

create table u1 (id int(10),name char(20),gongzi int(9),QQ int(11),email char(50));

desc u1；//查看表结构

drop 删除表和库

delete 删除记录

drop table u1;

insert into u1(id,name,gongzi,QQ，email)  values (1,'zhangsan',4500,123456,'123@163.com');

select * from u1

select * from u1 where id=3

select name,gongzi from u1;

select distinct name from u1;

select now();

select count(id) from u1;//根据id号统计个数

select gongzi from u1 where gongzi>5000

select avg(gongzi) from u1;

select * from order by gongzi;//(默认为升序)

select * from order by gongzi desc;//降序排列

select * from order by gongzi desc limit 2;

delete from u1 where id=3;

update u1 set QQ=1237890 where id=2;

授权

grant all on student.* to 'a'@'&' identified by '123';

grant all on student.* to 'a'@'localhost' identified by '123456'

mysql错误：No curses/termcap library found

在使用源码安装mysql时，经常遇到错误：No curses/termcap library found

    解决办法：

yum install ncurses-devel

安装mysql-python时，如果报错：

[html] view plaincopy

    pymemcompat.h:10:20: error: Python.h: No such file or directory  

则需要安装：

[html] view plaincopy

    yum install python-devel  

如果出现错误信息：

[html] view plaincopy

    _mysql.c:36:23: error: my_config.h: No such file or directory  

    _mysql.c:38:19: error: mysql.h: No such file or directory  

    _mysql.c:39:26: error: mysqld_error.h: No such file or directory  

    _mysql.c:40:20: error: errmsg.h: No such file or directory  

则需要安装：

[html] view plaincopy

    yum install  mysql-devel  

有时候由于系统环境等问题造成python-devel安装失败，则可以自行下载python-devel的rpm包（下载地址），自行使用rpm命令安装python-devel

[sql] view plaincopy

    rpm -ivh --force --nodeps python-devel-2.4.3-27.el5_5.3.x86_64.rpm