centos上安裝mysql/mariadb安裝gogs

標籤：應該   status   ip）   mct   itme   cst   prot   pts   pat   

最小安裝：1. 選擇English2. DATE & TIME 修改好本地時間   SOFTWARE SELECTION預設的Minimal Install就好   INSTALLATION DESTINATION選一下   然後，Begin Installation3. ROOT PASSWORD設定ROOT密碼   USER CREATION設定新使用者，勾選Make this user administrator   等待安裝完成，點Reboot按鈕。配置靜態IPv4：$ systemctl status NetworkManager.service檢查網路管理器服務狀態$ nmcli dev statusDEVICE  TYPE      STATE         CONNECTIONens33   ethernet  disconnected  --lo      loopback  unmanaged     --這裡需要配置ens33$ su# cd /etc/sysconfig/network-scripts# ls ifcfg*# vi ifcfg-ens33配置的ens33將 BOOTPROTO=dhcp 改為 BOOTPROTO=static然後在下行添加：IPADDR=192.168.48.128NETMASK=225.225.225.0NM_CONTROLLED=no將 ONBOOT=no 改為 ONBOOT=yes儲存退出vi（NM_CONTROLLED=no表示該介面通過該設定檔設定，而不是通過網路管理器）註：如果使用dhcp動態IP只要將 ONBOOT=no 改為 ONBOOT=yes 即可。# systemctl restart netowrk.service# ip add查看ip資訊配置光碟片為安裝源(註：後面有配置iso為安裝源的，這裡僅光碟片鏡像臨時作為安裝源使用)：$ sudo ssh 192.168.48.128 -l root# cat /etc/yum.repos.d/CentOS-Media.repo基本內容如下：[c7-media]name=CentOS-$releasever - Mediabaseurl=file:///media/CentOS/        file:///media/cdrom/        file:///media/cdrecorder/gpgcheck=1enabled=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7檔案頭的注釋部分提示可以用命令yum --enablerepo=c7-media [command]或者yum --disablerepo=\* --enablerepo=c7-media [command]安裝軟體。# ls /dev/cdrom# mkdir /media/cdrom# mount /dev/cdrom /media/cdrom掛載cdrom安裝vim、gcc、g++：# yum --disablerepo=\* --enablerepo=c7-media install vim -y# yum --disablerepo=\* --enablerepo=c7-media install gcc gcc-c++ -y安裝mysql 5.6：先將client和server兩個rpm安裝包複製到本機下載目錄，然後在mac終端輸入：$ sudo scp ~/Downloads/MySQL-*.rpm [email protected]:/home/bob/複製client和server安裝檔案到/home/bob/目錄下（註：也可以複製到其他目錄，比如[email protected]:/usr/local/）回到ssh：# rpm -qa|grep -i mariadb查詢mariadb，與mysql衝突，下面將查到的庫一併強制移除（最小安裝只有mariadb-libs）# rpm -e --nodeps mariadb-libs# groupadd -r mysql# useradd -g mysql mysql -d /home/mysql -s /sbin/nologin（註：mysql 5.7論壇版安裝順序是：common、libs、client、server）（注2：mariadb 10.2需要一些依賴：yum --disablerepo=\* --enablerepo=c7-media install lsof perl rsync boost perl-DBI -y   然後安裝順序是：galera、MariaDB-10.2.10-centos73-x86_64-*（放在同一目錄下：compat、common、client、server） ）# yum --disablerepo=\* --enablerepo=c7-media install perl -y# rpm -ivh ./MySQL-client-5.6.34-1.el7.x86_64.rpm# yum --disablerepo=\* --enablerepo=c7-media install autoconf -y# rpm -ivh ./MySQL-server-5.6.34-1.el7.x86_64.rpm# rm -f MySQL-*.rpm# systemctl start mysql.service（註：mysql 5.7的啟動服務是mysqld.service）（注2：mariadb 10.2啟動服務是mysqld.service，mariadb也可以）# cat /root/.mysql_secret The random password set for the root user at Tue Feb 21 13:55:26 2017 (local time): vZQwDJLbxm_zHno_（註：mysql 5.7的初始密碼在log檔案裡    $ grep "temporary password" /var/log/mysqld.log    然後在調用mysql_secure_installation前，手動修改安全性原則：    $ mysql -uroot -p    mysql> set global validate_password_policy=0;    mysql> set global validate_password_length=0;    mysql> exit    或者編輯 /etc/my.cnf    [mysqld]    validate_password=off）（注2：mariadb 10.2沒有初始密碼，可以通過下面命令將密碼設定為123456    /usr/bin/mysqladmin -u root password ‘123456‘）# /usr/bin/mysql_secure_installation把隨機密碼粘貼到提示符，根據提示，改變root密碼，移除匿名賬戶，禁用root遠程登入，移除測試資料庫，重新整理許可權。（註：mysql 5.7在設定了前面的密碼原則後，可能要多次輸入簡單的密碼來確認）# mysql -uroot -p建立新使用者：mysql> create user ‘bob‘@‘%‘ identified by ‘123456‘;(如果用root賬戶遠端連線：mysql> grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘;)mysql> flush privileges;mysql> exit# firewall-cmd --zone=public --add-port=3306/tcp --permanent# firewall-cmd --reload------ mysql emoji ------注意：utf8mb4的最低mysql版本支援版本為5.5.3+如果建立資料庫、表、列時指定utf8mb4和utf8mb4_general_ci，下面應該可以不用設定。1) 設定my.cnf$ sudo vim /etc/my.cnf（ubuntu的位置 /etc/mysql/my.cnf）[client]default-character-set=utf8mb4[mysql]default-character-set=utf8mb4[mysqld]character-set-client-handshake=FALSEcharacter-set-server=utf8mb4collation-server=utf8mb4_unicode_ciinit_connect=‘SET NAMES utf8mb4‘skip-name-resolve儲存後重啟mysql$ systemctl restart mysql$ mysql -uroot -pmysql> SHOW VARIABLES WHERE Variable_name LIKE ‘character_set_%‘ OR Variable_name LIKE ‘collation%‘;+--------------------------+----------------------------+| Variable_name            | Value                      |+--------------------------+----------------------------+| character_set_client     | utf8mb4                    || character_set_connection | utf8mb4                    || character_set_database   | utf8mb4                    || character_set_filesystem | binary                     || character_set_results    | utf8mb4                    || character_set_server     | utf8mb4                    || character_set_system     | utf8                       || character_sets_dir       | /usr/share/mysql/charsets/ || collation_connection     | utf8mb4_general_ci         || collation_database       | utf8mb4_unicode_ci         || collation_server         | utf8mb4_unicode_ci         |+--------------------------+----------------------------+11 rows in set註：collation_connection、collation_database、collation_server是utf8mb4_general_ci沒有關係。2) 修改Database、Table、Column字元集：ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;ALTER TABLE table_name CHANGE column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;修複最佳化表REPAIR TABLE table_name;OPTIMIZE TABLE table_name;也可以用mysqlcheck命令最佳化所有資料庫$ mysqlcheck -uroot -p --auto-repair --optimize --all-databases3) 對於Java來說mysql connector版本需高於5.1.13。安裝gogs：先將linux_amd64.zip包複製到本機下載目錄，然後在mac終端輸入：$ sudo scp ~/Downloads/linux_amd64.tar.gz [email protected]:/root/複製linux_amd64.tar.gz檔案到/root/目錄下（註：也可以複製到其他目錄，比如[email protected]:/usr/local/）回到ssh：# groupadd -r git# useradd -g git git -d /home/git# mv /root/linux_amd64.tar.gz /home/git/# chown git:git /home/git/linux_amd64.tar.gz（如果是zip檔案：yum --disablerepo=\* --enablerepo=c7-media install unzip -y）# su git$ cd ~$ tar xvfz linux_amd64.tar.gz（如果是zip檔案：unzip linux_amd64.zip）$ lsgogs  linux_amd64.tar.gz$ rm -f linux_amd64.tar.gz$ cd gogs$ chmod +x ./gogs$ cat ./scripts/mysql.sqlDROP DATABASE IF EXISTS gogs;CREATE DATABASE IF NOT EXISTS gogs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;$ mysql -uroot -p < scripts/mysql.sql$ mysql -uroot -pmysql> grant all privileges on gogs.* to ‘bob‘@‘%‘ identified by ‘123456‘;mysql> flush privileges;mysql> exit$ exit# cp /home/git/gogs/scripts/systemd/gogs.service /etc/systemd/system/# cat /etc/systemd/system/gogs.service[Unit]Description=GogsAfter=syslog.targetAfter=network.targetAfter=mariadb.service mysqld.service postgresql.service memcached.service redis.service[Service]# Modify these two values and uncomment them if you have# repos with lots of files and get an HTTP error 500 because# of that####LimitMEMLOCK=infinity#LimitNOFILE=65535Type=simpleUser=gitGroup=gitWorkingDirectory=/home/git/gogsExecStart=/home/git/gogs/gogs webRestart=alwaysEnvironment=USER=git HOME=/home/git[Install]WantedBy=multi-user.target啟動服務，配置防火牆# systemctl start gogs.service# systemctl enable gogs.service# firewall-cmd --zone=public --add-port=3000/tcp --permanent# firewall-cmd --reload（ubuntu系統配置防火牆命令：  sudo ufw allow 3000  sudo ufw enable）然後在瀏覽器開啟http://192.168.48.128:3000（注2：mariadb配置好後，主機也許不能用127.0.0.1串連，請用主機ip：192.168.48.128）註：如果開啟了selinux，可能需要關閉。# vim /etc/sysconfig/selinux將SELINUX=enforce改為disabled需要重啟。無法使用ssh進行clone和push資料如果http方式沒問題，就是應為gogs的賬戶（這裡是git賬戶）沒有指定shell，解決辦法是：# cat /etc/shells/bin/sh/bin/bash...# usermod -s /bin/bash git升級gogs$ sudo service gogs stop$ sudo su - git$ cd ~$ pwd/home/git$ lsgogs gogs-repositories$ mv gogs gogs_old$ wget https://dl.gogs.io/gogs_v$VERSION_$OS_$ARCH.tar.gz$ tar -zxvf gogs_v$VERSION_$OS_$ARCH.tar.gz$ lsgogs gogs_old gogs-repositories gogs_v$VERSION_$OS_$ARCH.tar.gz$ cp -R gogs_old/custom gogs$ cp -R gogs_old/data gogs$ cp -R gogs_old/log gogs$ sudo service gogs start如果啟動失敗，可能是許可權的問題：# chmod +x /home/git/gogs/gogs# chown -R git:git /home/git/gogs# service gogs start--------------------------sudo$ su# vim /etc/sudoers在 root  ALL=(ALL) ALL後面添加相同一行，新行的root改成目前使用者，然後w!寫入，退出vim# exit$ 就可以了。啟動到命令列介面graphical.target to multi-user.target $ systemctl get-default graphical.target$ sudo systemctl set-default multi-user.target Removed symlink /etc/systemd/system/default.target.Created symlink from /etc/systemd/system/default.target to /usr/lib/systemd/system/multi-user.target.$ sudo reboot// boot to graphical desktop$ startx更改所有權chown -R youruser:youruser /home/youruser/*更換shell# cat /etc/shells# echo $SHELL# usermod -s /sbin/nologin youruser# usermod -s /sbin/bash youruser設定iso作為安裝源查看網址# ip add遠程拷貝$ scp ~/Desktop/CentOS-7-x86_64-Everything-1611.iso [email protected]:/usr/local/遠程登入$ ssh 192.168.48.128 -l root移動檔案到/usr/local/iso# mkdir /usr/local/iso# mv /usr/local/CentOS-7-x86_64-Everything-1611.iso /usr/local/iso/修改fstab，掛著iso到/mnt/centiso# vi /etc/fstab追加：/usr/local/iso/CentOS-7-x86_64-Everything-1611.iso /mnt/centiso iso9660 defaults,ro,loop 0 0建立掛載點並掛載：# mkdir /mnt/centiso# mount -a# ls /mnt/centisoCentOS_BuildTag  EFI  EULA  GPL  images  isolinux  LiveOS  Packages  repodata  RPM-GPG-KEY-CentOS-7  RPM-GPG-KEY-CentOS-Testing-7  TRANS.TBL記住這裡面的GPG-KEY的檔案，將用在yum配置源上查看yum源# ls /etc/yum.repos.d/CentOS-Base.repo  CentOS-Debuginfo.repo  CentOS-Media.repo    CentOS-Vault.repoCentOS-CR.repo    CentOS-fasttrack.repo  CentOS-Sources.repo建立一個cdrom.repo# vi cdrom.repo[CDROM]name=centisobaseurl=file:///mnt/centisoenabled=1gpgcheck=0gkgkey=file///mnt/centiso/RPM-GPG-KEY-CentOS-7檢查安裝源# yum list gccLoaded plugins: fastestmirrorCDROM                                                    | 3.6 kB     00:00base                                                     | 3.6 kB     00:00...可以看見CDROM安裝源安裝vim# yum install vim

 

centos上安裝mysql/mariadb安裝gogs