ITPub博客

首页 > 数据库 > MySQL > mysql安装

mysql安装

原创 MySQL 作者:csyf_6 时间:2018-01-21 22:39:25 0 删除 编辑
1.环境介绍
OS: Redhat Linuix 6.5
MySQL: mysql-5.7.21-1.el6.x86_64.rpm-bundle.tar

2.系统设置
2.1 selinuix修改
[root@localhost mysql]# vi  /etc/selinux/config 
SELINUX=disabled


3.检查系统中是否带有mysql
[root@localhost soft]# rpm -qa| grep mysql
mysql-libs-5.1.71-1.el6.x86_64
[root@localhost soft]# rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64

4.安装
[root@localhost mysql]# tar -xvf mysql-5.7.21-1.el6.x86_64.rpm-bundle.tar 
mysql-community-libs-5.7.21-1.el6.x86_64.rpm
mysql-community-devel-5.7.21-1.el6.x86_64.rpm
mysql-community-server-5.7.21-1.el6.x86_64.rpm
mysql-community-test-5.7.21-1.el6.x86_64.rpm
mysql-community-embedded-5.7.21-1.el6.x86_64.rpm
mysql-community-client-5.7.21-1.el6.x86_64.rpm
mysql-community-libs-compat-5.7.21-1.el6.x86_64.rpm
mysql-community-common-5.7.21-1.el6.x86_64.rpm
mysql-community-embedded-devel-5.7.21-1.el6.x86_64.rpm

--使用nodeps避免包冲突
rpm -ivh   mysql-community-server-5.7.21-1.el6.x86_64.rpm  --nodeps
rpm -ivh   mysql-community-client-5.7.21-1.el6.x86_64.rpm  --nodeps
rpm -ivh   mysql-community-common-5.7.21-1.el6.x86_64.rpm  --nodeps
rpm -ivh mysql-community-devel-5.7.21-1.el6.x86_64.rpm                   --nodeps
rpm -ivh mysql-community-embedded-5.7.21-1.el6.x86_64.rpm                --nodeps
rpm -ivh mysql-community-embedded-devel-5.7.21-1.el6.x86_64.rpm          --nodeps
rpm -ivh mysql-community-libs-5.7.21-1.el6.x86_64.rpm                    --nodeps
rpm -ivh mysql-community-libs-compat-5.7.21-1.el6.x86_64.rpm             --nodeps
rpm -ivh mysql-community-test-5.7.21-1.el6.x86_64.rpm                    --nodeps

--启动mysql
[root@localhost soft]# mkdir -p /mysql/data
[root@localhost soft]# mkdir -p /mysql/log/
[root@localhost soft]# mkdir -p /mysql/run/mysqld

[root@localhost soft]# vi  /etc/my.cnf
datadir=/mysql/data
socket=/mysql/mysql.sock
log-error=/mysql/log/mysqld.log
pid-file=/mysql/run/mysqld/mysqld.pid

[root@localhost log]# /etc/init.d/mysqld  start
Initializing MySQL database:                               [  OK  ]
Starting mysqld:                                           [  OK  ]

5.mysql安全设置
5.1 查看密码
[root@localhost log]#  cat mysqld.log | grep password
2018-01-21T13:27:36.164705Z 1 [Note] A temporary password is generated for root@localhost: T&DH+Ij*H9kd

5.2.安全设置  
[root@localhost log]#  /usr/bin/mysql_secure_installation 
Enter password for user root: 
The existing password for the user account root has expired. Please set a new password.
New password: 

5.3 登录成功
[root@localhost log]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 5.7.21 MySQL Community Server (GPL)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.02 sec)







来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29132283/viewspace-2150368/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: mysql多实例安装
请登录后发表评论 登录
全部评论

注册时间:2015-10-20

  • 博文量
    6
  • 访问量
    8909