MySQL

What is localhost, what does it do?

Localhost is the computer’s ability to operate as a server thanks to the software installed on the computer. We cannot run PHP files on a normal computer and do not perform operations on the database. Thanks to the installation of the localhost, our computer will gain a server feature and we will be able to run files such as PHP, MySQL.

We can access the localhost by typing http://localhost in our browser or at http://127.0.0.1.

The subject of our article is how to move the database to the sub-versions of SQL Server and we will talk about a few important points. Generate Script will move and we will talk about important points. In fact, the process runs smoothly, but if the Database size exceeds a certain level, the Database memory may fail during this process.

Now we will move to a lower SQL version of a Database that runs in SQL 2017 as the Lab environment.

In this article, I will explain how to backup and restore database backups with SQL Server Management Studio. The backup process is to keep an instance of all data on the database against the risk of loss and corruption. This backed up data is then restored as needed to prevent possible data loss.

Backup Process with SQL Server Management Studio

You must know the types of SQL Server Backup before proceeding to backup. There are 3 different backup types on SQL Server.

I will try to give you information about system databases and user databases in a series named “Basics of database management in SQL Server”.

Databases in SQL Server

Basically, SQL Server has the following two types of databases:

1. System Databases.

2. User Databases.

System Databases

System databases are one of the databases created when SQL Server is installed. These databases are used for various operational and management activities for SQL Server.

Multiple passwords can sometimes be difficult to keep in mind. One of these is when we forget the MySql Linux root password. If you have forgotten the MySQL root password on Linux, you don’t have to worry about that, you can recover it by following the steps below;

First, restart MySQL by giving the following command.

mysqld --skip-grant-tables

Then connect to MySQL with MySQL utility without using the password.

mysql> update mysql.user set Password=Password(‘new password’) where User=’root’;
mysql> flush privileges;

Finally, restart MySQL again normally without --skip-grant-tables.