mysql 安装(简易步骤)

1、
下载

设置变量:

export PATH=$PATH:/usr/local/mysql8/bin
2、
创建用户

groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /data/software/mysql8/datas
chmod -R 750 /data/software/mysql8/datas

3、

建立最小配置文件

[mysqld]
port  = 3306
basedir = /usr/local/mysql8
datadir = /usr/local/mysql8/data
socket  = /tmp/mysqld.sock
log-error = /usr/local/mysql8/data/error.log
pid-file = /usr/local/mysql8/data/mysqld.pid
[client]
port  = 3306
socket  = /tmp/mysqld.sock

------------初始化--------------
mysqld --basedir=/usr/local/mysql8/ --datadir=/usr/local/mysql8/datas/mysql --user=mysql --initialize
随机默认密码

------------初始化 密码为空的方式--------------
mysqld --defaults-file=/usr/local/mysql8/my.cnf --basedir=/usr/local/mysql8/ --datadir=/usr/local/mysql8/datas/mysql --user=mysql --initialize-insecure

4、

启动
mysqld_safe --defaults-file=/data/software/mysql8/my.cnf &
5、登录
mysql -u root --skip-password
6、修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;

7、修改远程登录

update user set user.Host='%'where user.User='root';
flush privileges;
posted @ 2022-08-06 16:26  donghongchao  阅读(116)  评论(0编辑  收藏  举报