本文共 3058 字,大约阅读时间需要 10 分钟。
1.数据库的安装和查看
安装mariadb服务:yum install mariadb-server
启动mariadb:systemctl start mariadb 运行mariadb:systemctl enable mariadb 查看mariadb的运行状态:systemctl status mariadb数据库的查看:SHOW DATABASES;
表查看:USE mysql; SHOW TABLES; 表内容查看:SELECT * FROM user; vim /etc/my.cnf [mysqld] skip-networking=1 mysql_secure_installation #安全初始化2.数据库的基本管理
在shell界面查看数据库:mysql -uroot -predhat -e “SHOW DATABASES;”
1.查询:
查看表结构:DESC user; 针对字段搜索:SELECT Host,User,Select_priv FROM user; 增加条件:SELECT Host,User,Select_priv FROM user WHERE Host=‘localhost’; 2.建立: CREATE DATABASE westos; SHOW TABLES; CREATE TABLE linux( ->username varchar(10) not null, ->password varchar(20) not null ->);DESC linux;
INSERT INTO linux values (‘wps’,‘123’);
SELECT * FROM linux;SELECT username,password FROM linux;
3.更改:
ALTER TABLE linux ADD class varchar(10); DESC linux;ALTER TABLE linux ADD age varchar(4) AFTER password; #添加字段在password前
DESC linux;ALTER TABLE linux DROP age;
ALTER TABLE linux RENAME lalala; #重命名表
SELECT * FROM lalala;
UPDATE lalala SET class=‘linux’ WHERE username=‘wsp’ AND password=‘123’; #更新class的值 SELECT * FROM lalala;4.删除:
先添加 删除 DELETE FROM user WHERE username=‘wps’; SELECT * FROM user;SHOW TABLES;
DROP TABLE lalala; SHOW TABLES;DROP DATABASE westos;
SHOW DATABASES;5.用户授权:
CREATE USER westos@localhost identified by ‘wsp’; #创建用户 SELECT * FROM mysql.user; GRANT SELECT ON userdata.* TO westos@localhost; #授权用户westos在userdata数据库下有查询权限 FLUSH PRIVILEGES; #刷新方法2:
GRANT SELECT ON userdata.* TO westos@localhost IDENTIFIED BY ‘wsp’;REVOKE SELECT ON userdata.* FROM westos@localhost; #撤销权限
6.备份与恢复:
mysqldump -uroot -predhat --all-data mysqldump -uroot -predhat --all-data --no-datamysqldump -uroot -predhat userdata > /mnt/userdata.sql
mysql -uroot -predhat -e “DROP DATABASE userdata;” mysql -uroot -predhat -e “SHOW DATABASES;”恢复方式1:
[ root@localhost ~] # mysql -uroot -predhat < /mnt/userdata.sql ERROR 1046(3D000) at line 22: NO database selectedvim /mnt/userdata.sql
21 CREATE DATABASE userdata; 22 USE userdata;mysql -uroot -predhat
SHOW DATABASES; SELECT * FROM userdata.usertab;恢复方式2:
mysql -uroot -predhat -e “DROP DATABASE userdata;” mysql -uroot -predhat -e “CREATE DATABASE userdata;” vim /mnt/userdata.sql 删除21 22行 mysql -uroot -predhat userdata < /mnt/userdata.sql #指定导入到userdata库7.密码更改和破解
mysqladmin -uroot -predhat password westos超户密码忘记
systemctl stop mariadb 关闭服务mysqld_safe --skip-grant-tables &
mysql
UPDATE mysql.user SET Password=‘redhat’ WHERE User=‘root’; #密码是明文 明文密码修改后登陆可能会失败 UPDATE mysql.user SET Password=password(‘redhat’) WHERE User=‘root’;ps aux | grep mysql
kill -9 mysql 终止进程
systemctl start mariadb 开启服务
mysql -uroot -predhat 用修改后的密码登录3.phpMyAdmin
yum install httpd
firewall-cmd --permanent --add-service=http firewall-cmd --reloadtar zxf phpMyAdmin-4.0.10.20-all-languages.tar.gz -C /var/www/html/
mv phpMyAdmin-4.0.10.20-all-languages phpMyAdmin yum install php systemctl restart httpdyum install php-mysql
yum install php-mbstring-5.4.16-21.el7.x86_64.rpmsystemctl restart httpd
浏览器访问:172.25.254.xxx/phpMyAdmin
root --> redhat转载地址:https://blog.csdn.net/weixin_45426401/article/details/99613126 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!