mysql安装development_mysql 安装

这里使用的mysql是 mysql-5.7.16

将下载下来的mysql 安装tar包下载解压这就不用多说了，

ps:(mysql-5.7.16-linux-glibc2.5-x86_64 这名字太长了，我把他改为mysql-5.7.16)

首先

(1)配置环境变量

############mysql#############

export PATH=$PATH:/usr/local/development/mysql/mysql-5.7.16/bin

(2)新增mysql的用户和组

[root@node1 development]# groupadd mysql

[root@node1 development]# useradd -r -g mysql mysql

//修改mysql的目录权限

[root@node1 development]# chown -R mysql mysql /usr/local/development/mysql/mysql-5.7.16/

(3)修改mysql安装目录中的   support-files/mysql.server 文件，设置mysql的安装目录 和 mysql的数据存储目录

# If you want to affect other MySQL variables, you should make your changes

# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.

# If you change base dir, you must also change datadir. These may get

# overwritten by settings in the MySQL configuration files.

//mysql的安装目录

basedir=/usr/local/development/mysql/mysql-5.7.16

//mysql的数据存储目录

datadir=/usr/local/development/mysql/mysqlData

(4)初始化数据库

[root@node1 bin]# ./mysql_install_db --user=mysql --basedir=/usr/local/development/mysql/mysql-5.7.16 --datadir=/usr/local/development/mysql/mysqlData

2017-06-05 17:44:50 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize

2017-06-05 17:44:55 [WARNING] The bootstrap log isn't empty:

2017-06-05 17:44:55 [WARNING] 2017-06-05T09:44:51.057443Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead

2017-06-05T09:44:51.075095Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)

2017-06-05T09:44:51.075137Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)

我们的MySQL存储目录已经生成数据了

(5)启动MySQL(发现报错)

[root@node1 support-files]# ./mysql.server start

Starting MySQL.touch: cannot touch ‘/var/log/mariadb/mariadb.log’: No such file or directory

chmod: cannot access ‘/var/log/mariadb/mariadb.log’: No such file or directory

touch: cannot touch ‘/var/log/mariadb/mariadb.log’: No such file or directory

chown: cannot access ‘/var/log/mariadb/mariadb.log’: No such file or directory

/usr/local/development/mysql/mysql-5.7.16/bin/mysqld_safe: line 135: /var/log/mariadb/mariadb.log: No such file or directory

/usr/local/development/mysql/mysql-5.7.16/bin/mysqld_safe: line 169: /var/log/mariadb/mariadb.log: No such file or directory

touch: cannot touch ‘/var/log/mariadb/mariadb.log’: No such file or directory

chown: cannot access ‘/var/log/mariadb/mariadb.log’: No such file or directory

chmod: cannot access ‘/var/log/mariadb/mariadb.log’: No such file or directory

/usr/local/development/mysql/mysql-5.7.16/bin/mysqld_safe: line 135: /var/log/mariadb/mariadb.log: No such file or directory

ERROR! The server quit without updating PID file (/usr/local/development/mysql/mysqlData/node1.pid).

我们确实是没有/var/log/mariadb/mariadb.log 这个目录，这个是因为你没有指定他的配置文件的话，他会默认找到/etc/my.cnf 这个配置文件，因为我们修改了mysql的数据存储目录。

将/etc/my.cnf 删掉，再次启动

[root@node1 support-files]# rm -f /etc/my.cnf

[root@node1 support-files]# ./mysql.server start

Starting MySQL.. SUCCESS!

(6)查询MySQL自动生成的root密码

[root@node1 support-files]# more /root/.mysql_secret

# Password set for user 'root@localhost' at 2017-06-05 17:44:50

N5*gFyur1LbC //这里就是

(7)在bin目录下 登录MySQL(将自动生成的密码粘贴上去即可)

[root@node1 bin]# ./mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.16

Copyright (c) 2000, 2016, 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.

(8)修改MySQL的root密码(你肯定不想使用自动生成的那个密码吧)

mysql> set password=password('mysql123');//设置密码

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> alter user 'root'@'localhost' password expire never//将密码应用于root用户

-> ;

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges//刷新权限的列表

-> ;

Query OK, 0 rows affected (0.00 sec)

mysql> exit//退出

Bye

重新登录，试一试刚才修改的密码是否生效，当然你们是看不见输入密码的，我这里已经生效了

上面是MySQL的搭建过程，我是使用MySQL来存储hive的元数据，而MySQL不允许使用root用户远程登录，所以我新建hive用户

mysql> create user 'hive'@'%' identified by 'hive123';//创建用户名和密码

Query OK, 0 rows affected (0.00 sec)

mysql> grant all on *.* to 'hive'@'%';//赋予hive用户所有权限，'%'表示任何地址都可以通过hive用户连接mysql，如果你想限制可以加入你的ip

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;//刷新权限列表

Query OK, 0 rows affected (0.00 sec)

mysql> create database hivedb;//创建数据库

Query OK, 1 row affected (0.00 sec)

查看创建的数据库

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| hivedb |

| mysql |

| performance_schema |

| sys |

+--------------------+