linux mongDB安装
1、下载
wget https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-4.0.9.tgz
2、解压
tar -zxvf mongodb-linux-x86_64-4.0.9.tgz
3、改名,放到目录:/usr/local
mv mongodb-linux-x86_64-4.0.9 /usr/local/mongodb
4、新建必要的文件夹(依次是:数据库 日志 配置文件)
cd /usr/local/mongodb
mkdir data log etc
5、添加系统路径
vim /etc/profile
export PATH=$PATH:/usr/local/mongodb/bin
6、配置生效
source /etc/profile
7、查看是否添加
echo PATH
或者做软链
ln -s /usr/local/mongodb/bin/mongo /usr/bin/mongo
cd /usr/local/mongodb/etc
touch mongodb.conf
vim etc/mongodb.conf
#db存放的目录
dbpath=/usr/local/mongodb/data
#后台启动需要配置日志输出
logpath=/usr/local/mongodb/log/mongodb.log
#端口
port=27017
bind_ip = 0.0.0.0
#bind_ip=0.0.0.0 #绑定服务IP,若绑定127.0.0.1,则只能本机访问,不指定则默认本地所有IP
#设置成后台启动
fork=true
journal=false
启动服务
cd /usr/local/mongodb/bin
mongod -f ../etc/mongodb.conf
ps -ef | grep mongod
mongod --config /usr/local/mongodb/etc/mongodb.conf
关闭服务
mongod --config /usr/local/mongodb/etc/mongodb.conf --shutdown
或者
killall mongod
本地连接
mongo
添加用户
use admin
db.createUser({user: "admin",pwd: "123456",roles: [ { role: "readWrite", db: "admin" } ]});
添加超级用户
db.createUser({user: "root",pwd: "123456",roles: [ { role: "root", db: "admin" } ]});
查看已有用户
show users
删除单个用户
db.system.users.remove({user:"XXXXXX"})
https://blog.csdn.net/mouday/article/details/90670432
https://blog.csdn.net/weixin_38568503/article/details/127885059
记得为每个数据库增加用户
mongod --dbpath=../data/db
windws MongoDB
安装
https://www.mongodb.com/try/download/community
C:\Program Files\MongoDB\Server\6.0\data\
C:\Program Files\MongoDB\Server\6.0\log\
https://blog.csdn.net/weixin_57367513/article/details/127186191
缺少 monggo
下载工具集:
https://www.mongodb.com/try/download/database-tools
mongodb.com/try/download/shell
安装mongodb-community之后提示command not found: mongo找不到mongo指令
https://blog.csdn.net/dongkeai/article/details/127330013
wondiws mongodb数据库添加账号
https://blog.csdn.net/weixin_63228975/article/details/127392890
添加用户
show dbs
use admin
# 添加普通用户
db.createUser({user: "admin",pwd: "123456",roles: [ { role: "readWrite", db: "admin" } ]});
# 添加超级用户
db.createUser({user: "root",pwd: "123456",roles: [ { role: "root", db: "admin" } ]});
net start mongodb
启动
进到bin G:\mongodb-win32-x86_64-windows-6.0.5\bin
mongod --logpath=../data/log/mongo.log
mongod --dbpath=../data/db
如果配置了环境还是找不到mongod,重启下电脑
测试
浏览器输入127.0.0.1:27017
数据库导入
根据库名创建数据库,先导出sql,再导入sql
条件关键字
$lte:小于等于
db.getCollection("playerLogin").find({secondTime:{$lte:1672416023}})
db.getCollection("playerLogin").deleteMany({secondTime:{$lte:1672416023}})
https://blog.csdn.net/qq_29744347/article/details/127043780
Navicat Premium 12 破解
https://www.shuzhiduo.com/A/kvJ334DXJg/
Navicat 16 最新版破解激活图文教程
https://baijiahao.baidu.com/s?id=1756323888696693422&wfr=spider&for=pc
https://baijiahao.baidu.com/s?id=1741742105225126567&wfr=spider&for=pc
在数据库分页右边可以切换视图,比如jons格式