部署

0.conn.ym-ubu24.5.mysql

1.安装

sudo apt update
sudo apt install mysql-server -y
sudo systemctl enable mysql

2.配置

1. sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf #服务器配置

   [mysqld]
   #base
   user      = mysql
   pid-file  = /data/svr/mysql/mysqld.pid
   socket    = /data/svr/mysql/mysqld.sock
   datadir   = /data/svr/mysql/data
   log-error = /data/svr/mysql/log/mysqld.log
   
   #连接
   bind-address            = 0.0.0.0
   mysqlx-bind-address     = 127.0.0.1
   max_connections=1024
   
   #缓存
   innodb_buffer_pool_size=512M
   innodb_buffer_pool_instances=4
   
   #binlog分割大小
   max_binlog_size   = 100M
   
   #慢查询2s
   long_query_time=2
   slow_query_log=ON
   slow_query_log_file=/data/svr/mysql/log/db-slow.log

2. sudo vim /etc/mysql/mysql.conf.d/mysql.cnf #客户端配置socket和服务器保持一致

   [mysql]
   socket=/data/svr/mysql/mysqld.sock

3. sudo vim /etc/apparmor.d/usr.sbin.mysqld #给mysql修改自定义目录的权限

   # Allow data dir access
     /data/srv/mysql/ r,
     /data/srv/mysql/** rwk,
     /var/lib/mysql/ r,
     /var/lib/mysql/** rwk,

4. 重启配置生效

   sudo systemctl restart apparmor
   sudo systemctl restart mysql

3.创建用户

sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123321';     #修改root密码
CREATE USER 'svr'@'%' IDENTIFIED BY '123321';                                        #创建svr@%用户