How to install MySQL binary

藏色散人
Release: 2021-12-08 17:47:38
Original
6667 people have browsed it

MySQL binary installation method: 1. Download the binary package; 2. Mount the new logical volume to "/data"; 3. Unzip it to the installation directory and view the built-in installation information; 4. Set the configuration file; 5. Specify the database; 6. Service startup script; 7. Perform safe initialization.

How to install MySQL binary

The operating environment of this tutorial: CentOS 7 system, mysql version 8, Dell G3 computer.

MySQL Binary Installation

Planning

1. Download the binary package

https: //downloads.mariadb.org/mariadb/10.2.16/

2. Clean logical volume lvm

3. New logical volume Mount to /data

4. Store the database in the /data/mysql directory

5. Unzip to the installation directory and view the built-in installation information

6. Set configuration file

7. Specify database

8. Service startup script

9. Safe initialization

Create a new LVM partition

1, create a new logical volume and set the space

fdisk /dev/sda #
Copy after login

How to install MySQL binaryHow to install MySQL binary

How to install MySQL binary

##2. New logical volume type

How to install MySQL binary

How to install MySQL binary

How to install MySQL binary

##3. The new partition takes effect

partprobe # #
Copy after login

How to install MySQL binary

4. Create volume groups, logical volumes, and physical volumes

How to install MySQL binary

How to install MySQL binary

How to install MySQL binary##5. Mount

How to install MySQL binary

vim /etc/fstab # #
Copy after login

How to install MySQL binary

mysql安装设置

1、创建mysql账号信息

useradd -r -s /sbin/nologin -d /data/mysql -m mysql # #
Copy after login

How to install MySQL binary[39]

2、解压mysql二进制文件

How to install MySQL binary[41]

备注:必须解压到/usr/local目录下

3、创建mysql软连接

How to install MySQL binary[43]

4、修改mysql目录下所有的权限

How to install MySQL binary[45]

5、把执行文件bin放入 $PATH全局变量

vim /etc/profile.d/mysql.sh
Copy after login
#
Copy after login
Copy after login
#
Copy after login
Copy after login

How to install MySQL binary[47]

让设置生效

. /etc/profile.d/mysql.sh # #
Copy after login

6、生成数据库文件

scripts/mysql_install_db --datadir=/data/mysql --user=mysql # #
Copy after login

How to install MySQL binary[49]

7、编辑mysql配置文件

How to install MySQL binary[51]

备注:图上是复制配置模板覆盖原来的文件,根据环境来选着不同的模板文件

vim /etc/my.cnf # #
Copy after login

How to install MySQL binary[53]

备注:要注意这里数据库路径一定要和上面指定的存放数据库文件的路径一致

启动文件

1、把mysql启动文件放入init.d

How to install MySQL binary[55]

2、加入启动列表

How to install MySQL binary[57]

2、启动服务

service mysqld start # #
Copy after login

备注:如果启动失败,注意检查权限和路径

到这mysql是可以登入了,但是现在随便一个用户都可以登入,无需密码验证,这样太不安全,下面简单的加固下

安全加固

mysql_secure_installation # #
Copy after login

How to install MySQL binary[59]

How to install MySQL binary[61]

结果

指定root用户 –p 输入密码登陆【推荐学习:mysql视频教程

How to install MySQL binary

The above is the detailed content of How to install MySQL binary. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!