上传
查询是否已经安装
rpm -qa|grep My
删除存在的软件包
rpm -e 软件包
[root@hadoop1 mysql-libs]# rpm -qa|grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[root@hadoop1 mysql-libs]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
[root@hadoop1 mysql-libs]# yum -y install autoconf
[hadoop@hadoop1 soft]$ sudo yum install zip unzip
[hadoop@hadoop1 soft]$ pwd
/opt/soft
[hadoop@hadoop1 soft]$ ll
total 719948
-rw-r--r--. 1 root root 55711670 May 3 16:07 apache-flume-1.7.0-bin.tar.gz
-rw-r--r--. 1 root root 197657687 May 3 12:01 hadoop-2.7.2.tar.gz
-rw-r--r--. 1 root root 62282700 May 3 11:59 hadoop-lzo-master.zip
-rw-r--r--. 1 root root 185515842 May 3 00:44 jdk-8u144-linux-x64.tar.gz
-rw-r--r--. 1 root root 42136632 May 3 16:37 kafka_2.11-0.11.0.2.tgz
-rw-r--r--. 1 root root 1417459 May 3 16:36 kafka-clients-0.11.0.2.jar
-rw-r--r--. 1 root root 79630940 May 3 16:38 kafka-manager-1.3.3.22.zip
-rw-r--r--. 1 root root 77807942 May 3 17:17 mysql-libs.zip
-rw-r--r--. 1 root root 35042811 May 3 13:46 zookeeper-3.4.10.tar.gz
[hadoop@hadoop1 soft]$ unzip mysql-libs.zip
[hadoop@hadoop1 mysql-libs]$ pwd
/opt/soft/mysql-libs
[hadoop@hadoop1 mysql-libs]$ ll
total 76048
-rw-rw-r--. 1 hadoop hadoop 18509960 Mar 26 2015 MySQL-client-5.6.24-1.el6.x86_64.rpm
-rw-rw-r--. 1 hadoop hadoop 3575135 Dec 1 2013 mysql-connector-java-5.1.27.tar.gz
-rw-rw-r--. 1 hadoop hadoop 55782196 Mar 26 2015 MySQL-server-5.6.24-1.el6.x86_64.rpm
安装服务器
[root@hadoop1 ~]# cd /opt/soft/mysql-libs
[root@hadoop1 mysql-libs]# rpm -ivh MySQL-server-5.6.24-1.el6.x86_64.rpm
如果这个命令显示失败如下,就输入yum install net-tools
[root@hadoop1 mysql-libs]# cat /root/.mysql_secret
[root@hadoop1 mysql-libs]# service mysql status
ERROR! MySQL is not running
[root@hadoop1 mysql-libs]# service mysql start
Starting MySQL. SUCCESS!
安装客户端
[root@hadoop1 ~]# cd /opt/soft/mysql-libs
[root@hadoop1 mysql-libs]# rpm -ivh MySQL-client-5.6.24-1.el6.x86_64.rpm
[root@hadoop1 mysql-libs]# mysql -uroot -p
设置密码
SET PASSWORD=PASSWORD('root');
flush privileges;
测试新密码
设置权限
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set host='%' where host='localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select User, Host, Password from user;
+------+-----------+-------------------------------------------+
| User | Host | Password |
+------+-----------+-------------------------------------------+
| root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root | hadoop1 | *F67C08AD6794B84119DCE43DEF140B182368B10A |
| root | 127.0.0.1 | *F67C08AD6794B84119DCE43DEF140B182368B10A |
| root | ::1 | *F67C08AD6794B84119DCE43DEF140B182368B10A |
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql> delete from user where Host ='hadoop1' or Host='127.0.0.1' or Host='::1';
Query OK, 3 rows affected (0.00 sec)
刷新、退出。
mysql> flush privileges;
mysql> quit;
Yum安装方式参考
CentOS7安装MySQL(完整版)_24只羊羊羊-CSDN博客_centos7安装mysql
mysql> update user set authentication_string=password('root') where user='root';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)