linux离线安装mysql8
一、下载或上传安装包到Linux
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.17-linux-glibc2.12-x86_64.tar.xz
1、传路径:/usr/local/
2、解压缩
tar xvf mysql-8.0.17-linux-glibc2.12-x86_64.tar.xz
3、重命名
mv mysql-8.0.17-linux-glibc2.12-x86_64 mysql
二、安装配置
1、修改 vi /etc/my.cnf
[client]
port=3306
socket=/var/lib/mysql/mysql.sock
[mysqld]
port=3306
user=mysql
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
default_authentication_plugin=mysql_native_password
2、创建mysql组与用户
groupadd mysql
useradd -g mysql mysql
3、初始化mysql
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
初始化日志打印出初始密码要记下来【root@localhost: 跟着的是初始密码。记下,后面用到 】
4、创建sock文件夹与命令链接
mkdir -p /var/lib/mysql ; chown -R mysql:mysql /var/lib/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin
5、启动服务
/usr/local/mysql/support-files/mysql.server start
6、修改初始密码
mysql -uroot -p
修改密码 ,我这里的新密码是123456
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
7、开启远程访问
use mysql;
update user set host='%' where user='root';
flush privileges;
exit;
8、配置成服务
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
这样可以通过service mysql start|stop 来启停,否则手工命令启停还是比较麻烦的。
手工启动命令:使用mysqld_safe --defaults-file=/etc/my.cnf
手工停止命令:mysqladmin -u root -p '数据库密码' -S /var/lib/mysql/mysql.sock shutdown
9、如果提示密码过期
./mysql -h localhost -u root -p
然后修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
参考:
Linux离线安装mysql8.0.x mysql8.0.x安装配置_亲测,只为展现最完美的有效!-CSDN博客_linux离线安装mysql
更多推荐


所有评论(0)