linux系统下mysql的安装
一、yum安装:
1、在https://dev.mysql.com/downloads/repo/yum/网站下下载合适的版本
2、在linux内yun安装
列出所有版本,警用8.0版本
yum repolist all | grep mysql
yum-config-manager --disable mysql80-community
安装
yum-config-manager
yum -y install yum-utils
启用5.7版本
yum-config-manager --enable mysql57-community
yum repolist all | grep mysql
yum install mysql-community-server
启用MySQL
systemctl start mysqld
使用grep命令查询密码
grep 'temporary password' /var/log/mysqld.log
登录修改密码
登录:mysql -u root -p (密码)
修改: ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
二、linux下用二进制安装
1、在Mysql:https://downloads.mysql.com/archives/community/下载glibc版本的
将下载的文件传入linux系统下
2、安装
groupadd -r -g 306 mysql
useradd -g 306 -r -u 306 mysql
初始化
ar xf mysql-5.7.14-linux-glibc2.5-x86_64.tar -C /usr/local/
cd /usr/local/
tar xf mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz
ln -sv mysql-5.7.14-linux-glibc2.5-x86_64 mysql
chown -R mysql.mysql mysql/*
注意:初始化会给出随机密码,切记保存!
修改配置文件
mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql -- datadir=/usr/local/mysql/data
cd /usr/local/mysql
\cp support-files/my-default.cnf /etc/my.cnf vim /etc/my.cnf
vim /etc/my.cnf
datadir = /usr/local/mysql/data
为mysql提供sysv服务脚本
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
启动mysql
systemctl start mysqld
将mysql的bin目录加入PATH环境变量,编辑/etc/profile文件
更新配置文件
source /etc/profile
登录数据库,修改密码
登录:mysql -u root -p (密码)
修改: ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
三、Linux下源码安装数据库
1、安装依赖包
yum install -y gcc gcc-c++ cmake ncurses ncurses-devel bison
2、安装开发工具和开发包
yum install make gcc gcc-c++ cmake bison-devel ncurses-devel -y
yum install libaio libaio-devel openssl-devel -y
yum install perl-Data-Dumper -y
yum install net-tools -y
3、下载所需的源码包
https://downloads.mysql.com/archives/community/
创建用户和组:
建立所需目录并更改所有者为mysql
将下载好的压缩包 解压到/usr/local/mysql 目录下
tar -zxvf mysql-boost-5.7.25.tar.gz -C /usr/local/mysql/
解译安装
cmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost
make && make install
初始化
/usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql/
为mysql提供主配置文件
cd /usr/local/mysql/
\cp support-files/my-default.cnf /etc/my.cnf
vim /etc/my.cnf
添加指定mysql数据文件的存放位置
datadir = /usr/local/mysql/data
为mysql提供sysv服务脚本
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
修改PATH环境变量,让系统可以直接使用mysql的相关命令
vim /etc/profile.d/mysql.sh
export PATH=$PATH:/usr/local/mysql/bin
source mysql.sh
3、启动MySQL
systemctl start mysqld
登录修改密码
登录:mysql -u root -p (密码)
修改: ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';