Tag Archives: database

MAC Navicat Premium 15.0.22 Failed to save password Error code: -34018

Problems arise

The local system version is MacOS Big Sur 11.1, and the Navicat version is 15.0.22
when we create a new connection or edit an old connection, check Save password , and click Save to pop up:

Failed to save password
Error code: -34018

Although it does not affect this login, you will need to re-enter your password the next time you log in.

Cause of the problem

Recently, two PJ versions are not perfect.

After reading many blogs, one blogger plagiarized the other and wrote the following command to solve the problem:

cd /Library/Keychains
sudo rm -r *

But this is not only unsuccessful, but also causes the key chain of MAC cache to be lost, making icloud login invalid and device association broken.

Problem solving

Practice success: you can first put the 15.0.20 version back to cover the current version 15.0.22 , after saving the password under the old version , if there is a need to use the new version , then use the new version to cover it.

How to Solve MongoDB Error: Authentication failed.

Question:

Implementation db.auth (‘username ‘,’ password ‘),
monodb authentication failed,
error: authentication failed.  appears

environment

Root, admin, and business database user authentication failed

Solution

    1. stop mongodb and open it without authentication,
##Go to the bin directory
cd 
##stop
mongod --shutdown --dbpath=/soft/mongo/mgserver/data/
##start
./mongod --dbpath=/soft/mongo/mgserver/data/ --logpath=/soft/mongo/mgserver/logs/mongod.log --logappend --port=27017 --fork

verify

mongo
show dbs

use  ${your db}
show users

use admin
show users

Modify password
3.1 modify root password:

#
mongo
#
db.changeUserPassword('root','${new  password}')
#
exit

#closed
mongod --shutdown --dbpath=/soft/mongo/mgserver/data/
#Certification Launch
./mongod --dbpath=/soft/mongo/mgserver/data/ --logpath=/soft/mongo/mgserver/logs/mongod.log --auth --logappend --port=27017 --fork

#
mongo
#
use admin
#user, pwd
db.auth('','')

Similarly, change the password of other users

3.2 new users

#
mongo
#
use ${your db}
#
db.createUser({
	user: "",
	pwd:"",
	roles:[{role:"readWrite",db:""}]
})