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 #立即生效