Linux创建自己的论坛数据库

一时失言乱红尘 2023-06-25 10:05 16阅读 0赞

*  **安装****Apache**

**查看本机****IP****地址**

![20191227193333626.png][]

**yum -y install httpd**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70][]

**systemctl start httpd;**

**systemctl status httpd;**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 1][]

**关闭防火墙**

**systemctl stop firewalld.service;**

**firewall-cmd --state;**

**setenforce 0;**

**getenforce;**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 2][]

**\#** **测试：**

**\# windows:**

**\# http://192.168.31.131/**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 3][]

**二、安装数据库**

**yum -y install mariadb-server**

**yum -y install mysql-devel**

**systemctl start mariadb**

**systemctl status mariadb**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 4][]

**三、安装****php**

**yum -y install php php-mysql**

**yum -y install php-gd  libjpeg\*  php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-bcmath php-imap php-mcrypt php-mhash  libmcrypt**

**查询****php****是否安装**

**rpm -qc php**

**cd /etc/httpd/modules**

**ls**

**查看****/var/www/html****路径**

**cd /var/www/html**

**vi index.php**

**修改****index.php****文件**

**echo '''**

**<?php**

**       phpinfo();**

**?>**

**'''>index.php**

**重启****apache****服务**

**systemctl restart httpd**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 5][]

**cd /var/www/html**

**vi amp.php**

**文件内容**

**<?php**

**   $sql=mysqli\_connect('localhost','root','');**

**   if($sql)\{**

**           echo "success";**

**   \}else\{**

**           echo "failed";**

**   \}**

**?>**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 6][]

**测试**

**http://192.168.31.131/amp.php**

![20191227193333837.png][]

**四、安装****samba****服务和创建自己的论坛数据库**

**创建****mtc****用户**

**useradd mtc**

**id mtc**

**新建文件夹**

**mkdir -p /samba/share;**

**cd  /etc/samba;**

**修改****/etc/samba/smb.conf****文件内容**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 7][]

**设置****mtc****密码**

**smbpasswd -a mtc**

**授权登录**

**setfacl -m u:mtc:rwx /samba/share**

**重启****samba****服务**

**systemctl restart smb**

**将压缩包拖入**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 8][]

**安装****unzip**

**yum -y install unzip**

**解压放进去的****Discuz\_X3.4.zip**

**unzip Discuz\_X3.4.zip**

