Author: admin
-
MySQL DROP Database
We can drop/delete/remove a MySQL database quickly with the MySQL DROP DATABASE command. It will delete the database along with all the tables, indexes, and constraints permanently. Therefore, we should have to be very careful while removing the database in MySQL because we will lose all the data available in the database. If the database…
-
MySQL SELECT Database
SELECT Database is used in MySQL to select a particular database to work with. This query is used when multiple databases are available with MySQL Server. You can use SQL command USE to select a particular database. Syntax: Example: Let’s take an example to use a database name “customers”. It will look like this: Note: All the…
-
MySQL Create Database
A database is used to store the collection of records in an organized form. It allows us to hold the data into tables, rows, columns, and indexes to find the relevant information frequently. We can access and manage the records through the database very easily. MySQL implements a database as a directory that stores all files…
-
Change MySQL User Password
MySQL user is a record that contains the login information, account privileges, and the host information for MySQL account to access and manage the database. The login information includes the user name and password. In some cases, there is a need to change the user password in the MySQL database. To change the password of…
-
MySQL Drop User
The MySQL Drop User statement allows us to remove one or more user accounts and their privileges from the database server. If the account does not exist in the database server, it gives an error. If you want to use the Drop User statement, it is required to have a global privilege of Create User statement or the DELETE privilege for the MySQL…
-
MySQL Create User
The MySQL user is a record in the USER table of the MySQL server that contains the login information, account privileges, and the host information for MySQL account. It is essential to create a user in MySQL for accessing and managing the databases. The MySQL Create User statement allows us to create a new user account in…
-
MySQL Workbench (Download and Installation)
MySQL Workbench is a unified visual database designing or graphical user interface tool used for working with database architects, developers, and Database Administrators. It is developed and maintained by Oracle. It provides SQL development, data modeling, data migration, and comprehensive administration tools for server configuration, user administration, backup, and many more. We can use this…
-
Connection
connection is a computer science facility that allows the user to connect with the database server software. A user can connect with the database server, whether on the same machine or remote locations. Therefore, if we want to work with the database server to send commands and receive answers in the form of a result set,…
-
Install MySQL
MySQL is one of the most popular relational database management software that is widely used in today’s industry. It provides multi-user access support with various storage engines. It is backed by Oracle Company. In this section, we are going to learn how we can download and install MySQL for beginners. Prerequisites The following requirements should…
-
Variables
Variables are used for storing data or information during the execution of a program. It is a way of labeling data with an appropriate name that helps to understand the program more clearly by the reader. The main purpose of the variable is to store data in memory and can be used throughout the program.…