数据库

MongoDB

修复mongodb启动失败问题(service mongodb start):https://blog.csdn.net/qq_41420747/article/details/82988472

1
2
3
4
5
# 杀死mongod服务
$ sudo pkill mongod

# --auth 表示以认证模式启动服务,不加则关闭
$ sudo mongod -f /etc/mongod.conf --fork --auth



MySQL

mysql 8.0.30 修改密码

1
2
3
4
5
6
7
8
9
10
11
mysql> FLUSH PRIVILEGES;
mysql> update mysql.user set authentication_string='' where user='root' and host='localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit

$ mysql -u root -p
Enter password:(直接回车)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
mysql> FLUSH PRIVILEGES;

查看mysql端口

1
mysql> show global variables like 'port';