数据库Mariadb图形安装及论坛安装

Mariadb的安装及优化

我的虚拟机 Operating System: Red Hat Enterprise Linux Server 7.0 (Maipo)

---

 [root@mysql ~]# yum install mariadb-server.x86_64 -y 
 [root@mysql ~]# systemctl start mariadb                 

测试

 [root@mysql ~]# mysql                                                 ###启动mysql
 Welcome to the MariaDB monitor.  Commands end with ; or \g.
 Your MariaDB connection id is 2
 Server version: 5.5.35-MariaDB MariaDB Server
 Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 MariaDB [(none)]>

 [root@mysql ~]# vim /etc/my.cnf             
 4 # Disabling symbolic-links is recommended to prevent assorted security risks
 5 symbolic-links=0
 6 skip-networking=1                                                  ###不让远程连接
 7 # Settings user and group are ignored when systemd is used.

 [root@mysql ~]# mysql_secure_installation                            ###开启安全设置，设置root密码，其他选y
 [root@mysql ~]# netstat -lntup|grep mysql
 tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      4215/mysqld         
 [root@mysql ~]# systemctl restart mariadb.service 
 [root@mysql ~]# netstat -lntup|grep mysql                            
 mysql -u root -predhat                                               ###root登陆mysql

Mariadb密码修改

 mysqladmin -u root -p123 password  或   mysqladmin -u root -p123 password 1234

