本文主要给大家展示“如何安装mysql”，简单易懂，组织清晰，希望能帮你解决疑惑。让边肖带领大家学习《如何安装mysql》一文。
首先，下载安装包
1.下载hivehttp://mirrors.hust.edu.cn/apache/获取apache-hive-1.1.0.tar.gz并将其放入目录/主页/
2.下载MySQL https://dev.mysql.com/downloads/file/? Id=471503获取
我的linux版本是6.8。下载时最好选择glib版本。如果下载其他组合包，会出现各种依赖提示，比较麻烦。
复制到此目录/mysql/
第二，安装mysql
1.卸载系统附带的mysql相关安装包，并且只卸载以mysql开头的包。
rpm -qa | grep -i mysql
rpm-ev MySQL-community-libs-5 . 7 . 19-1 . El 7 . x86 _ 64
-基站
2.创建用户和组
groupadd mysql
useradd -r -g mysql mysql
3.装置
解压缩tar -zxvf
MySQL-5 . 7 . 19-Linux-glibc 2.12-x86 _ 64 . tar . gz-C./usr/local
修改目录[root@hadoop local]# mv
MySQL-5 . 7 . 19-Linux-glibc 2.12-x86 _ 64/MySQL
添加[root@hadoop mysql]# chown -R
mysql.mysql /usr/local/mysql
创建新的数据目录[root@hadoop mysql]# mkdir数据
4.安装。/bin/MySQL d-initialize-user=MySQL
-basedir=/usr/local/MySQL-datadir=/usr/local/MySQL/data
注意最后一行，也和它的版本不一样。它给root用户一个初始密码。这个root是mysql的root用户，以后登录时会用到这个密码。#H#？*Els4G
4.将mysql/目录中除数据/目录外的所有文件改回root用户，mysql用户只需要是MySQL/数据/目录中所有文件的所有者。
[root@hadoop mysql]# chown -R root。
[root@hadoop mysql]# chown -R mysq
l data
5.创建tmp文件夹，并授权
[root@hadoop mysql]# mkdir tmp
[root@hadoop mysql]# chown -R mysql:mysql tmp
6.复制并编辑配置文件
[root@hadoop etc]# cp my.cnf.rpmsave my.cnf
[root@hadoop etc]# vi my.cnf
7.添加以下内容
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
socket = /usr/local/mysql/tmp/mysql.sock
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
8.将mysql.server拷贝到/etc/init.d/mysql
[root@hadoop support-files]# cp mysql.server
/etc/init.d/mysql
[root@hadoop init.d]# chmod +x mysql
9.把mysql注册为开机启动的服务
[root@hadoop init.d]# chkconfig --add mysql
[root@hadoop init.d]# chkconfig --list mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
10.启动
[root@hadoop init.d]# /etc/init.d/mysql start
Starting MySQL.Logging to
'/usr/local/mysql/data/hadoop.err'.
. [ OK ]
11.修改环境变量
export PATH=$PATH:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:/usr/local/mysql:/usr/local/mysql/bin
[root@hadoop init.d]# source /etc/profile
12.使用root登录时报错
[root@hadoop init.d]# mysql -uroot -p #H#,?*Els4G&
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (2)
13.修改 /etc/my.cnf文件，补充mysql和client配置
[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
socket = /usr/local/mysql/tmp/mysql.sock
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
skip-grant-tables
[mysql]
default-character-set=utf8
socket = /usr/local/mysql/tmp/mysql.sock
[client]
default-character-set=utf8
socket = /usr/local/mysql/tmp/mysql.sock
14.重新登录,并输入新密码
[root@hadoop etc]# mysql -uroot -p #H#,?*Els4G&
Enter password: mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, 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>
15.mysql服务的开启和关闭
#/etc/init.d/mysql start 或者 serivce mysql start 或者 bin/mysqld_safe&
#/etc/init.d/mysql stop 或者 service mysql stop 或者 bin/mysqladmin -uroot -p
三、添加hive用户，会提示如下错误
mysql> create user 'hive'@'%' identified by 'hive';
ERROR 1290 (HY000): The MySQL server is running with
the --skip-grant-tables option so it cannot execute this statement
强制写出
mysql> flush privileges;
重新执行
mysql> create user 'hive'@'%' identified by 'hive';
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user from user;
+-----------+---------------+
| host |
user |
+-----------+---------------+
| % |
hive |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+---------------+
4 rows in set (0.00 sec)
以上是“mysql怎么样进行安装”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注行业资讯频道！
内容来源网络，如有侵权，联系删除，本文地址：https://www.230890.com/zhan/153416.html