摘要:
1.sqlserver http://udayarumilli.com/sql-server-health-check-html-report/#:~:text=SQL%20Server%20Health%20Check%20HTML%20Report%20is%20the,Server%20ins 阅读全文
阅读排行榜
创建数据库和普通用户
2022-06-01 22:05 by abce, 42 阅读, 收藏,
摘要:
创建数据库和普通用户 create database test; create user abce with password 'xxxxxx'; grant all on database test to abce; alter user abce with valid until 'infini 阅读全文
MongoDB db.collection.explain()
2024-04-25 14:15 by abce, 41 阅读, 收藏,
摘要:
db.collection.explain() 封装了 explain 命令,推荐使用 db.collection.explain() 来执行 explain 命令。 db.collection.explain()返回以下方法的查询计划:aggregate()、count()、find()、remo 阅读全文
MySQL 的保留账号
2024-01-19 09:05 by abce, 41 阅读, 收藏,
摘要:
以下账号是 MySQL 中的保留账号,在mysql初始化的时候创建。 >select user,host,authentication_string,account_locked from mysql.user where account_locked='Y'; + + + + + | user | 阅读全文
【MySQL】MySQ简单开启firewalld
2022-06-21 19:45 by abce, 41 阅读, 收藏,
摘要:
# systemctl start firewalld.service # systemctl enable firewalld.service # firewall-cmd --permanent --zone=public --add-port=22/tcp # firewall-cmd --p 阅读全文