Mariadb基本查看命令

  MariaDB [(none)]> show databases;                                   ###显示所有数据库
 +--------------------+
 | Database           |
 +--------------------+
 | information_schema |
 | mysql              |
 | performance_schema |
 +--------------------+
 3 rows in set (0.00 sec)
 MariaDB [(none)]> use mysql                                           ###使用mysql数据库
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A
 Database changed
 MariaDB [mysql]>
 MariaDB [mysql]> show tables;                                         ###显示数据库的表
 MariaDB [mysql]> desc user;                                           ###查看数据表的数据结构
 MariaDB [mysql]> select  Host,User,Password from user;                ###查询user表中host，user，password字段
 +-----------+------+-------------------------------------------+
 | Host      | User | Password                                  |
 +-----------+------+-------------------------------------------+
 | localhost | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
 | 127.0.0.1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
 | ::1       | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
 +-----------+------+-------------------------------------------+
 3 rows in set (0.00 sec

Mariadb创建数据库

 MariaDB [mysql]> create database dream;                               ###建立数据库
 Query OK, 1 row affected (0.00 sec)
 MariaDB [mysql]> use dream;
 MariaDB [dream]> create table linux(                                  ###创建table linux
    -> username varchar(15) not null,
    -> password varchar(20) not null
    -> );
 alter table linux add age varchar(4);                                 ###添加age字段到linux表中
 MariaDB [dream]> desc linux;
 +----------+-------------+------+-----+---------+-------+
 | Field    | Type        | Null | Key | Default | Extra |
 +----------+-------------+------+-----+---------+-------+
 | username | varchar(15) | NO   |     | NULL    |       |
 | password | varchar(20) | NO   |     | NULL    |       |
 | age      | varchar(4)  | YES  |     | NULL    |       |
 +----------+-------------+------+-----+---------+-------+
 3 rows in set (0.00 sec)
 ALTER TABLE linux ADD age  varchar(5)  AFTER username;		            ###在username字段后添加字段age 
 ALTER TABLE linux ADD age  varchar(5)  FIRST;		                    ###添加到第一位

插入信息

 MariaDB [dream]> insert into linux values ('user1','123','20');                          ###在linux表中插入值
 MariaDB [dream]> select * from linux;                                                    ###查看linux内容
 MariaDB [dream]> UPDATE linux set username='user6' where username='user1' AND  age=20；  ###把user6改成user1

Mariadb删除

删除本地用户在mysql数据库的user中删除

 delete from linux where username=user1 AND password=passwd1;			 ###删除linux表中user1的所有内容
 DROP TABLE linux;                                                       ###删除table linux
 DROP DATABASE dream;                                                    ###删除数据库dream

Mariadb权限

远程连接：mysql -h IP -uuser2 -ppasswd2 -P 3306

 CREATE USER 'dream'@'localhost' identified by '123';                    ###创建本地用户
 grant select on *.* to dream@localhost identified by '123';	         ###授权dream密码为123,并且只能在本地查询数据库的所有内容 
 grant all on mysql.* to user2@'%' identified by 'passwd2';		         ###授权user2 密码为passwd2  可以从远程任意主机登录mysql 并且可以对mysql数据库任意操作，也可以把%写为IP
 GRANT SELECT,INSERT on *.* TO dream@localhost;                          ###给SELECT,INSERT权限
 GRANT SELECT ON *.* to dream@localhost;                                 ###给SELECT权限对所有数据库
 REVOKE INSERT ON *.* FROM dream@localhost;                              ###移出INSERT（CREATE，SELECT）权限
 SHOW GRANTS FOR dream@localhost;                                        ###查看权限

Mariadb备份

判断库是否存在：

 mysql -uroot -p123 -EN -e "show databases;" grep dream                 ###判断dream数据库是否存在 

1.

 mysqldump -uroot -p123 dream > /mnt/mysql.bak	                          ###备份mysql库到mysql.bak
 mysql -uroot -p123 -e "drop database dream"
 mysql -uroot -p123 -e "create database dream"
 mysql -uroot -p123 dream < /mnt/mysql.bak	                              ###恢复mysql.bak 到dream库

2.

 vim   /mnt/mysql.bak
 21 create database dream
 22 use dream
 mysql -uroot -p123 dream < /mnt/mysql.bak	

Mariadb密码恢复

 systemctl stop mariadb.service                       
 mysqld_safe --skip-grant-tables &					                    ###跳过grant-tables授权表,不需要认证登录本地mysql数据库
 update mysql.user set password=password('dream') where user='root';	###更新mysql.user 表中条件为root用户的密码为加密dream
 ps aux |grep mysql
 kill -9  pid                                                           ###关闭mysql的所有进程
 systemctl restart mariadb

Mariadb图形安装

这里我们以phpMyAdmin-3.4.0-all-languages.tar.bz2为例
phpadmin安装包：https://pan.baidu.com/s/1nwGzjNN 密码：skx9

 php -m                                                                 ###查看php所支持的服务，发现并不支持mysql
 yum install php php-mysql -y                                           ###php-mysql让php支持mysql
 tar jxf phpMyAdmin-3.4.0-all-languages.tar.bz2 -C /var/www/html/
 cd /var/www/html/
 mv phpMyAdmin-3.4.0-all-languages mysqladmin
 cd mysqladmin/
 cp config.sample.inc.php config.inc.php
 systemctl restart httpd 
 systemctl stop firewalld 
 getenforce                                                              ###查看selinux为关闭模式                                      
 ###如果是2的版本则要加上###
 vim config.inc.php
 $cfg['blowfish_secret'] = 'ba17c1ec07d65003';

Mariadb图形安装测试

http://172.25.254.156/mysqladmin/

论坛LAMP

 LAMP:linux,apache,mysql,(php|python|perl)                             ###apache:同步阻塞
 LNMP:linux,Ngix,mysql(php|python|perl)                                ###Ngix：异步非阻塞

Discuz下载：https://pan.baidu.com/s/10n7UvS2205ORnbesr-8ISw 密码: cbrp

安装环境

在Mariadb的图形安装的环境下：

 unzip Discuz_X3.2_SC_UTF8.zip
 cp -r upload /var/www/html
 chmod 777 /var/www/html/upload/ -R
 systemctl start httpd
 systemctl start mariadb
 systemctl stop firewalld
 getenforce                                                            ###查看selinux为关闭模式

安装论坛

打开浏览器输入
http://172.25.254.156/upload