mysql安装部署

mysql安装部署

方式一：Yum安装MySQL

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

rpm -ivh mysql57-community-release-el7-11.noarch.rpm

yum makecache

yum -y install mysql-community-server.x86_64

systemctl start mysqld

systemctl enable mysqld

获取初始化密码

grep 'password' /var/log/mysqld.log

登录

mysql -uroot -p'xxxxxxxx'

方式二：Generic安装MySQL

下载地址：https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.22-linux-glibc2.12-x86_64.tar.xz

groupadd mysql

useradd -r -g mysql -s /bin/false mysql

usr/local/        tar -xvf mysql-8.0.22-linux-glibc2.12-x86_64.tar.xz

usr/local/       ln -s mysql-8.0.22-linux-glibc2.12-x86_64 mysql

usr/local/mysql/       mkdir mysql-files

usr/local/mysql/       chown -R mysql.mysql . 

usr/local/mysql/      bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

简历MySQL配置文件my.cnf
cp /etc/my.cnf /etc/my.cnf.bak

              内容

                [mysqld]

                basedir=/usr/local/mysql

                datadir=/usr/local/mysql/data

启动MySQL

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

chmod a+x /etc/init.d/mysqld

chkconfig --add /etc/init.d/mysqld

chkconfig mysqld on

service mysqld start

echo "export PATH=$PATH:/usr/local/mysql/bin">> /etc/profile

source /etc/profile

登录修改密码

方式三：Source Code安装MySQL