Liunx Mysql安装
说明:
Linux下软件的安装通常有三种方式:二进制、rpm、yum三种方式。
MySQL的下载:
因为我使用的是阿里云服务器,联网的,所以我直接在linux下进行下载,使用Windows的小伙伴也可以将mysql下载本地再上传到服务器上面
附上官网的下载链接通过命令行在服务器内下载软件包的连接:
官网: MySQL官网下载
服务器下载(联网):wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
卸载原有的mysql
# 查看
rpm -qa | grep mysql
# 若存在 mysql 安装文件,则会显示 mysql安装的版本信息
# 如:mysql-connector-odbc-5.2.5-6.el7.x86_64
# 卸载
rpm -e --nodeps mysql-connector-odbc-5.2.5-6.el7.x86_64
上传下载的安装包
解压:tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
重命名:mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql
移动:mv mysql /usr/local/
添加用户组、用户
groupadd mysql
useradd -g mysql mysql
创建data目录与更改权限
cd /usr/local/mysql
mkdir data
pwd
# /usr/local/mysql
chown -R mysql:mysql ./
配置my.cnf
[root etc]# pwd
/etc
[root etc]# touch my.cnf
[mysqld]
server-id=1
port=16033
socket=/tmp/mysql.sock
# 设置mysql的安装目录
basedir=/usr/local/mysql
# 设置mysql数据库的数据的存放目录
datadir=/usr/local/mysql/data
# 开启bin log
log_bin=/usr/local/mysql/data/mysql-bin
binlog-format=ROW
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
# 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
初始化mysql
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
#执行完后会输出:红色的就是初始密码
设置mysql为开机自启
#拷贝mysql.server到init.d目录下
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
#添加服务
chkconfig --add mysqld
#查看是否添加成功
chkconfig --list mysqld
配置环境变量
vi /etc/profile
#添加如下内容
PATH=$PATH:/usr/local/mysql/bin
export PATH
#使配置生效
source /etc/profile
#查看一下配置是否生效
echo $PATH
首次登录更改 密码
alter user '用户名'@'localhost | %' identified by '密码';
alter user 'root'@'localhost' identified by 'Daxizi7724530!';