Linux环境下安装MySQL

最新推荐文章于 2021-01-12 18:09:00 发布

LiaoYuanDou

最新推荐文章于 2021-01-12 18:09:00 发布

阅读量236

点赞数

分类专栏： Linux 文章标签： linux mysql

本文链接：https://blog.csdn.net/liaoyuan_09/article/details/74946960

版权

Linux 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

Linux环境下安装MySQL

检查MySQL以及相关RPM包是否有安装。

rpm -qa |  grep -i mysql
yum -y remove 包名 / rpm -e --nodeps mysql* #删除包
rm -rf /var/lib/mysql*
rm -rf /usr/share/mysql*               #扫尾工作

rpm安装

mkdir /usr/local/src/mysql
rpm –ivh MySQL-server-5.6*.rpm
rpm –ivh MySQL-devel-5.6*.rpm
rpm –ivh MySQL-client-5.6*.rpm
cd /etc/init.d
./mysql start

以tar.gz包的形式安装（无需有网）
1.解压：

tar -zxvf mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz -C /usr/local/  
mv mysql-5.6.30-linux-glibc2.5-x86_64 mysql

2.创建mysql用户：

groupadd mysql
useradd -d /home/mysql -g mysql -m mysql

3.设置权限

cd /usr/local
chown -R mysql:mysql mysql

4.切换到mysql用户

cd /usr/local/mysql/scripts/

5.安装

./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

这里可能会报错：

scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory。

需要安装perl以及perl-devel.执行命令：

yum –y install perl perl-devel
yum install -y perl-Module-Install.noarch

FATAL ERROR: please install the following Perl modules before executing ./mysql_install_db:
Data::Dumper

解决方法：安装autoconf库
命令：yum-y install autoconf //此包安装时会安装Data:Dumper模块

yum-y install autoconf

6.配置文件的复制与修改

cd /usr/local/mysql/support-files
cp my-default.cnf /etc/my.cnf
cp mysql.server /etc/init.d/mysql

vim /etc/init.d/mysql #若mysql的安装目录是/usr/local/mysql,则可省略此步
修改文件中的两个变更值

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

7.配置环境变量

vim /etc/profile
export MYSQL_HOME=/usr/local/mysql
export PATH=$MYSQL_HOME/bin:$PATH

vim /etc/my.cnf
max_allowed_packet = 20M
lower_case_table_names=1

保存退出

source /etc/profile
source /etc/my.cnf

8.启动

chkconfig --add mysql      #在服务中添加mysql服务
chkconfig mysql on         #设置mysql服务开机自动启动
service mysql start        #启动mysql服务

9.设置root登录密码：

cd /usr/local/mysql/bin/
./mysqladmin -u root password '123456'
/usr/local/mysql/bin/mysqladmin -u root password '123456'

10.登录以及设置登录权限：

mysql -uroot -p

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;

11.给其他用户赋权限

GRANT ALL PRIVILEGES ON *.* TO '用户'@'%' IDENTIFIED BY '用户密码' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO '用户'@'127.0.0.1' IDENTIFIED BY '用户密码' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO '用户'@'localhost' IDENTIFIED BY '用户密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;