一. 环境准备
查看当前系统版本
lsb_release –a
apt-get update
apt-get upgrade
apt-get install rpm
二.mysql安装
下载
下载地址:MySQL :: Download MySQL Community Server (Archived Versions)
解压安装包
tar xzvf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
移动并修改文件名
mv mysql-5.7.27-linux-glibc2.12-x86_64 /usr/local/mysql
创建数据库目录
mkdir /usr/local/mysql/data
新建mysql用户、组及目录
groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql
创建相关文件
mkdir tmp
cd tmp
touch mysqld.pid
chmod 755 mysqld.pid
mkdir log
touch mysqld.log
chmod 755 mysqld.log
改变目录拥有者
chgrp -R mysql /usr/local/mysql
chown -R mysql /usr/local/mysql
初始化mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
可能会报错。报错信息
bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
解决办法:
rpm -qa|grep libaio
运行该命令后发现系统中无该链接库文件
使用命令,apt-get install libaio1
配置SSL参数(在mysql目录下)
bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data/
创建my.cnf
touch /etc/my.cnf
my.cnf中添加
[mysqld] character_set_server=utf8 init_connect='SET NAMES utf8' basedir=/usr/local/mysql datadir=/usr/local/mysql/data port = 3306 log-error=/usr/local/mysql/log/mysqld.log pid-file=/usr/local/mysql/tmp/mysqld.pid #表名不区分大小写 lower_case_table_names = 1 max_connections=5000 |
启动mysql
cp support-files/mysql.server /etc/init.d/mysql
编辑/etc/init.d/mysql文件
systemctl enable mysql.service
启动mysql
service mysql start
service mysql status
环境变量配置
vi /etc/profile
添加export PATH=/usr/local/mysql/bin:$PATH
source /etc/profile
echo $PATH
登陆并修改密码
mysql -uroot –p
输入安装时生成的默认密码
登录后必须先重置密码
set password = password('tykjtykj');
新建账号
create user tykj identified by 'tykjtykj';
grant ALL on *.* to tykj;
grant REPLICATION CLIENT on *.* to tykj;
三、启动错误
- service mysql start
Failed to start mysql.service: Unit mysql.service is masked.
解决办法:systemctl unmask mysql.service
service mysql start