如何在sqlite3中设置用户名和密码? [英] How can I set a username and password in sqlite3?

问题描述

我正在linux机器上使用sqlite3，并且正在获取没有用户名和密码的数据库.我可以设置相同的用户名和密码吗?

I am using sqlite3 in a linux machine and I am getting the database without username and password. Can I set a username and password for the same?

推荐答案

不，sqlite3数据库是非常轻量级的系统.他们不需要服务器，所有数据都存储在一个文件中.sqlite/sqlite3软件包不支持用户名/密码.

No, sqlite3 databases are very lightweight systems. They need no server and all data is stored in one file. A username/password is not supported by the sqlite/sqlite3 package.

为了实现简单性，SQLite必须牺牲某些人认为有用的其他特征，例如高并发，细粒度访问控制，一组丰富的内置函数，过程，深奥的SQL语言功能，XML和/或Java扩展，千兆字节或PB的可伸缩性，等等.

In order to achieve simplicity, SQLite has had to sacrifice other characteristics that some people find useful, such as high concurrency, fine-grained access control, a rich set of built-in functions, stored procedures, esoteric SQL language features, XML and/or Java extensions, tera- or peta-byte scalability, and so forth.

( sqlite，何时使用)

但是，由于它只是一个文件，因此您可以使用密码对文件进行加密，以保护您的数据.

However, since it's only a file you can encrypt the file with a password to protect your data.

这篇关于如何在sqlite3中设置用户名和密码?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！