CentOS6.9安装mysql5.7

1、查看系统版本 
uname -a

2、卸载old mysql 
rpm -qa|grep -i mysql

rpm -ev MySQL-client-5.5.25a-1.rhel5 如果提示依赖错误，增加–nodeps 
find / -name mysql 
rm -rf /var/lib/mysql 
rm -rf /var/lib/mysql 
rm -rf /usr/lib64/mysql 
rm -rf /etc/my.cnf 
rpm -qa|grep -i mysql

3、下载mysql，如果是centos6系列一定要el6，不然出现glibc安装错误 
wget http://mirror.centos.org/centos/6/os/x86_64/Packages/numactl-2.0.9-2.el6.x86_64.rpm

tar -xvf mysql-5.7.16-1.el6.x86_64.rpm-bundle.tar

4、安装基础包 
yum install gcc gcc-c++ ncurses-devel perl

wget http://mirror.centos.org/centos/6/os/x86_64/Packages/numactl-2.0.9-2.el6.x86_64.rpm 
＃这个包在安装server提示libnuma.so.1

5、安装mysql（顺序：common-libs-client-server，里面compat，test，devel，embedded根据需要安装) 
rpm -ivh mysql-community-common-5.7.18-1.el6.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.16-1.el6.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.16-1.el6.x86_64.rpm 
rpm -ivh mysql-community-server-5.7.16-1.el6.x86_64.rpm 
(遇到问题error: Failed dependencies: 
libnuma.so.1()(64bit) is needed by mysql-community-server-5.7.16-1.el6.x86_64) 
yum install libnuma.so.1 安装后的包是numactl-2.0.9-2.el6.i686.rpm，问题依旧，经分析后重新下载 yum -y install libnuma.so.1.x86_64，重新编译安装，成功！原因估计是系统不兼容i686） 
6、启动服务 
service mysqld start 
7、查看root 临时密码 
grep ‘temporary password’ /var/log/mysqld.log

8、修改root密码 
mysql -uroot -p 
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyNewPass4!’; 
设置用户 root 可以在任意 IP 下被访问： 
grant all privileges on . to root@”%” identified by “新密码”; 
设置用户 root 可以在本地被访问： 
grant all privileges on . to root@”localhost” identified by “新密码”; 
刷新权限使之生效： 
flush privileges;

 

启动 MySQL 服务：
service mysqld start

关闭 MySQL 服务：
service mysqld stop

重启 MySQL 服务：
service mysqld restart

查看 MySQL 的状态：
service mysqld status

查看 MySQL 的字符集：

mysql> show variables like '%character%';

修改字符集为UTF-8，找到my.cnf配置文件，修改如下：

重启MySQL后生效。

忘记密码时，可用如下方法重置：
# service mysqld stop
# mysqld_safe --user=root --skip-grant-tables --skip-networking &
# mysql -u root 
mysql> use mysql;
mysql> update user set password=password("new_password") where user="root"; 
mysql> flush privileges;

 

在centos 6.9 上rpm安装mysql

环境：

Linux:CentOS release 6.9 64bit

MySQL: mysq-5.7.18

1、在/home创建mysql目录，下载如下四个软件包

http://mirrors.sohu.com/mysql/MySQL-5.7/

wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-community-client-5.7.18-1.el6.x86_64.rpm

wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-community-common-5.7.18-1.el6.x86_64.rpm

wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-community-libs-5.7.18-1.el6.x86_64.rpm

wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-community-server-5.7.18-1.el6.x86_64.rpm

2、检查mysql rpm相关的包是否安装并去除

[root@centos-6 mysql]# rpm -qa | grep -i mysql

mysql-libs-5.1.73-8.el6_8.x86_64

[root@centos-6 mysql]# rpm -e mysql-libs-5.1.73-8.el6_8.x86_64

error: Failed dependencies:

libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-8.el6.x86_64

libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-8.el6.x86_64

mysql-libs is needed by (installed) postfix-2:2.6.6-8.el6.x86_64

[root@centos-6 mysql]#

将依赖包一并删除

[root@centos-6 mysql]# yum remove -y mysql-libs

再次查询是否删除干净

[root@centos-6 mysql]# rpm -qa | grep -i mysql

[root@centos-6 mysql]#

3、同时安装这四个rpm包

rpm -ivh mysql-community-client-5.7.18-1.el6.x86_64.rpm mysql-community-common-5.7.18-1.el6.x86_64.rpm mysql-community-libs-5.7.18-1.el6.x86_64.rpm mysql-community-server-5.7.18-1.el6.x86_64.rpm

4、出现缺少依赖包解决方式

[root@centos-6 home]# rpm -ivh mysql-community-client-5.7.18-1.el6.x86_64.rpm mysql-community-common-5.7.18-1.el6.x86_64.rpm mysql-community-libs-5.7.18-1.el6.x86_64.rpm mysql-community-server-5.7.18-1.el6.x86_64.rpm

warning: mysql-community-client-5.7.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

error: Failed dependencies:

libnuma.so.1()(64bit) is needed by mysql-community-server-5.7.18-1.el6.x86_64

libnuma.so.1(libnuma_1.1)(64bit) is needed by mysql-community-server-5.7.18-1.el6.x86_64

libnuma.so.1(libnuma_1.2)(64bit) is needed by mysql-community-server-5.7.18-1.el6.x86_64

[root@centos-6 home]# yum install -y numactl

5、mysql数据库设置

service mysqld stop 

mysqld_safe --skip-grant-tables &

mysql -uroot -p

>use mysql;

> update user set authentication_string=PASSWORD("root") where user="root";

 update user set host='%' where user="root";

FLUSH PRIVILEGES; 

service mysqld restart

mysql -uroot -proot

SET PASSWORD = PASSWORD('root');

View Code

 

转载于:https://www.cnblogs.com/killall007/p/8470343.html