mysql安装部署_mysql安装部署

mysql安装部署

方式一：Yum安装MySQLwget 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

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