linux--mariadb資料庫

標籤：mariadb discuz

一、安裝登陸
1.安裝並開啟服務
yum install mariadb-server.x86_64
systemctl start mariadb

2.安全初始化
   ） 預設情況下，資料庫的網路介面時開啟的
     為了安全需要關閉此介面
netstat -antple | grep mysql 
圖示：網路介面
650) this.width=650;" src="https://s5.51cto.com/oss/201711/21/f2958d2dc41c7f88f39b3a97221cc128.png-wh_500x0-wm_3-wmp_4-s_2827758384.png" title="Screenshot from 2017-11-21 13-44-34.png" alt="f2958d2dc41c7f88f39b3a97221cc128.png-wh_" />
vim /etc/my.cnf
10   skip-networking=1             
systemctl restart mariadb.service
圖示：關閉介面
650) this.width=650;" src="https://s2.51cto.com/oss/201711/21/d5cdb81d4aa19606b48658225d86f617.png-wh_500x0-wm_3-wmp_4-s_3846402537.png" title="Screenshot from 2017-11-21 13-39-55.png" alt="d5cdb81d4aa19606b48658225d86f617.png-wh_" />
  ）資料庫初始狀態設定資訊時不安全的的，需要做以下設定
mysql_secure_installation
mysql -uroot -p
Enter password:
圖示：可以直接進去

650) this.width=650;" src="https://s2.51cto.com/oss/201711/21/dc32941f423aba489db9c35f4d7b0edc.png-wh_500x0-wm_3-wmp_4-s_3598975230.png" title="Screenshot from 2017-11-21 13-46-42.png" alt="dc32941f423aba489db9c35f4d7b0edc.png-wh_" />

圖示：加密以後進不去

650) this.width=650;" src="https://s5.51cto.com/oss/201711/21/f0648a6878a2c493da8b79c75c244d00.png-wh_500x0-wm_3-wmp_4-s_1677917775.png" title="Screenshot from 2017-11-21 13-48-07.png" alt="f0648a6878a2c493da8b79c75c244d00.png-wh_" />

圖示：輸入密碼以後可以進入

3.密碼的管理
）修改密碼
mysqladmin -uroot -pwestos password lee
測試：
mysql -uroot -plee
圖示：-p密碼可以直接進去
650) this.width=650;" src="https://s2.51cto.com/oss/201711/21/50e2884b15d938da301129cdb81589b2.png-wh_500x0-wm_3-wmp_4-s_1534550496.png" title="Screenshot from 2017-11-21 13-52-20.png" alt="50e2884b15d938da301129cdb81589b2.png-wh_" />
）當超級使用者密碼忘記時：
systemctl stop mariadb
mysqld_safe --skip-grant-tables &
mysql
update mysql.user set Password=password(‘westos‘)where User=‘root‘-->;
ps aux | grep mysql
kill -9 mysql的所有進程id
systemctl start mariadb

圖示：mysql的所有進程ID

650) this.width=650;" src="https://s4.51cto.com/oss/201711/21/2910e2a67983f55fbc6cf3181146c752.png-wh_500x0-wm_3-wmp_4-s_1687083716.png" title="Screenshot from 2017-11-21 15-41-15.png" alt="2910e2a67983f55fbc6cf3181146c752.png-wh_" />

圖示：直接進入後台修改密碼

650) this.width=650;" src="https://s2.51cto.com/oss/201711/21/c58ec7db3a5e489d13c68cddf975529e.png-wh_500x0-wm_3-wmp_4-s_2754432021.png" title="Screenshot from 2017-11-21 13-54-57.png" alt="c58ec7db3a5e489d13c68cddf975529e.png-wh_" />

測試：
mysql -uroot -pwestos
圖示：測試成功
650) this.width=650;" src="https://s1.51cto.com/oss/201711/21/2ffea9feefab047ef44093476de8dbf4.png-wh_500x0-wm_3-wmp_4-s_1785617608.png" title="Screenshot from 2017-11-21 14-01-06.png" alt="2ffea9feefab047ef44093476de8dbf4.png-wh_" />
二、mysql使用命令
1.資料庫的管理
）建立
mysql -uroot -p
SHOW DATABASES;            ##列出庫
CREATE DATABASE westos;          ##建立庫
USE westos;                  ##建立表
CREATE TABLE linux (
    -> username varchar(50) notnull,
    -> password varchar(50) notnull
    -> );
DESC  linux;                  ##查看錶結構
INSERT INTO lee VALUES (‘lee‘,‘123‘);       ##插入資料到lee表中
SELECT * FROM lee;                    ##查詢所有欄位在lee表中
SELECT username,password from linux;        ##查詢指定欄位在lee表中
圖示：列出庫

650) this.width=650;" src="https://s4.51cto.com/oss/201711/21/4da0a81512dd141d95f27d1c0236a2db.png-wh_500x0-wm_3-wmp_4-s_1906821235.png" title="Screenshot from 2017-11-21 14-44-53.png" alt="4da0a81512dd141d95f27d1c0236a2db.png-wh_" />
圖示：查看錶結構

650) this.width=650;" src="https://s2.51cto.com/oss/201711/21/c7fb22f78fc0718365af850979282a4f.png-wh_500x0-wm_3-wmp_4-s_1567787221.png" title="Screenshot from 2017-11-21 15-20-10.png" alt="c7fb22f78fc0718365af850979282a4f.png-wh_" />
圖示：查詢所有欄位在lee表中

）更改
UPDATE Linux SET password=password(‘lee‘) where username=‘lee‘;
ALTER TABLE linux ADD class varchar(20);              
ALTER TABLE linux DROP CLASS;
ALTER TABLE linux ADD age varchar(20) AFTER password;
ALTER TABLE linux RENAME redhat;
圖示：更改

