To assign a specific port number to the SQL Server Database Engine for remote access, take the following steps: Open SQL Server Management Studio and log in to your database. Right-click…
Category: MySQL
MySQL is an open source relational database management system based on Structured Query Language that is backed by Oracle (SQL).
How to Resolve the ‘MySQL Command Not Found’ Error
The ‘MySQL command not found’ error usually occurs when MySQL is either not installed on your system or its installation directory isn’t included in the system’s PATH environment variable. This…
How to Backup a Database using MySQLDump in WAMP
1. Open a Windows command prompt. 2. Navigate to the directory where the MySQLDump executable is located, typically: “C:\wamp\bin\mysql\mysql8.2.0\bin”. 3. Use the mysqldump.exe command followed by options: mysqldump.exe -u root…
How to Make a PostgreSQL User Account?
We’ll show you how to create a PostgreSQL user in this article. Create a PostgreSQL account by following these steps. 1.Go to your “cPanel” 2.PostgreSQL Databases interface to “Create a…
How To Create A MySQL Database Connection In Dreamweaver
After setting up a MySQL user’s account and after Setting up the PHP / MySQL Site Definition in Dreamweaver now we are going to have a look at the process…
Script For Connecting Remote MySQL DB From Local Machine
In a few circumstances, you may have to connect the MySQL Database from the local machine to the web hosting server, following is the script you can use for the…
How To Set / Reset MySQL Password?
Changing passwords is quite a regular type of task for many webmasters and the same is also applicable to database administrators also. Here I would like to share the procedure…