All articles: Data Control Language (DCL)

Checkout our self-help content, created by our top Experts!
How to establish an ASP.NET trusted connection to SQL Server? – Querychat
Almost every ASP.NET application uses databases and the most common one to be used is SQL Server. In this article, we will discuss the means of web applications connecting to SQL Server. Common ASP.NET connection string mistake When we develop an application on ASP.NET that uses a database, we inevitably...
How to set up an ADODB connection to MySQL – Querychat
Before proceeding with the ADODB configuration, let's first know what ADODB is and how it can help us. ADODB stands for Active Data Object DataBase. And it is nothing more than an intermediate layer between PHP and the database managers. ADODB provides a series of commands to standardize the connection...
How to install MySQL ODBC driver – Querychat
ODBC stands for Open DataBase Connectivity. ODBC is a tool developed by SQL Access Group (SAG) in 1992. Its main objective is to access the database with any application, regardless of the DBMS (MySQL, SQL Server, Sybase, Firebird) or the programming language (PHP, C#, Delphi) we use. ODBC introduces an...
Show users, Privileges and Passwords in MySQL – Querychat
We will observe in the following article how to get the list of MySQL users, as well as check their passwords and privileges. Each account includes the user’s name and host. This information is useful because there can be several accounts with privileges assigned for one user. Accounts in MySQL...
MySQL change user password – Querychat
Error while trying to change user password is one of the widely encountered issues in MySQL.  This article addresses the FAQ on how to change MySQL user password with proper illustrations. How to change my Password in MySQL? In MySQL, changing the user password can be done using SET PASSWORD...
Backup and restore MySQL databases – Querychat
This article explains how to backup & restore databases using MySQL Workbench, Command prompt, and SQL Server with step-by-step examples. Backup Databases using MySQL Workbench “Data Export” wizard allows us to backup databases.  By following below steps in MySQL Workbench we can back up a database from MySQL. Step Instructions...
1 2