650) this.width=650;" src="https://s4.51cto.com/oss/201711/21/28077e19532dc4129782d41015554839.png-wh_500x0-wm_3-wmp_4-s_4015972444.png" title="Screenshot from 2017-11-21 15-32-00.png" alt="28077e19532dc4129782d41015554839.png-wh_" />
）刪除
SELECT username,password from lee;         ##查看使用者，密碼           
DELETE FROM redhat where username=‘lee‘;     ##刪除使用者
DROP TABLE redhat;                    ##刪除表
DROP DATABASE westos;                  ##刪除庫
ALTER TABLE linux ADD class varchar(20);

圖示:刪除表

650) this.width=650;" src="http://img.blog.csdn.net/20170517170508138?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvTG9yaV9qaXNodW1lbmcxMjM=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" style="border:0px;vertical-align:middle;" />

圖示:刪除庫

650) this.width=650;" src="http://img.blog.csdn.net/20170517170519889?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvTG9yaV9qaXNodW1lbmcxMjM=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" style="border:0px;vertical-align:middle;" />

圖示:刪除欄位

650) this.width=650;" src="http://img.blog.csdn.net/20170517170610390?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvTG9yaV9qaXNodW1lbmcxMjM=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" style="border:0px;vertical-align:middle;" />

圖示：刪除表內資訊

650) this.width=650;" src="http://img.blog.csdn.net/20170517170623123?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvTG9yaV9qaXNodW1lbmcxMjM=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" style="border:0px;vertical-align:middle;" />）使用者授權

CREATE USER [email protected]‘localhost‘ identified by ‘westos‘;  ##建立使用者身份
GRANT SELECT,INSERT on westos.* TO [email protected];    ##授權
SHOW GRANTS FOR [email protected];                 ##查看授權
REVOKE INSERT ON westos.* FROM [email protected];       ##撤銷授權
圖示:查看授權
650) this.width=650;" src="https://s3.51cto.com/oss/201711/21/8ad84d1a93e4c7dd2ea6c26b5c81f3cd.png-wh_500x0-wm_3-wmp_4-s_3424718949.png" title="Screenshot from 2017-11-21 15-36-08.png" alt="8ad84d1a93e4c7dd2ea6c26b5c81f3cd.png-wh_" />

2.資料庫的備份

mysqldump -uroot -pwestos westos > /mnt/westos.sql
mysqldump -uroot -pwestos westos --no-data
mysqldump -uroot -pwestos --all-database
mysqldump -uroot -pwestos --all-database --no-data
圖示:備份
650) this.width=650;" src="https://s1.51cto.com/oss/201711/21/f5ac7b8cccf8467e44a6caf71cf70750.png-wh_500x0-wm_3-wmp_4-s_2652627130.png" title="Screenshot from 2017-11-21 15-42-31.png" alt="f5ac7b8cccf8467e44a6caf71cf70750.png-wh_" />
恢複方式1
mysql -uroot -pwestos -e "CREATE DATABASE westos;"
mysql -uroot -pwestos westos < /mnt/westos.sql
恢複方式2
vim /mnt/westos.sql
CREATE DATABASE westos;
USE westos;
mysql -uroot -pwestos < /mnt/westos.sql
圖示：修改配置

650) this.width=650;" src="https://s5.51cto.com/oss/201711/21/def932e6b4c0589744d5d885db6c5d14.png-wh_500x0-wm_3-wmp_4-s_3667618316.png" title="Screenshot from 2017-11-21 15-54-50.png" alt="def932e6b4c0589744d5d885db6c5d14.png-wh_" />

三、安裝phpmyadmin 資料庫圖形管理
1.下載phpMyAdmin
2.yum install php php-mysql -y
3.systemctl restart httpd
4.cp -rp phpMyAdmin-3.4.0-all-languages.tar.bz2 /var/www/html/
5.tar jxf phpMyAdmin-3.4.0-all-languages.tar.bz2
6.mv phpMyAdmin-3.4.0-all-languages mysqladmin
7.cd mysqladmin
8.cp config.sample.inc.php config.inc.php
9.vim config.inc.php
$cfg[‘blowfish_secret‘] = ‘ba17clec07d65003‘;
圖示：安裝php、php-mysql

650) this.width=650;" src="https://s1.51cto.com/oss/201711/21/7aa88f3224755008abc4e080fd4b0a1a.png-wh_500x0-wm_3-wmp_4-s_1639490227.png" title="Screenshot from 2017-11-21 16-09-58.png" alt="7aa88f3224755008abc4e080fd4b0a1a.png-wh_" /> 

圖示：修改配置

650) this.width=650;" src="https://s2.51cto.com/oss/201711/21/665114f972f7b425c4159bf9bd9308b0.png-wh_500x0-wm_3-wmp_4-s_255090251.png" title="Screenshot from 2017-11-21 16-13-26.png" alt="665114f972f7b425c4159bf9bd9308b0.png-wh_" />

四.安裝Discuz

1.下載Discuz_X3.2_SC_UTF8.zip

2.cd /mnt

3.unzip Discuz_X3.2_SC_UTF8.zip   ##解壓檔案
4.setenforce 0              ##將selinux設定為關閉   
5.chmod 777 upload -R          ##給upload許可權
圖示：Discuz簡介

650) this.width=650;" src="https://s5.51cto.com/oss/201711/21/9c98021332ba57c69f0a4cc4d9be4306.png-wh_500x0-wm_3-wmp_4-s_3858159644.png" title="Screenshot from 2017-11-21 16-52-26.png" alt="9c98021332ba57c69f0a4cc4d9be4306.png-wh_" />

##end##

本文出自 “13342594” 部落格，請務必保留此出處http://13352594.blog.51cto.com/13342594/1983914

linux--mariadb資料庫