centos7安装mysql5.6.35_CentOs7.2 源码安装mysql-5.6.35过程

1.依赖包安装:

yum -y install gcc gcc-c++ cmake ncurses-devel autoconf perl perl-devel

2.创建mysql安装目录以及数据存放目录

mkdir -p /usr/local/mysql/data

3.创建用户、用户组

groupadd mysql

useradd -r -g mysql mysql

4.开始安装

tar -zxvf mysql-5.6.35.tar.gz

# cd mysql-5.6.35

# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DINSTALL_DATADIR=/usr/local/mysql/data \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DEXTRA_CHARSETS=all \

-DENABLED_LOCAL_INFILE=1

# make && make install

注意事项：

如安装失败重新编译时，需要清除旧的对象文件和缓存信息。

# make clean

# rm -f CMakeCache.txt

# rm -rf /etc/my.cnf

设置目录权限

# cd /usr/local/mysql

# chown -R mysql:mysql .

# chown -R mysql:mysql data

5.将mysql的启动服务添加到系统服务中

# cd /usr/local/mysql

# cp support-files/my-default.cnf /etc/my.cnf

6.创建基础表：

# cd /usr/local/mysql

# ./scripts/mysql_install_db --user=mysql

7.配置环境变量

# vi /etc/profile

在最下面添加下面两个值

export MYSQL_HOME="/usr/local/mysql"

export PATH="$PATH:$MYSQL_HOME/bin"

让修改的profile文件立即生效

# source /etc/profile

cd /usr/local/mysql/

# cp support-files/mysql.server /etc/init.d/mysql

service mysql start

回车在接下来的提示中设置新密码即可

# mysqladmin -u root password

New password:

Confirm new password:

连接到mysql

# mysql -u root -p

为root添加远程连接的能力

mysql>use mysql;

mysql>desc user;

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";

mysql>update user set Password = password('xxxxxx') where User='root';

mysql>select Host,User,Password from user where User='root';

mysql>flush privileges; //刷新权限

8.忘记root密码后，如何更改密码

停止mysql服务，或者命令systemctl stop mysql

[root@bogon /]# service mysql stop

进入/usr/local/mysql

# cd /usr/local/mysql/

通过mysqld_safe启动mysql，并且启动mysql时不启动grant-tables授权表

[root@bogon mysql]# ./bin/mysqld_safe --basedir=/usr/local/mysql \

--datadir=/usr/local/mysql/data \

--skip-grant-tables &

登陆mysql

# mysql -u root mysql

修改root密码

mysql>UPDATE user SET password=PASSWORD("new_password") WHERE user='root';

刷新权限