# 下载通用版本 54 2022-05-29 20:04:17 root wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz # 0. 准备操作 [创建用户组用户分配权限安装依赖] 11 2022-05-29 20:28:27 root tar zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz 12 2022-05-29 20:31:17 root mv mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql 13 2022-05-29 20:31:39 root cd /usr/local/mysql/ 15 2022-05-29 20:31:47 root mkdir data 16 2022-05-29 20:31:54 root groupadd mysql 18 2022-05-29 20:32:18 root useradd -r -g mysql mysql 19 2022-05-29 20:32:21 root ls 20 2022-05-29 20:32:29 root chown -R mysql:mysql /usr/local/mysql 21 2022-05-29 20:32:32 root chmod -R 755 /usr/local/mysql 24 2022-05-29 20:33:17 root yum install -y libaio # 1. 初始化数据库 22 2022-05-29 20:32:36 root cd /usr/local/mysql/bin 23 2022-05-29 20:32:42 root ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql 26 2022-05-29 20:33:47 root cd ../ 28 2022-05-29 20:33:59 root support-files/mysql.server start 29 2022-05-29 20:34:12 root cat /etc/my.cnf # 1.0 把没用的配置信息注释掉, 见附录 1. 30 2022-05-29 20:34:18 root vim /etc/my.cnf 31 2022-05-29 20:34:46 root support-files/mysql.server start # 启动 42 2022-05-29 20:35:23 root service mysql restart 43 2022-05-29 20:35:37 root ps -ef|grep mysqld ## 8、添加软连接，并重启mysql服务 [参考原文 1. ] 45 2022-05-29 20:35:49 root ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql 46 2022-05-29 20:35:50 root ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 47 2022-05-29 20:35:54 root service mysql restart 55 2022-05-29 20:38:50 root mysql -uroot -p 56 2022-05-29 20:39:17 root service status mysql ## 11、设置开机自启 [参考原文 1. ] 59 2022-05-29 20:39:45 root cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld 60 2022-05-29 20:39:50 root chmod +x /etc/init.d/mysqld 61 2022-05-29 20:39:53 root chkconfig --add mysqld 62 2022-05-29 20:39:55 root reboot 63 2022-05-29 20:40:30 root service mysql start 64 2022-05-29 20:40:38 root service mysql status 65 2022-05-29 20:40:46 root mysql -uroot -p ## 数据迁移 [停止数据库创建新文件路径拷贝数据文件修改配置文件启动...排查错误] 67 2022-05-29 20:51:45 root service mysql stop; 68 2022-05-29 20:52:14 root mkdir /home/mysql/data 69 2022-05-29 20:52:19 root mkdir -p /home/mysql/data 70 2022-05-29 20:52:31 root chown -R mysql:mysql /home/mysql/data 71 2022-05-29 20:52:59 root cp -R /usr/local/mysql/data /home/mysql/data ## 排错过程 72 2022-05-29 20:53:13 root vim /etc/my.cnf 73 2022-05-29 20:54:02 root service mysql start 74 2022-05-29 20:54:13 root cat /home/mysql/data/hecs-341880.err 109 2022-05-29 21:00:06 root service mysql start 110 2022-05-29 21:00:40 root cat /home/mysql/data/hecs-341880.err ## 配置文件见 附录2 122 2022-05-29 21:03:30 root vim /etc/my.cnf 129 2022-05-29 21:05:53 root service mysql start 130 2022-05-29 21:05:59 root cat /home/mysql/data/data/hecs-341880.err 133 2022-05-29 21:06:17 root mysql -uroot -p 135 2022-05-29 21:07:13 root vim /etc/my.cnf 136 2022-05-29 21:07:21 root service mysql start 138 2022-05-29 21:07:34 root service mysql restart 139 2022-05-29 21:07:54 root pwd 140 2022-05-29 21:08:00 root ps -ef | grep mysql 141 2022-05-29 21:08:06 root vim /etc/my.cnf 143 2022-05-29 21:08:25 root service mysql stop 144 2022-05-29 21:08:35 root vim /etc/my.cnf 145 2022-05-29 21:08:43 root service mysql start 146 2022-05-29 21:08:49 root mysql -uroot -p参考内容
1. Linux下安装mysql
附录- 初始化数据
[mysqld] #datadir=/var/lib/mysql #socket=/var/lib/mysql/mysql.sock #socket=/home/mysql/data/mysql.sock #datadir=/home/mysql/data/data # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd [mysqld_safe] #log-error=/var/log/mariadb/mariadb.log #pid-file=/var/run/mariadb/mariadb.pid # # include all files from the config directory # #!includedir /etc/my.cnf.d
- 配置文件
[mysqld] #datadir=/var/lib/mysql #socket=/var/lib/mysql/mysql.sock socket=/home/mysql/data/mysql.sock datadir=/home/mysql/data/data # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd [mysqld_safe] #log-error=/var/log/mariadb/mariadb.log #pid-file=/var/run/mariadb/mariadb.pid # # include all files from the config directory # #!includedir /etc/my.cnf.d
