在linux上安装mysql rpm包

水深无声 2022-08-18 12:14 154阅读 0赞

环境：

linux:CentOS release 6.3

mysql: 5.6.28-log MySQL Community Server (GPL)

1.检查mysql rpm相关的包是否安装

\[root@mysqlmaster mysqlinstall\]\# rpm -qa | grep -i mysql  
mysql-libs-5.1.61-4.el6.x86\_64  
如果存在删除：  
\[root@mysqlmaster mysqlinstall\]\# rpm -e mysql-libs-5.1.61-4.el6.x86\_64  
error: Failed dependencies:  
        libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6\_1.x86\_64  
        libmysqlclient.so.16(libmysqlclient\_16)(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6\_1.x86\_64  
        mysql-libs is needed by (installed) postfix-2:2.6.6-2.2.el6\_1.x86\_64  
忽略依赖包删除      
\[root@redis1 ~\]\# rpm -e --nodeps mysql-libs-5.1.61-4.el6.x86\_64  
或者删除依赖包   
\[root@mysqlmaster mysqlinstall\]\# yum -y remove mysql-libs  
\[root@mysqlmaster mysqlinstall\]\# rpm -qa | grep -i mysql  
2.上传下载的安装包MySQL-5.6.28-1.el6.x86\_64.rpm-bundle.tar  
解压：  
tar -xvf MySQL-5.6.28-1.el6.x86\_64.rpm-bundle.tar  
3.安装mysql服务端：  
\[root@mysqlmaster mysqlinstall\]\# rpm -ivh MySQL-server-5.6.28-1.el6.x86\_64.rpm  
warning: MySQL-server-5.6.28-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-server-5.6.28-1.el6.x86\_64  
        libnuma.so.1(libnuma\_1.1)(64bit) is needed by MySQL-server-5.6.28-1.el6.x86\_64  
        libnuma.so.1(libnuma\_1.2)(64bit) is needed by MySQL-server-5.6.28-1.el6.x86\_64  
缺失依赖包  
\[root@mysqlmaster mysqlinstall\]\# yum install numactl  
  
\[root@mysqlmaster mysqlinstall\]\# rpm -ivh MySQL-server-5.6.28-1.el6.x86\_64.rpm  
warning: MySQL-server-5.6.28-1.el6.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
Preparing...                \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
   1:MySQL-server           \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
warning: user mysql does not exist - using root  
warning: group mysql does not exist - using root  
4.安装mysql 客户端  
\[root@mysqlmaster mysqlinstall\]\# rpm -ivh MySQL-client-5.6.28-1.el6.x86\_64.rpm   
warning: MySQL-client-5.6.28-1.el6.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
Preparing...                \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
   1:MySQL-client           \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
\[root@mysqlmaster mysqlinstall\]\#   
5.修改mysql配置文件  
vi /etc/my.cnf  
\[mysqld\]  
\# Options for mysqld process:  
\#skip-grant-tables  
character\_set\_server=utf8  
lower\_case\_table\_names=1  
max\_connections=1000  
datadir=/var/lib/mysql  
\[root@mysqlmaster mysql\]\# service mysql start  
Starting MySQL SUCCESS!   
6.登录修改root密码  
查看root 用户的密码  
\[root@mysqlmaster mysql\]\# cat /root/.mysql\_secret  
\# The random password set for the root user at Fri Dec 18 14:12:44 2015 (local time): g478da9wvEZniGqa  
root用户登录  
\[root@mysqlmaster mysql\]\# mysql -uroot -p  
Enter password:   
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 3  
Server version: 5.6.28  
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
mysql> SET PASSWORD = PASSWORD('root001');        ---设置root用户密码  
Query OK, 0 rows affected (0.01 sec)  
mysql> exit  
Bye  
重新登录  
\[root@mysqlmaster mysql\]\# mysql -uroot -proot001  
7.设置root用户支持远程登录：  
mysql> select host,user,password from user;  
\+-------------+------+-------------------------------------------+  
| host        | user | password                                  |  
\+-------------+------+-------------------------------------------+  
| localhost   | root | \*F4368ED34678C82DC260E668501F2FA7201F34EB |  
| mysqlmaster | root | \*F7FFE6B0AA46DE21A8F0520CE00A0927B01B125D |  
| 127.0.0.1   | root | \*F7FFE6B0AA46DE21A8F0520CE00A0927B01B125D |  
| ::1         | root | \*F7FFE6B0AA46DE21A8F0520CE00A0927B01B125D |  
\+-------------+------+-------------------------------------------+  
4 rows in set (0.00 sec)  
mysql> update user set password=password('root001') where user='root';  
Query OK, 3 rows affected (0.00 sec)  
Rows matched: 4  Changed: 3  Warnings: 0  
mysql> update user set host='%' where user='root' and host='localhost';  
Query OK, 1 row affected (0.00 sec)  
Rows matched: 1  Changed: 1  Warnings: 0  
mysql>  select host,user,password from user;  
\+-------------+------+-------------------------------------------+  
| host        | user | password                                  |  
\+-------------+------+-------------------------------------------+  
| %           | root | \*F4368ED34678C82DC260E668501F2FA7201F34EB |  
| mysqlmaster | root | \*F4368ED34678C82DC260E668501F2FA7201F34EB |  
| 127.0.0.1   | root | \*F4368ED34678C82DC260E668501F2FA7201F34EB |  
| ::1         | root | \*F4368ED34678C82DC260E668501F2FA7201F34EB |  
\+-------------+------+-------------------------------------------+  
4 rows in set (0.00 sec)  
mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)