数据库
dnf install mariadb-server -y ----下载数据库
systemctl enable --now mariadb ----打开
mysql ----进入mysql
mysql_secure_installation -----设置超级用户密码
mysql -uroot -p -------超级用户登陆
为了安全起见,关闭端口
vim /etc/my.cnf.d/mariadb-server.cnf
{
skip-networking=1
}
systemctl restart mariadb
netstat -antlupe | grep mysql
=================================================================
添加信息(进入mysql)
CREATE DATABASE westos; ------建立新用户westos
SHOW DATABASES; -----查看信息
USE westos; -----切换到用户westos
CREATE TABLE userlist(
-> username VARCHAR(10) NOT NULL,
-> password VARCHAR(50) NOT NULL
-> ); -----创建数据库的信息
DESC userlist; -----显示建立的表格
INSERT INTO userlist VALUES ('user1','123'),('user2','123'),('user3','123'); ----输入表格信息
SELECT * FROM userlist; -----查看表格
=================================================================
修改表格
UPDATE userlist SET password='456' WHERE username='user3'; 修改user3的密码为456
ALTER TABLE userlist RENAME user; ------修改userlist名字为user
ALTER TABLE user add address varchar(50); 添加address信息
ALTER TABLE user add age varchar(4) AFTER password; --在password后加age
==================================================================
删除
DELETE FROM westos.user WHERE username='user3'; --删除user3
DROP TABLE westos.user; -----删除user列表
DROP DATABASE westos; ----删除westos用户
修改密码
mysqladmin -uroot -p password zhl ----超级用户密码改为zhl
systemctl stop mariadb
mysqld_safe --skip-grant-tables & ---进入修改
mysql
UPDATE mysql.user SET authentication_string=password('westos') WHERE User='root'; ------修改密码为westos
ps aux | grep mysql -查看进程,把mysql的进程都关闭
systemctl start mariadb
mysql -uroot -p ----进入mysql输入密码
=======================================================
用户授权
CREATE USER zhl@localhost identified by 'zhl'; ---建立用户zhl
SELECT User from mysql.user; ----查看用户
GRANT SELECT ON *.* TO zhl@localhost; ----授权查看
SHOW GRANTS FOR zhl@localhost; -----查看权限
GRANT INSERT ON *.* TO zhl@localhost; ------授权插入
SHOW GRANTS FOR zhl@localhost; ----查看权限
REVOKE INSERT ON *.* FROM zhl@localhost; -----移除插入权限
DROP user zhl@localhost; -------删除用户zhl
===========================================================
数据库备份
前提:
mysql -uroot -pwestos -e "CREATE DATABASE westos;"
mysql -uroot -pwestos -e "CREATE TABLE westos.user(user varchar(10) not null,passswd varchar(50) not null);"
mysql -uroot -pwestos -e "INSERT INTO westos.user VALUES ('user1','123'),('user2','123');"
建立用户
mysql -uroot -pwestos -e "SELECT * FROM westos.user;" ---查看建立好的用户信息
mysqldump -uroot -pwestos --all-database -------备份所有数据
mysqldump -uroot -pwestos westos > /mnt/westos.sql -------备份到/mnt/westos.sql
方法1:
mysql -uroot -pwestos -e "DROP DATABASE westos;" ----删除原先的数据库
mysql -uroot -pwestos -e "CREATE DATABASE westos" ----建立新的数据库
mysql -uroot -pwestos westos < /mnt/westos.sql -----把备份的内容给到新建的数据库
mysql -uroot -pwestos -e "SELECT * FROM westos.user;" ---查看
方法2:
vim /mnt/westos.sql ------编辑westos.sql
{
CREATE DATABASE westos;
USE westos;
}
mysql -uroot -pwestos < /mnt/westos.sql -----把备份数据给到数据库
mysql -uroot -pwestos -e "SELECT * FROM westos.user;" ---查看
================================================
php
dnf install httpd php php-mysqlnd -y
systemctl start httpd
systemctl stop firewalld
wget http://172.25.254.250/software/phpMyAdmin-3.4.0-all-languages.tar.bz2
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 myadmin ---更改名字
less README -----找到Documentation.txt
less Documentation.txt ------找到内容中的“更改为17c1ec07d65003“
cp config.sample.inc.php config.inc.php
bavim config.inc.php
{
17c1ec07d65003
}
systemctl restart httpd