Linux下二进制文件安装MySQL

来源：互联网发布：二维码追溯软件编辑：程序博客网时间：2024/05/20 09:06

MySQL 下载地址：https://dev.mysql.com/downloads/mysql/

并按如下方式选择来下载安装包。

1. 设置配置文件/etc/my.cnf

more /etc/my.cnf[client]  port = 3306  socket = /tmp/mysql.sock    [mysqld]  user=mysql  port = 3306  server_id = 1  socket=/tmp/mysql.sock  basedir =/usr/local/mysql  datadir =/usr/local/mysql/data  pid-file=/usr/local/mysql/data/mysqld.pid  log-error=/usr/local/mysql/log/mysql-error.log

2.新建用户和用户组

groupadd mysqluseradd -r -g mysql -s /bin/false mysql

3.解压mysql二进制文件到目录/usr/local目录下，并重命名为mysql

cd /usr/localtar -xf /root/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gzmv  mysql-5.7.18-linux-glibc2.5-x86_64  mysqlcd mysqlchown -R mysql .chgrp -R mysql .mkdir logchown -R mysql:mysql  logchmod 755 logcd /usr/local/mysql/logtouch mysql-error.logchmod 755 mysql-error.logchown mysql:mysql mysql-error.log

4.初始化数据库

cd /usr/local/mysqlbin/mysqld --initialize --user=mysql

初始化数据库后的密码存放在mysql-error.log文件中

5.设置环境变量

在~/.bash_profile文件中添加mysql的安装目录，添加后的结果如下：

[root@CentOS6 mysql]# vi ~/.bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then        . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/bin:/usr/local/mysql/binexport PATH

#使修改生效

source ~/.bash_profile

6.设置service服务自启动

cd  /usr/local/mysqlcp support-files/mysql.server /etc/init.d/mysql.serverservice mysql.server startservice mysql.server restartservice mysql.server stop

7.修改MySQL的root密码

set password for root@localhost = password('mysql'); flush privileges;

0 0