1:mysql下载
官网的下载地址:https://downloads.mysql.com/archives/community/
安装mysql
1:解压mysql压缩包
# tar -xvf mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz
2:将解压之后的文件移动到/usr/local中
mv mysql8.0.26 /usr/local/mysql
3:进入到/usr/local目录下,创建用户和用户组并授权
cd /usr/local/
groupadd mysql
useradd -r -g mysql mysql
cd mysql/ #注意:进入mysql文件下授权所有的文件
chown -R mysql:mysql ./
passwd mysql #修改mysql用户密码
4:初始化数据库
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
5:修改/usr/local/mysql当前目录得用户
chown -R root:root ./
chown -R mysql:mysql data
6:cp support-files/my-default.cnf /etc/my.cnf
cd support-files/
touch my-default.cnf
chmod 777 ./my-default.cnf
cd ../
cp support-files/my-default.cnf /etc/my.cnf
7:配置my.conf
8:开机自启,进入/usr/local/mysql/support-files进行设置
cd support-files/
cp mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
9:注册服务
chkconfig --add mysql
10:查看是否注册成功
chkconfig --list mysql
11:etc/ld.so.conf要配置路径
vim /etc/ld.so.conf
添加如下内容:
/usr/local/mysql/lib
12: 配置环境变量
vim /etc/profile
source /etc/profile
添加如下内容:
#MYSQL ENVIRONMENT
export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib
13:服务启动 停止 重启
service mysql start
service mysql stop
service mysql restart
14:进入mysql修改密码
mysql -u root -p
alter user 'root'@'localhost' identified by '密码';
flush privileges;#立即生效