Each application taht uses your SQL Server database creates a connection on the database and this connection continues unless the session is killed or terminated privately within the application. A similar connection is established even for each...
A common occurrence I have noticed in MySQL apps is that MD5 values are stored as 32 byte values rather than 16. Just to ‘rehash’, an MD5 value is a 16 byte hexadecimal value, typically used as a unique fixed-length signature of a...
Running a DELETE FROM table query in a database with millions of records would lock the table and cause the website to halt. This is where LIMIT clause comes in handy. The following query will only delete the first 1000 rows that match: DELETE FROM...
Here is how to change postgresql superuser password on windows 10. From the terminal: net user postgres postgres From the UI: Right Click on My ComputerSelect ManageClick on local users and groupsThen usersRight-click on the usernameSelect Set...
If you are using MongoDB for development or you are running MongoDB database on the same server as your application, you probably do not want to expose MongoDB to the outside the local network. We can use bindIp option to allow remote access to...
To change MySQL root password in CyberPanel we need to update it’s configuration. CyberPanel stores MySQL root password into two files: /etc/cyberpanel/mysqlPassword/usr/local/CyberCP/CyberCP/settings.py mysqlPassword File contains the MySQL...
mysqldump command line tool is without doubt the most well known way to backup a MySQL database or multiple databases.
mysqladmin is a command line tool that allows you to do administrative tasks in MySQL without actually login to the MySQL console.
The default port that MongoDB runs on is 27017 and to change it we have to edit MongoDB's main configuration file, which for Linux Ubuntu/CentOS is mongod.conf and for Windows its mongod.cfg.
To check mongodb version use the mongod command with --version option.