Centos 源码安装 MySQL

系统环境：Centos6.5

1、下载源码包

[monster@localhost download]$ wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.49-linux2.6-x86_64.tar.gz

解压到 /usr/local/ 目录下

[monster@localhost download]$ cd /usr/local/
[monster@localhost local]$ sudo tar -xf /opt/download/mysql-5.5.49-linux2.6-x86_64.tar.gz

为了方便后续操作，为该目录建立符号链接

[monster@localhost local]$ sudo ln -s mysql-5.5.49-linux2.6-x86_64/    mysql 

2、检查是否安装了相应的软件包

[monster@localhost local]$ sudo rpm -qa | grep -i mysql

如果已安装了相应的xxxxx，为了防止安装时覆盖错误，先卸载xxxxx，注意加--nodeps选项，忽略依赖项

[monster@localhost local]$ sudo rpm -e xxxxx --nodeps

/usr/local/mysql目录结构

3、添加mysql组和mysql用户，用于设置mysql安装目录文件的所有者和所属组

[monster@localhost local]$ sudo groupadd mysql

[monster@localhost local]$ sudo useradd -r -g mysql

4、更改mysql目录所属组和用户

[monster@localhost local]$ cd mysql

[monster@localhost mysql]$ sudo chown -R mysql:mysql .

5、初始化数据库

[monster@localhost mysql]$ sudo scripts/mysql_install_db --user=mysql

6、拷贝配置文件

[monster@localhost mysql]$ sudo cp support-files/my-medium.cnf /etc/my.cnf

7、将mysqld服务加入开机自启

[monster@localhost mysql]$ sudo cp support-files/mysql.server /etc/init.d/mysqld 

[monster@localhost mysql]$ sudo chkconfig --add mysqld

8、启动mysqld服务

[monster@localhost mysql]$ sudo service mysqld start

9、设置数据库root密码，登录mysql

[monster@localhost mysql]$ sudo bin/mysqladmin -u root password 'password'

[monster@localhost mysql]$ bin/mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.49-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye