20

Mar, 2018

What is MySQL?

By: | Tags: | Comments: 0

MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, […]

READ MORE

20

Mar, 2018

What is phpMyAdmin?

By: | Tags: | Comments: 0

phpMyAdmin is one of the most popular applications for MySQL database management. It is a free tool written in PHP. Through this software you can create, alter, drop, delete, import and export MySQL database tables. You can run MySQL queries, optimize, repair and check tables, change collation and execute other database management commands. All the SiteGround clients can manage their MySQL databases through the pre-installed phpMyAdmin software which is integrated in cPanel.

READ MORE

20

Mar, 2018

Difference between MySql and phpMyAdmin

By: | Tags: | Comments: 0

To be frank I never worked with databases much as I am a client side programmer but recently took a project in php. Some tutorial used phpMyAdmin(comes with MAMP) and some installed MySql on mac and worked with the preinstalled version or updated version on mac.My preferences is to work with the preinstalled version of php so am really confused which one to opt.

READ MORE

20

Mar, 2018

What is a Database Management System (DBMS)?

By: | Tags: | Comments: 0

Database Management System (DBMS) is a collection of programs which enables its users to access database, manipulate data, reporting / representation of data . It also helps to control access to the database. Database Management Systems are not a new concept and as such had been first implemented in 1960s. Charles Bachmen’s Integrated Data Store (IDS) is said to be the first DBMS in history. With time database technologies evolved a lot while usage and expected functionalities of databases have been increased immensely. Types of DBMS Let’s see how the […]

READ MORE