centos 6 x64 mysql_CentOS6.5X64安装MySql5.1.73

groupadd -r mysql                                                      #添加mysql用户组

useradd -g mysql -r mysql                                          #添加mysql用户

mkdir -p /usr/local/mysql/                                            #添加mysql的安装目录

mkdir -p /usr/local/mysql/data/                                    #添加mysql的数据库目录

mkdir -p /usr/local/mysql/etc/                                      #添加mysql的配置文件存放路径

#配置

./configure --prefix=/usr/local/mysql/ --localstatedir=/usr/local/mysql/data/ --sysconfdir=/usr/local/mysql/etc/ --with-charset=utf8

make                                                                          #编译

make install                                                                #安装

cd /usr/local/mysql/                                                    #进入mysql的安装目录

chown -R mysql .                                                       #给mysql用户对这个目录有权限

chgrp -R mysql .                                                         #给mysql组对这个目录有权限

#安装默认数据

/usr/local/mysql/bin/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data

#复制mysql的启动文件

cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysqld

#复制mysql的配置文件

cp /usr/local/mysql/share/mysql/my-large.cnf /usr/local/mysql/etc/my.cnf

chmod +x /etc/init.d/mysqld           #给mysql执行权限

chkconfig --add mysqld                 #把mysql注册为服务

chkconfig --level 345 mysqld on    #让mysql自启动

service mysqld start                       #启动mysql

如果初次启动出现Starting MySQL.Manager of pid-file quit without updating fi[FAILED]的报错，需要注释/etc/my.cnf里的skip-federated注释掉即#skip-federated就OK了

/usr/local/mysql/bin/mysqladmin -u root password '123456'  #设置密码