爱程序网

linux下 yum源、rpm、源代码安装mysql

来源: 阅读:

mysql的安装

一、yum源格式安装mysql

1、将下载的yum包上传到linux上:

[root@localhost ~]# lsmysql-community-release-el6-5.noarch.rpm 

2、列出rpm包中文件(查看哪些内容):

[root@localhost ~]# rpm -qpl mysql-community-release-el6-5.noarch.rpm /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql/etc/yum.repos.d/mysql-community-source.repo/etc/yum.repos.d/mysql-community.repo

3、安装rpm包(自动配置好yum源):

[root@localhost ~]# rpm -ivh mysql-community-release-el6-5.noarch.rpm Preparing... ########################################### [100%]1:mysql-community-release########################################### [100%]

4、安装mysql:

[root@localhost ~]# yum install mysql-community-server.x86_64 -yLoaded plugins: fastestmirror, refresh-packagekit, securityExisting lock /var/run/yum.pid: another copy is running as pid 2460.Another app is currently holding the yum lock; waiting for it to exit...  Verifying  : mysql-community-libs-5.6.29-2.el6.x86_64                                                                                                                                    5/8   Verifying  : 2:postfix-2.6.6-6.el6_7.1.x86_64                                                                                                                                            6/8   Verifying  : 2:postfix-2.6.6-2.2.el6_1.x86_64                                                                                                                                            7/8   Verifying  : mysql-libs-5.1.71-1.el6.x86_64                                                                                                                                              8/8 Installed:  mysql-community-libs.x86_64 0:5.6.29-2.el6                  mysql-community-libs-compat.x86_64 0:5.6.29-2.el6                  mysql-community-server.x86_64 0:5.6.29-2.el6             Dependency Installed:  mysql-community-client.x86_64 0:5.6.29-2.el6                                                   mysql-community-common.x86_64 0:5.6.29-2.el6                                            Dependency Updated:  postfix.x86_64 2:2.6.6-6.el6_7.1                                                                                                                                                        Replaced:  mysql-libs.x86_64 0:5.1.71-1.el6                                                                                                                                                             Complete!

5、是否安装了mysql:

[root@localhost ~]# rpm -qa | grep mysqlmysql-community-libs-5.6.29-2.el6.x86_64mysql-community-server-5.6.29-2.el6.x86_64mysql-community-client-5.6.29-2.el6.x86_64mysql-community-libs-compat-5.6.29-2.el6.x86_64mysql-community-release-el6-5.noarchmysql-community-common-5.6.29-2.el6.x86_64

6、接下来是初始化数据库:

[root@localhost ~]# mysql_install_db --datadir=/var/lib/mysql/Installing MySQL system tables...2016-03-15 11:00:50 0 [Warning] TIMESTAMP wi

7、更改数据库目录权限并启动mysql:

[root@localhost ~]# chown -R mysql:mysql /var/lib/mysql/[root@localhost ~]# ll -h /var/lib/mysql/总用量 109M-rw-rw----. 1 mysql mysql  12M 3月  15 11:00 ibdata1-rw-rw----. 1 mysql mysql  48M 3月  15 11:00 ib_logfile0-rw-rw----. 1 mysql mysql  48M 3月  15 11:00 ib_logfile1drwx------. 2 mysql mysql 4.0K 3月  15 11:00 mysqldrwx------. 2 mysql mysql 4.0K 3月  15 11:00 performance_schema[root@localhost ~]# /etc/init.d/mysqld start正在启动 mysqld:                                          [确定]

8、登录mysql并修改密码:

[root@localhost ~]# mysqlWelcome to the MySQL monitor.  Commands end with ; or g.Your MySQL connection id is 2Server version: 5.6.29 MySQL Community Server (GPL)Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.mysql> 

mysql> update mysql.user set password=password("123456")where user='root';
Query OK, 3 rows affected (0.11 sec)
Rows matched: 4 Changed: 3 Warnings: 0

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.04 sec)

  

二、RPM方式安装mysql:

1.将下载好的文件上传到Linux下:

[root@localhost Downloads]# ls
MySQL-5.6.16-1.el6.x86_64.rpm-bundle.tar

2、解压tar文件:

[root@localhost Downloads]# tar -xf MySQL-5.6.16-1.el6.x86_64.rpm-bundle.tar

[root@localhost Downloads]# ls
MySQL-client-5.6.16-1.el6.x86_64.rpm
MySQL-devel-5.6.16-1.el6.x86_64.rpm
MySQL-embedded-5.6.16-1.el6.x86_64.rpm
MySQL-server-5.6.16-1.el6.x86_64.rpm
MySQL-shared-5.6.16-1.el6.x86_64.rpm
MySQL-shared-compat-5.6.16-1.el6.x86_64.rpm
MySQL-test-5.6.16-1.el6.x86_64.rpm

3、安装rpm文件:

[root@localhost Downloads]# rpm -Uvh MySQL-*
Preparing... ########################################### [100%]
1:MySQL-devel ########################################### [ 14%]
2:MySQL-client ########################################### [ 29%]
3:MySQL-test ########################################### [ 43%]
4:MySQL-embedded ########################################### [ 57%]
5:MySQL-shared-compat ########################################### [ 71%]
6:MySQL-shared ########################################### [ 86%]
7:MySQL-server ########################################### [100%]

4、启动mysql服务:

[root@localhost mysql]# /etc/init.d/mysql start
Starting MySQL........ [ OK ]

 

关于爱程序网 - 联系我们 - 广告服务 - 友情链接 - 网站地图 - 版权声明 - 人才招聘 - 帮助