linux 下安装 myslq 8
一、下载
可以自己去官网下载 MySQL :: Download MySQL Community Server (Archived Versions)
链接:https://pan.baidu.com/s/1QzQTS-gKOYoOdQ14oGFpww
提取码:4by6
二、安装
把下载的安装包上传到Linux系统。
解压文件
将压缩包解压到/usr/local/目录下,并改名mysql
cd /usr/local/
tar -xvf /home/chenyb/software/mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.15-linux-glibc2.12-x86_64/ ./mysql
配置my.cnf文件,默认mysql会执行/etc/my.cnf这个配置文件
vi /etc/my.cnf
创建数据存放目录
mkdir /usr/local/mysql/data -p
[client]
port=3306
socket=/tmp/mysql/mysql.sock
[mysqld]
port=3306
user=mysql
socket=/tmp/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=error.log
transaction_isolation = READ-COMMITTED
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1
#开启可以跳过认证,免密登录
skip-grant-tables
创建用户并授权
mkdir /tmp/mysql -p
useradd mysql
chown -R mysql:mysql /tmp/mysql
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /tmp/mysql /usr/local/mysql
初始化
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
启用mysql命令
ln -s /usr/local/mysql/bin/mysql /usr/bin
清空密码
启动mysql
/usr/local/mysql/support-files/mysql.server start
登录mysql,密码直接回车就好
mysql -uroot -p
清空密码
use mysql;
update user set authentication_string='' where user='root';
设置密码
注释掉/etc/my.cnf中的#skip-grant-tables,不跳过认证
重启mysql服务
/usr/local/mysql/support-files/mysql.server stop
/usr/local/mysql/support-files/mysql.server start
登录mysql,密码已经被清理,直接回车就好
样例中密码是root
ALTER user 'root'@'localhost' IDENTIFIED BY 'root';
开机自启
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chmod 755 /etc/init.d/mysql
cd /etc/init.d
chkconfig --add mysql
chkconfig --level 345 mysql on
允许远程连接
在mysql配置文件中加入配置(/etc/my.cnf),设置密码加密方式
default_authentication_plugin=mysql_native_password
进入mysql设置root用户远程访问权限和密码加密方式
use mysql;
update user set host ='%' where user='root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;