**复制****upload****的所有文件到****/var/www/html/**

**下面**

**cp -rf upload/\*  /var/www/html/**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 9][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 10][]

**修改权限**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 11][]

**权限修改成功**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 12][]

**选择下一步，然后选择第一个全选，然后下一步**

**登录** **mysql**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70][]

**show databases;**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 13][]

![20191227193333990.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 14][]

**select Host,User,Password  from user;**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 15][]

**delete from user where User='';**

**select Host,User,Password  from user;**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 16][]

**update user set Password=password('888888');**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 1][]

**grant all on discuss.\* to 'duser'@'%' identified by '888888';**

![20191227193328218.png][]

**systemctl restart mariadb**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 17][]

**查看密码登录后的多出来的****discuss****数据库**

![20191227193329726.png][]

完整的samba服务shell脚本配置

yum -y install samba;
    
    useradd mtc
    id mtc
    mkdir -p /samba/share;
    cd  /etc/samba;
    
    echo '''
    # See smb.conf.example for a more detailed config file or
    # read the smb.conf manpage.
    # Run 'testparm' to verify the config is correct after
    # you modified it.
    
    [global]
            workgroup = SAMBA
            security = user             
    
            ;map to guest = Bad User        
            ;passdb backend = tdbsam
            passdb backend = smbpasswd
            smb passwd file=/etc/samba/smbpasswd
            username map=/etc/samba/smbusers
    
            printing = cups
            printcap name = cups
            load printers = yes
            cups options = raw
    
    
    #[homes]
           # comment = Home Directories
           # valid users = %S, %D%w%S
           # browseable = No
           # read only = No
           # inherit acls = Yes
    
    
    [printers]
            comment = All Printers
            path = /var/tmp
            printable = Yes
            create mask = 0600
            browseable = No
    
    [print$]
            comment = Printer Drivers
            path = /var/lib/samba/drivers
            write list = @printadmin root
            force group = @printadmin
            create mask = 0664
            directory mask = 0775
    
    [share]
            comment =samba share
            path = /samba/share
            public = no
            browseable = yes
            writable = yes
            printable = no
            valid users = mtc
            write list = mtc
            read list = mtc
    '''> /etc/samba/smb.conf
    
    
    echo "为用户mtc添加密码"
    smbpasswd -a mtc
    
    cat /etc/samba/smbpasswd
    
    setfacl -m u:mtc:rwx /samba/share
    
    systemctl restart smb

apache完整shell脚本配置

# 安装APACHE：
    
    yum -y install httpd;
    systemctl start httpd;
    systemctl status httpd;
    
    
    systemctl stop firewalld.service;
    firewall-cmd --state;
    setenforce 0;
    getenforce;
    
    # 测试：
    # windows:
    # http://192.168.31.131/
    
    
    # 安装Maria
    
    yum -y install mariadb-server
    yum -y install mysql-devel
    systemctl start mariadb
    systemctl status mariadb
    
    
    # 测试：
    # mysql
    # show databases;
    
    #安装PHP
    yum -y install php php-mysql
    yum -y install php-gd  libjpeg*  php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-bcmath php-imap php-mcrypt php-mhash  libmcrypt
    
    yum -y remove php-gd  libjpeg*  php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-bcmath php-imap php-mcrypt php-mhash  libmcrypt
    yum -y remove php php-mysql
    
    rpm -qc php
    cd /etc/httpd/modules
    ls
    
    
    
    cd /var/www/html
    
    echo '''
    <?php
    	phpinfo();
    ?>
    '''>index.php
    
    systemctl restart httpd
    
    # 测试：
    # windows:
    # http://192.168.31.131/
    
    
    #测试Apache、PHP和Mariadb的功能：
    echo '''
    <?php
       $sql=mysqli_connect('localhost','root','');
       
       if($sql){
       		echo "success";
       }else{
       		echo "failed";
       }
    ?>
    ''' >amp.php
    
    # 测试：
    # windows:
    # http://192.168.31.131/amp.php
    
    
    
    #安装解压软件--解压
    yum -y install unzip
    unzip Discuz_X3.4.zip
    cp -rf upload/*  /var/www/html/
    
    
    mysql
    show databases;
    use mysql;
    show tables;
    select * from user;
    delete from user where User='';
    select Host,User,Password  from user;
    update user set Password=password('888888');
    select Host,User,Password  from user;
    
    
    # 测试：
    # windows:
    # http://192.168.31.131/
    
    chmod 777 config
    chmod 777 config/*
    chmod 777 data
    chmod 777 data/*
    chmod 777 data/attachment
    chmod 777 data/attachment/*
    chmod 777 uc_client/data
    chmod 777 uc_client/data/*
    chmod 777 uc_server/data/
    chmod 777 uc_server/data/*
    
    mysql
    grant all on discuss.* to 'duser'@'%' identified by '888888';
    exit
    
    systemctl restart mariadb

压缩包链接：[Discuz\_X3.4.zip][Discuz_X3.4.zip]

[20191227193333626.png]: https://img-blog.csdnimg.cn/20191227193333626.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191227193334222.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191227193334215.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191227193334168.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20191227193334294.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20191227193334117.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20191227193333543.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20191227193329850.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[20191227193333837.png]: https://img-blog.csdnimg.cn/20191227193333837.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/2019122719333453.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/2019122719333019.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20191227193329965.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/2019122719332851.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 11]: https://img-blog.csdnimg.cn/20191227193334231.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20191227193328507.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 13]: https://img-blog.csdnimg.cn/20191227193328455.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[20191227193333990.png]: https://img-blog.csdnimg.cn/20191227193333990.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 14]: https://img-blog.csdnimg.cn/20191227193328338.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 15]: https://img-blog.csdnimg.cn/20191227193334103.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 16]: https://img-blog.csdnimg.cn/201912271933343.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[20191227193328218.png]: https://img-blog.csdnimg.cn/20191227193328218.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg_size_16_color_FFFFFF_t_70 17]: https://img-blog.csdnimg.cn/20191227193334223.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTk4NzAxNg==,size_16,color_FFFFFF,t_70
[20191227193329726.png]: https://img-blog.csdnimg.cn/20191227193329726.png
[Discuz_X3.4.zip]: https://gitee.com/3dming/DiscuzL