Database mariadb of [basic part]
1. Installation of database
Yum install mariadb.x86_64 mariadb-server.x86_64-y
Turn off the firewall
Close the network port (no access from outsiders)
Netstat-antlpe | grep mysql
Vim / etc/my.cnf
Add the words of skip
Restart the database service
two。 Add a password to the database
Mysql_secure_installation (Select all Y)
Log in to mysql-uroot-pwestos (login database)
3. Database usage
USE mysql (enter the mysql database)
CREATE DATABASE weostos (set up westos database)
CREATE TABLE linux (
Username varchar (15) not null
Password varchar (15) not null); (create table, username,password field)
SHOW DATABASES; (display database)
SHOW TABLES; (display tables in the database)
DESC linux (displays the data structure of the linux table)
SELECT host,user,password FROM linux
(query host,user,password field in linux table)
SELECT * FROM linux (query all fields in the linux table)
4. Modification of database
INSERT INTO linux VALUES ('user1','passwd', 'age')
UPDATE linux SET username='test@163.com' WHERE age='20'
ALTER TABLE linux add sex varchar (4)
(add sex field to linux table)
ALTER TABLE linux DROP sex; deletes the sex field
ALTER TABLE linux ADD sex VARCHAR (5) AFTER password (add sex after password)
DELETE FROM linux WHERE username='user1' (delete the line user1)
DROP TABLE westos.linux deletes tables in the library
DROP DATABASE westos deletes the westos library
5. Database password forgotten
Mysqladmin-uroot-pwestos password redhat
(known password change password)
Systemctl stop mariadb
Mysqld_safe-- skip-grant &
(skipping the grant-tables authorization table does not require authentication to log in to the local mysql database)
Mysql enters the database
Modify
Ps aux | grep mysql
Kill-9 3111 3269
Systemctl start mariadb
6. Backup of database
Mysqldump-uroot-pwestos westos (backup westos)
Mysqldump-uroot-pwestos-- all-databases (backup all libraries)
Mysqldump-uroot-pwestos westos > / mnt/westos.sql (backup westos to / mnt/)
Recovery of the database:
Mysql-uroot-pwestos-e "create database westos;" (create westos library)
Mysql-uroot-pwestos westos
< /mnt/westos.sql(恢复westos备份) 7.数据库用户的添加和访问权限 CREATE USER test@'localhost' identified by ' redhat ';(创建本地test用户) CREATE USER lee@'%'identified by 'redhat'; (创建网络用户,可以从远程任意主机登陆) GRANT SELECT on westos.* to lee@localhost; (给lee用户查看westos库的权限) GRANT ALL on *.* to lee@localhost; (给lee用户对于所有数据库的所有权限) SHOW GRANTS FOR lee@localhost; (查看lee用户的所有权限) GRANT SELECT,INSERT on westos.* to lee@localhost ( 给lee 在westos库的select和insert权限) REVOKE SELECT on westos.* FROM lee@localhost; (移除 lee用户在westos库的select权限) DROP USER lee@localhost;(删除lee用户) SELECT User FROM mysql.user;(查看系统中所有用户) 8.图形界面的数据库 1.安装httpd,php,php-mysql 关闭火墙 重启httpd 2.下载phpMyAdmin-3.4.0-all-languages.tar.bz2 tar jxf phpMyAdmin-3.4.0-all-languages.tar.bz2 -C /var/www/html/ (指定解压后的位置) 3.mv phpMyAdmin-3.4.0- mysqladmin 改名 4.进入mysqladmin cp config.sample.inc.php config.inc.php 5.修改 config.inc.php 填写 'cookie'
You can access it with a browser. The graphical interface is a database.
Mysql-E (display by line)-N (do not show database)