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

How to create MySQL database in XAMPP

MySQL Server, the world’s most popular open source database, and MySQL Cluster, a real-time, open source transactional database. 01- go to “localhost” or IP “127.0.0.1” to login MySQL server and click the “New” to create a new database   02 – Type database name which do you need to create “BigDataShrink.com”   03 – Create table in database and click “Go” to create table in “BigDataShrink.com” database   04 –  Type Name “ID” “Name” and select type of database   05 –  we have created two entry in “BigDatashrink.com”

Read More