linux下安装mysql数据库

linux下安装mysql

下载安装包

上传安装包到服务器上

解压安装

1、解压到user/local下

tar vxf mysql-5.7.14-1.el6.x86_64.rpm-bundle.tar -C /usr/local

2、依次执行一下命令：

[root@josen local]# sudo rpm -ivh --force mysql-community-common-5.7.14-1.el6.x86_64.rpm
warning: mysql-community-common-5.7.14-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-common ########################################### [100%]
[root@josen local]# sudo rpm -ivh --force mysql-community-libs-5.7.14-1.el6.x86_64.rpm 
warning: mysql-community-libs-5.7.14-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-libs   ########################################### [100%]
[root@josen local]# sudo rpm -ivh --force mysql-community-client-5.7.14-1.el6.x86_64.rpm 
warning: mysql-community-client-5.7.14-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-client ########################################### [100%]
[root@josen local]# sudo rpm -ivh --force mysql-community-server-5.7.14-1.el6.x86_64.rpm 
warning: mysql-community-server-5.7.14-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-server ########################################### [100%]
[root@josen local]# 

3、 启动mysql

[root@josen ~]# sudo service mysqld start
Initializing MySQL database:                               [  OK  ]
Installing validate password plugin:                       [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@josen ~]# 

4、查看启动日志信息，获取临时登录密码

[root@josen ~]# cat /var/log/mysqld.log

2018-11-09T13:55:28.837175Z 1 [Note] A temporary password is generated for root@localhost: O:ux%=Oxr17d

5、用临时密码登录

[root@josen ~]# mysql -uroot -p
Enter password: 

6、修改临时登录密码：

mysql> SET PASSWORD = PASSWORD('O:ux%=Oxr17e');
Query OK, 0 rows affected, 1 warning (0.00 sec)

7、查看数据库：

show databases;

8、创建数据库：

mysql> create database cmu;
Query OK, 1 row affected (0.00 sec)

9、进入数据库；

use cmu