CentOS下MySQL安装
二进制安装mysql
安装必要依赖
yum install perl perl-devel libaio libstdc++.so.6 libaio.so.1 libncurses.so.5
1、解压二进制包到/usr/local/目录下
tar -zxvf mysql-5.6.29-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
2、进入/usr/local/设置软连接或者直接将解压的目录重命名为mysql
ln -s mysql-5.6.29-linux-glibc2.5-x86_64 mysql
3、设置用户组及权限
创建用户组并添加用户
groupadd mysql
useradd -r -g mysql mysql
进入/usr/local/mysql目录给用户授权
chown -R mysql .
chgrp -R mysql .
4、初始化数据库的表
scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
出现如下异常:
FATAL ERROR: please install the following Perl modules before executing /usr/bin/mysql_install_db:
Data::Dumper
解决方案:
yum install -y perl-Module-Install.noarch
异常:
Installing MySQL system tables…/usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
解决方案:
yum install libaio
修改配置
cp support-files/mysql.server /etc/init.d/mysqld
cp my.cnf /etc/my.cnf
vi /etc/my.cnf
[mydqld] 下添加
[mydqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
server_id = 1
character-set-server=utf8
5、新增软链接
ln -s /usr/local/mysql/bin/mysql /usr/bin
6、启动
service mysqld start
7、登录
使用root登录 第一次密码为空,直接回车可进入
mysql -uroot -p
8、修改root用户密码
UPDATE mysql.user set password = PASSWORD('123456') WHERE user = 'root';
删除空用户
DROP USER ''@localhost;
刷新
FLUSH PRIVILEGES;
9、新增数据库用户并授权
grant 操作 on 数据库.数据表 to 用户名@访问地址 identified by '密码'
新增用户名为username,密码为123456的用户并授予所有库所有表(.)所有权限(all privileges),并允许所有人访问(%)
grant all privileges on *.* to username@'%' identified by '123456';
新增用户名为test,密码123456的用户并给数据库(db_shop)的表(tb_product)授予查询(select)、新增(insert)、修改(update)、删除(delete)权限,且只允许在IP为192.168.3.112的机器上访问
grant select, insert, update, delete on db_shop.tb_product to test@'192.168.3.112' identified by '123456';