centos 安装mysql

Linux下RPM格式安装

rpm包内容

        MySQL-client-5.6.21-1.linux_glibc2.5.x86_64.rpm #MySQL客户端程序

        MySQL-devel-5.6.21-1.linux_glibc2.5.x86_64.rpm #MySQL的库和头文件

        MySQL-embedded-5.6.21-1.linux_glibc2.5.x86_64.rpm #MySQL的嵌入式程序

        MySQL-server-5.6.21-1.linux_glibc2.5.x86_64.rpm #MySQL服务端程序

        MySQL-shared-5.6.21-1.linux_glibc2.5.x86_64.rpm #MySQL的共享库

        MySQL-test-5.6.21-1.linux_glibc2.5.x86_64.rpm #MySQL的测试组件

检查系统中是否已经存在mysql安装包

rpm -qa | grep -i mysql

删除系统中已存在的安装包

rpm –e **.rpm

安装依赖包顺序

rpm -ivh mysql-community-common-5.7.16-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.16-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.16-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.16-1.el7.x86_64.rpm

其他依赖包选择安装

安装报错处理

1.安装mysql-community-common-5.7.17-1.el7.x86_64.rpm报错conflicts with file from package mariadb-libs 

解决办法   yum -y remove mariadb-libs-*

2. rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm 
报错：
warning: mysql-community-server-5.7.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
        /usr/bin/perl is needed by mysql-community-server-5.7.19-1.el7.x86_64
        libaio.so.1()(64bit) is needed by mysql-community-server-5.7.19-1.el7.x86_64
        libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.19-1.el7.x86_64
        libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.19-1.el7.x86_64
        net-tools is needed by mysql-community-server-5.7.19-1.el7.x86_64
        perl(Getopt::Long) is needed by mysql-community-server-5.7.19-1.el7.x86_64
        perl(strict) is needed by mysql-community-server-5.7.19-1.el7.x86_64

解决办法：

yum -y install perl.x86_64
yum install -y libaio.x86_64
yum -y install net-tools.x86_64

3. rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm 报错

 libsasl2.so.2()(64bit) 被 mysql-community-server-5.7.19-1.el6.x86_64 需要；

解决办法：

方法1：rpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm  --force  --nodeps

方法2 ：

修改vim /etc/yum.repos.d/mysql-community.repo 源文件

[mysql57-community]

name=MySQL 5.7 Community Server

## baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/   

baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
 

启动mysql服务

/etc/init.d/mysqld start

检查mysql安装是否正常

Mysql –uroot

能够正常启动mysql程序说明安装成功

提示密码错误

使用免密码登陆

方法一：

mysqld_safe --user=mysql --skip-grant-tables --skip-networking & mysql -u root mysql

方法二：

1、 修改mysql配置文件

my.cnf 加入skip-grant-tables

2、 重启mysql服务

/etc/init.d/mysqld restart

设置密码

1、 登陆终端

2、 Use mysql

3、update mysql.user set authentication_string=password('Password!@#123') where user='root' ;

(password(‘***’)):***为设置的root用户密码 

4、 flush privileges; 刷新权限

查看用户远程访问权限

Use mysql;

Select user,host from user;

User	Host
Root	Localhost

表示root用户只能在本机访问

User	Host
Root	%

表示root用户允许在任意地址访问

授权root用户在任意地址访问

update user set host = '%' where user = 'root'; //用户允许从任意地址访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION //赋予root所有权限

FLUSH PRIVILEGES //刷新权限

远程连接提示10038

查看当前mysql端口

mysql> show global variables like 'port';

修改mysql端口

my.cnf中添加port=3506（3506为修改的端口，mysql默认端口3306）

重启mysql服务

查看当前端口占用

netstat -anp|grep 80

查看防火墙是否放开端口

centos 6

打开防火墙配置文件

Vi /etc/sysconfig/iptables

放开mysql端口

A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT

（iptables中存在则不做修改，3306为当期mysql使用端口）

重启防火墙

service iptables restart

centos 7:

开放端口：

firewall-cmd --zone=public --add-port=9200/tcp --permanent
1
关闭端口：

firewall-cmd --permanent --remove-port=9200/tcp
1
查询端口是否开放：

firewall-cmd --query-port=9200/tcp
1
重启：

firewall-cmd --reload
或者
systemctl restart firewalld.service

查看和修改数据库编码

[root@chenguo ~]# mysql

mysql> use mysql;

mysql> select Host,user from user where User='root';

mysql> show variables like 'character%';

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | latin1 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

rows in set (0.01 sec)

设置数据库的编码

1、my.cnf中添加

character-set-server=utf8

collation-server=utf8_general_ci

2、重启mysql服务

Can't start server: Bind on TCP/IP port: Permission denied

原因：selinux防火墙未关闭

解决方案：

vi /etc/selinux/config

SELINUX=disabled

#立即关闭

setenforce 0

查看

getenforce