程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> mysql在linux上的安裝之一yum安裝

mysql在linux上的安裝之一yum安裝

編輯:MySQL綜合教程

mysql在linux上的安裝之一yum安裝


mysql的安裝無非以下幾種,其中yum安裝也是rpm安裝中的一種,只不過這種不需要再單獨下載安裝包,直接根據操作系統自帶的mysql包進行安裝,比較簡單,本篇主要對yum進行講解,後續會對其它幾種方式進行總結。

目前的安裝方式

1,rpm 安裝

2,二進制安裝

3,源碼安裝

4,yum安裝

yum方式安裝

1. 安裝操作系統


1.1安裝Red Hat Enterprise Linux 6.2 (64-bit)
arch: x86_64
1.2. 關閉selinux vi /etc/selinux/config

1.3. service iptables stop 臨時關閉防火牆


2 安裝數據庫MySQL
2.1掛載Redhat鏡像文件 ftp://192.168.0.212/pub/iso/rhel6.2/,命令如下
#mkdir -p /mnt/iso
#mkdir -p /mnt/redhat5.5
# mount 192.168.0.212:/var/ftp/pub/iso/rhel5.5/ /mnt/iso/
# mount -t iso9660 -o loop rhel-server-5.5-x86_64-dvd.iso /mnt/redhat5.5/
2.2 配置yum
# cd /etc/yum.repos.d/
# cp rhel-debuginfo.repo rhel-debuginfo.repo_bak
# vi rhel-debuginfo.repo

[rhel-debuginfo]
name=Red Hat Enterprise Linux $releasever - $basearch - Debug
baseurl=file:///mnt/redhat5.5/Server
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release





[oracle@Redhat5 yum.repos.d]$ ls
el5u5.repo el5u8.repo rhel-debuginfo.repo
[oracle@Redhat5 yum.repos.d]$ cat el5u8.repo
[Server]
name=Red Hat Enterprise Linux 5 update 8
baseurl=ftp://192.168.0.212/pub/src/RHEL5U8/x64/Server
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
[VT]
name=Red Hat Enterprise Linux 5 update 8
baseurl=ftp://192.168.0.212/pub/src/RHEL5U8/x64/VT
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
[Cluster]
name=Red Hat Enterprise Linux 5 update 8
baseurl=ftp://192.168.0.212/pub/src/RHEL5U8/x64/Cluster
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
[ClusterStorage]
name=Red Hat Enterprise Linux 5 update 8
baseurl=ftp://192.168.0.212/pub/src/RHEL5U8/x64/ClusterStorage
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
2.3根據需求創建mysql數據存儲目錄
# mkdir /mysqldata
2.4 yum安裝mysql,mysql-server
# yum install mysql mysql-server
2.5 修改mysql配置文件
# vi /etc/my.cnf
[mysqld]
datadir=/data/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
default-character-set=utf8

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

lower_case_table_names=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql]
default-character-set=utf8


2.6啟動mysql,同時添加mysql自動啟動
# /etc/rc.d/init.d/mysqld start
# chkconfig mysqld on
# chkconfig --list mysqld

2.7 修改mysql密碼
# mysql -u root
/usr/bin/mysqladmin -u root password 123456

mysql> grant all on mysql.* to 'root'@'localhost' identified by 'mysql8895'
mysql> source /opt/MYSQL.sql 導入數據
mysql> exit

建立用戶:

mysql> grant all on dcs.* to "ligang"@"%" identified by "dcsA99ligang";

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved