centos8 with phpmyadmin

centos8 with LAMP

如何整合“No CAPTCHA reCAPTCHA”（驗證碼）到你的網站裡

參閱高手寫的

https://webdesign.tutsplus.com/zh-hant/tutorials/how-to-integrate-no-captcha-recaptcha-in-your-website--cms-23024

查詢CPU及記憶體

dmidecode -t memory     #記憶體
dmidecode -t processor   # CPU
dmidecode -t slot            # PCI 插槽
dmidecode -t system       # 主機廠商
dmidecode -t baseboard  # on-board 設備
dmidecode -t bios           #BIOS
dmidecode -t chassis

cat /proc/cpuinfo

查看磁碟分割表及分區結構
fdisk -l

查看硬碟資訊
df -lh

在blogger顯示程式碼

參考網址:
http://marcus116.blogspot.com/2018/02/blogger-blogger-show-code-using-google-code-prettify.html

關閉SELinux

參考來源:http://linwater.blogspot.com/2017/01/centos-7-php-7.html

開啟檔案 vi /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#         enforcing - SELinux security policy is enforced.
#         permissive - SELinux prints warnings instead of enforcing.
#         disabled - No SELinux policy is loaded.
SELINUX=enforcing
# SELINUXTYPE= can take one of three two values:
#         targeted - Targeted processes are protected,
#         minimum - Modification of targeted policy. Only selected processes are protected.
#         mls - Multi Level Security protwction.
SELINUXTYPE=targeted

將SELINUX=enforcing 改為SELINUX=disabled
儲存後重新開機。

php5 更新資料

$servername = "localhost";
$username = "1";
$password = "2";
$dbname = "3";
$conn = mysqli_connect( $servername, $username, $password);
//上面為基本設定

$sql = "update 資料庫 set 子資料庫 = '$變數' where id = '$ID'";
    mysqli_query($conn,$sql);

//如果不加上ID的話會一次修改全部數值，可以變成特定用法

php.ini

whereis php.ini
php: /usr/bin/php /etc/php.d /etc/php.ini /usr/lib/php /usr/share/man/man1/php.1.gz

我要改的是/etc/php.ini

vim /etc/php.ini

找三個地方，用「/」指令找

這三個數值的大小關係是：
memory_limit > post_max_size > upload_max_filesize

所以2048M、2047M、2046M

不能用4096 記憶體會耗盡 apache會開不起來

我用4095、4094、4093結果仍出現異常

無法創建資料庫、讀取資料庫也異常

改成3500、3400、3300仍然不行

最後乖乖用回2048、2047、2046

修改完後

reboot

php5 讀資料及寫入資料

//假設帳密如下

$servername = "localhost";

$username = "username";

$password = "password";

$dbname = "test";

// 創建連接

$conn = mysqli_connect( $servername, $username, $password);

if (empty($conn)){

  print mysqli_error($conn);

  die ("無法連結資料庫");

  exit;

 }

//選取資料庫 

if( !mysqli_select_db($conn, $dbname)) {

  die ("無法選擇資料庫");

 }

// 設定連線編碼

mysqli_query( $conn, "SET NAMES 'utf8'");


//取得資料

   $sql ="select * from `data` ";
//data是子資料庫名稱

   $result = mysqli_query($conn, $sql);

   //取出資料

   while ($row = mysqli_fetch_array($result, MYSQL_NUM)) {

   //while ($row = $result->fetch_row()) {
   //也可以用上面的寫法

     $data1 = $row[0] ;//第0筆，通常是自動編號

     $data2 = $row[1] ;//第1筆

     $data3 = $row[2] ;//第2筆

     }

//寫入方法

  $sql = "update 子資料庫 set data1 = '$data1', data2 = '$data2', data3 = '$data3'";
  mysqli_query($conn,$sql);

//關閉資料庫
  mysqli_close($conn);

CENTOS7布置LAMP環境

1.apache

yum -y install httpd
systemctl start httpd.service
systemctl enable httpd.service
firewall-cmd --permanent --zone=public --add-service=http
firewall-cmd --permanent --zone=public --add-service=https
firewall-cmd --reload

安裝https然後防火牆打開

vim /etc/httpd/conf/httpd.conf

找到3個

AllowOverride none

修改成

AllowOverride All

Require all denied刪除

systemctl restart httpd

查看httpd狀態
systemctl status httpd

2.MariaDB

yum install mariadb-server mariadb

systemctl start mariadb

mysql_secure_installation

systemctl enable mariadb.service
開機預設執行

3.php

yum -y install php php-mysql php-gd php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-snmp php-soap php-mcrypt curl zlib

4.phpmyadmin
yum -y install epel-release
yum -y install phpmyadmin
systemctl restart httpd

vi /etc/httpd/conf.d/phpMyAdmin.conf
找到IP，修改允許登入IP

Alias /phpMyAdmin /usr/share/phpMyAdmin

Alias /phpmyadmin /usr/share/phpMyAdmin

這邊修改目錄別名，改掉預設的phpmyadmin資料夾名稱

 

<Directory /usr/share/phpMyAdmin/>

   AddDefaultCharset UTF-8

 

   <IfModule mod_authz_core.c>

     # Apache 2.4

     <RequireAny>

       Require ip 1.2.3.4/24

這邊改允許的IP

     </RequireAny>

   </IfModule>

   <IfModule !mod_authz_core.c>

     # Apache 2.2

     Order Deny,Allow

     Deny from All

     Allow from 127.0.0.1

     Allow from ::1

   </IfModule>

</Directory>

重啟 apache 

# systemctl restart httpd