Mysql 011安装指南

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

1. 检查本地资源库中是否有mysql的rpm包
    rpm -qa | grep mysql
    # 删除相关rpm包
    rpm -ev <rpm包名> --nodeps
2. 搭建mysql5.7的yum源
    # 下载mysql5.7的rpm包
    wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
    # 安装第一步下载的rpm文件，安装成功后/etc/yum.repos.d/目录下会增加两个文件
    yum -y install mysql57-community-release-el7-11.noarch.rpm
    # 查看mysql57的安装源是否可用，如不可用请自行修改配置文件
    （/etc/yum.repos.d/mysql-community.repo）使mysql57下面的enable=1
    # 若有mysql其它版本的安装源可用，也请自行修改配置文件使其enable=0
    yum repolist enabled | grep mysql
    # 安装mysql client
    yum install mysql-community-client.x86_64 -y
    # 如果没有mysql服务器，可以安装mysql服务器
    yum install mysql-community-server
    修改/etc/my.cnf文件，mysql的配置文件，设置mysql编码使用utf8mb4 utf8mb4_bin,
        default-character-set = utf8mb4    
        character-set-client-handshake = FALSE  
        character-set-server = utf8mb4  
        collation-server = utf8mb4_unicode_ci  
        init_connect='SET NAMES utf8mb4'
        lower_case_table_names = 1
    设置不区分大小写
    lower_case_table_names = 1
    # 启动mysql服务
    service mysqld start
    # 查看root密码
    grep "password" /var/log/mysqld.log
    # 登陆mysql
    mysql -u root -p
    Enter password: 
    # 为了可以设置简单密码
    set global validate_password_policy=0;
    set global validate_password_length=4;
    # 立即修改密码，执行其他操作报错：
    SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
    # 我们创建密码为root123
    groupadd mysql
    useradd -g mysql mysql

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17

create database ambari default charset=utf8;
grant all privileges on ambari.* to 'ambari'@'%' identified by 'ambari9898';

create database ambari_hive default charset=utf8;
grant all privileges on ambari_hive.* to 'ambari_hive'@'%' identified by 'ambari_hive9898';

create database ambari_oozie default charset=utf8;
grant all privileges on ambari_oozie.* to 'ambari_oozie'@'%' identified by 'ambari_oozie9898';

create database ambari_ranger_admin_db default charset=utf8;
grant all privileges on ambari_ranger_admin_db.* to 'ambari_ranger_admin_db'@'%' identified by 'ambari_ranger_admin_db9898';
       

create database ambari_hue default charset=utf8;
grant all privileges on ambari_hue.* to 'ambari_hue'@'%' identified by 'ambari_hue9898';

flush privileges;

1
2
3
4
5
6
7
8
9

只要原因是没有安装:libmysqlclient-dev
sudo yum install mysql-devel
找到mysql_config文件的路径
sudo updatedb
locate mysql_config
mysql_config的位置为：/usr/bin/mysql_config
在mysql-python源码包下找到：setup_posix.py 文件，
然后找到文件中的 mysql_config.path 将其值改为：/usr/bin/mysql_config,
然后 sudo python setup.py install ,就ok了