mysql实操日志-EW帮帮网

一.下载与解压mysql8 linux版本

1.1下载

mysql-8.0.35：百度网盘请输入提取码

配置文件my.cnf：百度网盘请输入提取码

提取码：8206

1.2默认放到如下目录

mkdir /usr/local/mysql

然后把上面下载的安装包放进去解压

tar -vxf mysql-8.0.35-linux-glibc2.12-x86_64.tar.xz

后删了

rm -f mysql-8.0.35-linux-glibc2.12-x86_64.tar.xz

创建需要目录

mkdir /var/lib/mysql

mkdir -p /usr/local/mysql/log

mkdir /usr/local/mysql/data

chown -R mysql:mysql /usr/local/mysql

chown -R mysql:mysql /var/lib/mysql

1.3修改环境变量

问题：修改环境变量的作用是？

vi ~/.bashrc

export JAVA_HOME=/juege/jdk/openjdk-17.0.9
export PATH=$JAVA_HOME/bin:/usr/local/mysql/mysql8/bin:$PATH

刷新环境变量

source ~/.bashrc

使用命令which mysql 检测环境变量是否配置生效

1.4配置参数文件/etc/my.cnf

内容如下 vi /etc/my.cnf 问题：重要参数有哪些含义是

[mysql]
default-character-set=utf8mb4
socket=/var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql
character-set-server=utf8mb4
default-storage-engine=INNODB
innodb_buffer_pool_size = 200M
max_allowed_packet=16M
explicit_defaults_for_timestamp=1
log-output=FILE
general_log = 0
general_log_file=/usr/local/mysql/log/techlife-general.log
slow_query_log = ON
slow_query_log_file=/usr/local/mysql/log/techlife-slow-query.log
long_query_time=10
log-error=/usr/local/mysql/log/techlife-error.err
default-authentication-plugin=mysql_native_password

1.5初始化

添加用户与用户组

执行如下命令初始化

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

到如下目录看看是否初始化成功然后可以看到初始化的密码

cd /usr/local/mysql/log

tail -100f techlife-error.err 可以看到如下内容有生成一个密码说明初始化成功

1.6配置 Centos Linux 启动和停止脚本

vi /usr/lib/systemd/system/mysqld.service

内容如下

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 65536
LimitNPROC = 6553

1.7配置 systemctl 启动和停止方法

systemctl daemon-reload
systemctl stop mysqld
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld
手要启动和停止 MySQL 方法
nohup /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &
mysqladmin -uroot -p shutdown -S /var/lib/mysql/mysql.sock

1.8允许 root 远程登录

并且密码设置为了root 这里自己设置的话记得改

mysql -u root -p
use mysql;
select host,user from user where user='root';
create USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
grant all privileges on *.* to 'root'@'%' with grant option;
exit;

使用如下方式测试root账号远程连接
mysql -uroot -p -h192.168.1.52

1.9防火墙关闭

firewall-cmd --state

systemctl stop firewalld.service

systemctl disable firewalld.service

如果是用的云服务器记得开放对应端口

mysql实操日志