Linux环境下安装MySQL

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;