All articles: Data Control Language (DCL)

Checkout our self-help content, created by our top Experts!
All articles Data Control Language (DCL)
The most common Microsoft SQL Server errors – Querychat
In this article, we will learn why is it is important to fight with SQL Server errors and what are three the most common Microsoft SQL errors. Why do we need to handle errors in the code? During the SQL Server work errors can appear while entering the information in...
What is MySQL Message You Must Reset Your Password – Querychat
MySQL allows database administrators to apply password expiration policies for the database users. What happens if a user with an expired password tries to connect to the database is what we will discuss in this article. MySQL allows different behaviors based on system settings and based on the client trying...
How to work with Sample Databases in SQL Server – Querychat
If it is the first time you are working with SQL Server or testing for a new database enhancement, you might need somewhere to do tests on, and the best option Microsoft has are free database samples for download. This is the perfect opportunity for reinforcing DBA knowledge, working on...
Create a User in MySQL – Querychat
In MySQL, we can define the access that users have, both at the database level and the table level. We can define what operations each user is allowed to perform per database and per table. We will learn how to do it in this article. How to create a user...
How to create a second instance of MySQL – Querychat
It is likely that at some point you needed to launch a second instance of the MySQL database on the same machine. In this article, we will see how to do it. However, we are not going to install MySQL again. The idea is to use the resources of the...
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...
1 2