CentOS安装mysql

1、安装wget

yum search wget //查看是否有wget版本
yum install -y wget.x86_64

2、删除系统自带的mysql
查看是否有mysql

rpm -qa | grep mysql

存在则删除

rpm -e --nodeps mysql-libs

3、创建数据库目录、mysql用户。并修改数据

mkdir -pv /mydata/data
useradd -s /sbin/nologin mysql
chown -R mysql.mysql /mydata/data/

4、安装编译源码所需的工具和库

yum install -y gcc gcc-c++ ncurses-devel perl
yum groupinstall -y "Development tools" "Desktop Platform Development" "Server Platform Development"
yum -y install cmake
yum -y install openssl openssl-devel ncurses ncurses-devel

5、下载tar 包解压

wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.37.tar.gz
tar -zxvf mysql-5.6.37.tar.gz -C /usr/local/

6、设置编译参数，编译安装

cd /usr/local/mysql-5.6.37
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mydata/data/ -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
make
make install

若出现以下情况：

rm  -rf CMakeCache.txt
rm -rf /etc/my.cnf
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DINSTALL_DATADIR=/mydata/data \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=all \
make
make install

7初始化数据库

cd /usr/local/mysql/scripts/
./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/mydata/data/

若出现此问题:

解决办法：
解决方法：安装autoconf库

命令：yum-y install autoconf

8、复制mysql服务启动脚本

cd /usr/local/mysql/support-files/
cp mysql.server /etc/init.d/mysqld
chmod a+x /etc/init.d/mysqld

9、设置mysql开机启动

//添加MySQL到开机自启动服务
chkconfig --add mysqld 
chcconfig --list mysqld

10、配置MySQL环境变量

cd ~
vi /etc/profile
//按a|i键在/etc/profile文件末尾添加如下两行
export PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
//添加完成后退出编辑，执行如下命令使配置生效
source /etc/profile

11、复制MySQL配置文件

 cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
vi /etc/my.cnf
//在my.cnf文件中增加如下配置，添加到[mysqld]之后
innodb_file_per_table = 1
datadir = /mydata/data
port = 3306
user = mysql
server_id = 1
socket = /tmp/mysql.sock

12、启动mysql服务

service mysqld start
//执行如下命令查看MySQL服务是否正常运行，显示is running...表示正在运行
 service mysqld status

14、连接数据库

//进入数据库
 mysql -uroot -p
mysql>use mysql;
mysql> update user set password=password('123456') where user='root';
mysql>flush privileges;
mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
mysql>flush privileges;

15、关闭防火墙，连接数据库