1 安装包准备
1.查看mysql是否安装,如果安装了,卸载mysql
(1)查看
[caimh@master-node ~]$ rpm -qa|grep -i mysql
mysql-libs-5.1.71-1.el6.x86_64
(2)卸载
[caimh@master-node ~]$ sudo rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64
2.解压mysql-libs.zip文件到当前目录
[caimh@master-node software]$ ll
总用量 585688
-rw-rw-r--. 1 caimh caimh 90859180 9月 26 2019 apache-hive-1.2.2-bin.tar.gz
-rw-r--r--. 1 caimh caimh 198865940 9月 1 06:20 hadoop-2.7.4-with-centos-6.5.tar.gz
-rw-r--r--. 1 caimh caimh 8009 9月 10 11:35 HDFSClientDemo-1.0-SNAPSHOT.jar
-rw-r--r--. 1 caimh caimh 194990602 5月 28 18:07 jdk-8u211-linux-x64.tar.gz
-rw-rw-r--. 1 caimh caimh 77807942 3月 3 2017 mysql-libs.zip
-rw-r--r--. 1 caimh caimh 37191810 6月 7 17:16 zookeeper-3.4.13.tar.gz
[caimh@master-node software]$ sudo yum -y install unzip
[caimh@master-node software]$ unzip mysql-libs.zip
[caimh@master-node software]$ cd mysql-libs
[caimh@master-node mysql-libs]$ ll
总用量 76048
-rw-rw-r--. 1 caimh caimh 18509960 3月 26 2015 MySQL-client-5.6.24-1.el6.x86_64.rpm
-rw-rw-r--. 1 caimh caimh 3575135 12月 1 2013 mysql-connector-java-5.1.27.tar.gz
-rw-rw-r--. 1 caimh caimh 55782196 3月 26 2015 MySQL-server-5.6.24-1.el6.x86_64.rpm
2 安装MySql服务器(root权限)
1.安装mysql服务端
[caimh@master-node mysql-libs]$ su - root
[root@master-node mysql-libs]# rpm -ivh MySQL-server-5.6.24-1.el6.x86_64.rpm
说明:如果安装出现依赖问题,可参看文章最后问题说明
2.查看产生的随机密码
[root@master-node mysql-libs]# cat /root/.mysql_secret
# The random password set for the root user at Wed Sep 25 12:57:41 2019 (local time): LQSdei5PL5Ei5cGa
3.查看mysql状态
[root@master-node mysql-libs]# sudo service mysql status
ERROR! MySQL is not running
4.启动mysql
[root@master-node mysql-libs]# sudo service mysql start
Starting MySQL. SUCCESS!
3 安装MySQL客户端
1.安装mysql客户端
[root@master-node mysql-libs]# rpm -ivh MySQL-client-5.6.24-1.el6.x86_64.rpm
2.连接mysql
[root@master-node mysql-libs]# mysql -uroot -pLQSdei5PL5Ei5cGa
3.修改密码
mysql> set password=password("111111");
4.退出mysql
mysql> quit
4 MySQL无主机登陆配置
配置只要是root用户+密码,在任何主机上都能登录MySQL数据库。
1.进入mysql
[root@master-node mysql-libs]# mysql -uroot -p111111
2.显示数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
3.使用mysql数据库
mysql> use mysql;
4.展示mysql数据库中的所有表
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| innodb_index_stats |
| innodb_table_stats |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| proxies_priv |
| servers |
| slave_master_info |
| slave_relay_log_info |
| slave_worker_info |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
28 rows in set (0.00 sec)
5.展示user表的结构
mysql> desc user;
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Reload_priv | enum('N','Y') | NO | | N | |
| Shutdown_priv | enum('N','Y') | NO | | N | |
| Process_priv | enum('N','Y') | NO | | N | |
| File_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Show_db_priv | enum('N','Y') | NO | | N | |
| Super_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Repl_slave_priv | enum('N','Y') | NO | | N | |
| Repl_client_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Create_user_priv | enum('N','Y') | NO | | N | |
| Event_priv | enum('N','Y') | NO | | N | |
| Trigger_priv | enum('N','Y') | NO | | N | |
| Create_tablespace_priv | enum('N','Y') | NO | | N | |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int(11) unsigned | NO | | 0 | |
| max_updates | int(11) unsigned | NO | | 0 | |
| max_connections | int(11) unsigned | NO | | 0 | |
| max_user_connections | int(11) unsigned | NO | | 0 | |
| plugin | char(64) | YES | | mysql_native_password | |
| authentication_string | text | YES | | NULL | |
| password_expired | enum('N','Y') | NO | | N | |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
43 rows in set (0.01 sec)
6.查询user表
mysql> select User,Host,Password from user;
+------+-------------+-------------------------------------------+
| User | Host | Password |
+------+-------------+-------------------------------------------+
| root | localhost | *FD571203974BA9AFE270FE62151AE967ECA5E0AA |
| root | master-node | *90A3D8DC56A3B7CBA4BBC47155143FD1672546EA |
| root | 127.0.0.1 | *90A3D8DC56A3B7CBA4BBC47155143FD1672546EA |
| root | ::1 | *90A3D8DC56A3B7CBA4BBC47155143FD1672546EA |
+------+-------------+-------------------------------------------+
4 rows in set (0.00 sec)
7.修改user表,把Host表内容修改为%
mysql> update user set Host="%" where Host="localhost";
8.删除root用户的其他host
mysql> delete from user where host="master-node";
mysql> delete from user where host="127.0.0.1";
mysql> delete from user where host="::1";
9.刷新
mysql> flush privileges;
10.退出
mysql> quit
5 问题
[root@master-node mysql-libs]# rpm -ivh MySQL-server-5.6.24-1.el6.x86_64.rpm
error: Failed dependencies:
libaio.so.1()(64bit) is needed by MySQL-server-5.6.24-1.el6.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.6.24-1.el6.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.6.24-1.el6.x86_64
在安装MySQL服务器,出现上面报错,需要安装依赖包,运行 yum install libaio 命令即可
[root@master-node mysql-libs]# yum -y install libaio