mysql部署

Mysql部署
通用安装包mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz

卸载自带的mariadb

rpm -qa|grep mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

MySQL数据库安装 具体安装步骤

cd /usr/share/dev   #上传安装程序
tar -zxvf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
mv mysql_5.7 mysql
groupadd mysql
useradd -r -g mysql -s /bin/false mysql 
cd mysql
mkdir /data/mysqldata
chown -R mysql:mysql /data/mysqldata 
chmod 750 /data/mysqldata
mkdir /data/mysqllogs
chown -R mysql:mysql /data/mysqllogs 
echo "" > /data/mysqllogs/mysql.log
chown -R mysql:mysql /data/mysqllogs/mysql.log
chown -R mysql .
chgrp -R mysql .
(根据my.cnf创建相应文件并修改用户组)

配置my.cnf

touch /etc/my.cnf
[mysqld]
basedir=/usr/share/dev/mysql
datadir=/data/mysqldata
socket=/data/mysqldata/mysql.sock 
port=3306
character_set_server=utf8
user=mysql
symbolic-links=0  # Disabling symbolic-links is recommended to prevent assorted security risks
log_timestamps = SYSTEM
[client]　　　　　　　　　　　　　　
port = 3306
socket = /data/mysqldata/mysql.sock
default-character-set = utf8
[mysqld_safe]
log-error=/data/mysqllogs/mysql.log    #log可以写在mysql新建的文件夹中,记得给mysql.log赋权限
pid-file=/data/mysqldata/mysql.pid

安装

./bin/mysqld --initialize --user=mysql --basedir=/usr/share/dev/mysql --datadir=/data/mysqldata &
./bin/mysql_ssl_rsa_setup
./bin/mysqld_safe --user=mysql &
ps -ef|grep mysql

更改密码

./bin/mysql -u root -p -h 127.0.0.1
set password for 'root'@'localhost' =password('123456');
（./bin/mysqladmin -uroot -p password
输入临时密码以及新密码）

mysql设为服务

cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld   
chkconfig --add mysqld   
chkconfig --list mysqld   
service mysqld start和service mysqld 

配置远程登录

./bin/mysql -u root -p  
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

配置环境变量

vi /etc/profile   #最后添加以下2行
PATH=/usr/share/dev/mysql/bin:/usr/share/dev/mysql/lib:$PATH
export PATH
source /etc/profile   #立即生效