Start, Stop, Pause, Resume, Restart SQL Server Services

This article will cover one of the most common SQL servers using full system ram: start, stop, pause, resume, or restart the SQL Server Database Engine, the SQL Server Agent, or the SQL Server Browser service by using Services. Open Task Manager Press Ctrl + Alt + Delete or Right-Click on Taskbar and then click ” Start Task Manager” In the results pane, right-click SQL Server (MSSQLServer) or a named instance, and then click Start, Stop, Pause, Resume, or Restart.   Restarting services   After restarting services “SQL Server” using 700 mb ram    

Read More

how to create MySQL database in cPanel

First Login the Cpanel with Username and Password click on the MySQL Databases menu in the Databases section:   Type the database name in new Database to  which database you need to Create New Database, click on the Create Database button:    The database is created and ready to use.   The successfully created database in MySQL   To create a MySQL User, in under the Create new MySQL database. MySQL Users > Add New User and enter the username you wish to assign to your database. Once done, choose a secure password and password (again) for MySQL User and type it into…

Read More

How to Install MySQL on CentOS7

MySql is an open source database management system. In version 7 of the CentOS operating system, this database is set aside and MariaDB is the default relational database, and by installing the yum install mysql command, the MariaDB software is installed instead of MySql. In this article, we will examine how to install and run the MySQL version 5.7 on CentOS7. You can use the link below to install MariaDB. Step One: Install As explained in the previous section, MariaDB is the default database management software in CentOS7. In order to install…

Read More

How to Install MariaDB on CentOS7

MariaDB is an open source database management system that is derived from MySql. This relational database is an alternative to MySql, and the default database is the CentOS version 7 operating system. In this article, we will examine how to install this database on CentOS7. Step One: Install To install this database, run the command in the terminal.

To run the service of this database, run the following command.

To view the service status, run the following command.

The error is executed correctly. You will see the MySQL…

Read More

What is PostgreSQL

Introduced in some sources as Postgres, this database is one of the most powerful open source databases in the world with an emphasis on flexibility and compliance with standards. The Post Office Database is an object-relational database management system that is optimized for different types of operating systems and can be installed and serviced on various models of operating systems such as Windows, Linux and macOS. One of the highlights of the Postgraduate Database is that it is the default server database for mac servers. Most developers believe that MySQL…

Read More

Install PostgreSQL on Windows

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and…

Read More

How To Restart/Start/Stop/Pause/ SQL Server Service

Just open SQL Server Configuration Manager, we could start, stop, pause or restart SQL Server Service. Step 1: On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.   Step 2: click on SQL Server Services Step 2:select any instance of SQL Server such as SQL Server (SQLEXPRESS). Right-click any instance of SQL Server such as SQL Server (SQLEXPRESS), and then click Stop, Pause, Start orRestart.  buttons on toolbar, meaning Start, Pause, Stop and Restart.

Read More

How To User Grant Permissions in MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. this tutorial will give a short overview. 01 – Login MySQL server and then user accounts 02 – click on “Edit privileges”   03 – change privileges How To Grant Different User Permissions Here is a short list of other common possible permissions that users can enjoy. ALL PRIVILEGES- as we saw previously, this would allow a MySQL user all access to a designated database (or if no database is selected, across the…

Read More

how to check MySQL status in windows

take time to check MySQL server status 01- go to “localhost” or IP “127.0.0.1” to login MySQL server and click “status”   02 –  Click on server to show you MySQL Server traffic, MySQL server connection, MySQL server Failed attempt, MySQL server total traffic.   03 –  it show to MySQL server Processes details.   04 – display the MySQL Query statistics   05 – it show you all status variables   06 – Monitor show you overall traffic and system health 07 – Advisor Possible performance issues Issue Recommendation…

Read More

How to create new user account in MYSQL

01- go to “localhost” or IP “127.0.0.1” to login MySQL server and click “User accounts”   02 – go down and click “Add user accounts”     03 – MySQL User name “which do you need” and password “Example” or generate password to secure the MySQL database   04 – The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which they apply and at different levels of operation.    05 – or select privileges type, which do you need…

Read More