mariadb

yum install mariadb-server -y
systemctl start mariadb
systemctl enable mariadb

mysql_secure_installation

mysql -uroot -p

数据库的查询
SHOW DATABASES;

USE 库名称;

SHOW TABLES;

DESC 表名称;

SELECT * FROM 表名称;

SELECT 字段1, 字段2,...... from 表名称 where 字段='字段值';
SELECTC User,Password  FROM user WHERE Host='localhost';

数据库的管理
建立
SHOW DATABASES;        ##列出库
CREATE  DATABASE linux;    ##建立库

USE hello;        ##进入库
CREATE TABLE linux (    ##建立表
 username varchar(20) not null,
 passwd varchar(30) not null
 );
DESC hello;        ##查看表结构
INSERT INTO hello VALUES ('mo','123');        ##插入
SELECT * FROM hello;                ##查询所有字段

SELECT username,passwd FROM hello;        ##查询指定字段

更新

UPDATE linux SET passwd=('456') WHERE username='mo';

ALTER TABLE linux ADD class varchar(20);

ALTER TABLE linux DROP class;

ALTER TABLE linux ADD age varchar(20) AFTER passwd;

ALTER TABLE linux ADD RENAME redhat;

删除
DELETE FROM redhat WHERE username='mo';

DROP TABLE redhat;

DROP DATABASE linux;

CREATE USER mo@localhost identified by 'westos';

GRANT SELETE,INSERT ON userdata.* TO mo@localhost;
SHOW GRANTS FOR mo@localhost;

REVOKE INSERT ON westos.* FROM mo@localhost;

DROP USER mo@localhost;

FLUSH PRIVILEGES;

数据库的备份
mysqldump -uroot -pwestos userdata > /mnt/userdata.sql

mysqldump -uroot -pwestos userdata --no-data
mysqldump -uroot -pwestos --all-database
mysqldump -uroot -pwestos --all-database --no-data

恢复方式1
mysql -uroot -predhat -e "CREATE DATABASE userdata;"
mysql -uroot -predhat userdata < /mnt/userdata.sql

恢复方式2
vim /mnt/userdata.sql

CREATE DATABASE userdata;
USE userdata;

mysql -uroot -predhat < /mnt/userdata.sql

数据库的管理
mysqladmin -uroot -pwestos password redhat

当超级密码忘记时：
systemctl stop mariadb

mysqld_safe --skip-grant-tables &
mysql
update mysql.user SET Password=password('westos') WHERE User='root';

kill -9 mysql的所有进程id

systemctl start    mariadb

phpadmin

yum install httpd php php-mysql -y

systemctl start httpd
systemctl enable httpd

firewall-cmd --permanent --add-service=http
firewall-cmd --reload

tar -zxf phpMyAdmin-4.0.10.20-all-languages.tar.gz

mv phpMyAdmin-4.0.10.20-all-languages phpmyadmin
cp -r phpmyadmin /var/www/html/

rpm -ivh php-mbstring-5.4.16-21.el7.x86_64.rpm

用mysql数据库的帐号和密码登陆phpMyAdmin,就可以通过图形界面对数据库进行管理