w

What is Data?

In simple words, data can be facts related to any object in consideration. For example, your name, age, height, weight, etc. are some data related to you. A picture, image, file, pdf, etc. can also be considered data.

What is Database?

A database is a systematic collection of data. They support electronic storage and manipulation of data. Databases make data management easy.

Let us discuss a database example: An online telephone directory uses a database to store data of people, phone numbers, and other contact details. Your electricity service provider uses a database to manage billing, client-related issues, handle fault data, etc.

Let us also consider Facebook. It needs to store, manipulate, and present data related to members, their friends, member activities, messages, advertisements, and a lot more. We can provide a countless number of examples for the usage of databases.

Types of Databases

Here are some popular types of databases.

Distributed databases:

A distributed database is a type of database that has contributions from the common database and information captured by local computers. In this type of database system, the data is not in one place and is distributed at various organizations.

Relational databases:

This type of database defines database relationships in the form of tables. It is also called Relational DBMS, which is the most popular DBMS type in the market. Database example of the RDBMS system include MySQL, Oracle, and Microsoft SQL Server database.

Object-oriented databases:

This type of computers database supports the storage of all data types. The data is stored in the form of objects. The objects to be held in the database have attributes and methods that define what to do with the data. PostgreSQL is an example of an object-oriented relational DBMS.

Centralized database:

It is a centralized location, and users from different backgrounds can access this data. This type of computers databases store application procedures that help users access the data even from a remote location.

Open-source databases:

This kind of database stored information related to operations. It is mainly used in the field of marketing, employee relations, customer service, of databases.

Cloud databases:

A cloud database is a database which is optimized or built for such a virtualized environment. There are so many advantages of a cloud database, some of which can pay for storage capacity and bandwidth. It also offers scalability on-demand, along with high availability.

Data warehouses:

Data Warehouse is to facilitate a single version of truth for a company for decision making and forecasting. A Data warehouse is an information system that contains historical and commutative data from single or multiple sources. Data Warehouse concept simplifies the reporting and analysis process of the organization.

NoSQL databases:

NoSQL database is used for large sets of distributed data. There are a few big data performance problems that are effectively handled by relational databases. This type of computers database is very efficient in analyzing large-size unstructured data.

Graph databases:

A graph-oriented database uses graph theory to store, map, and query relationships. These kinds of computers databases are mostly used for analyzing interconnections. For example, an organization can use a graph database to mine data about customers from social media.

OLTP databases:

OLTP another database type which able to perform fast query processing and maintaining data integrity in multi-access environments.

Personal database:

A personal database is used to store data stored on personal computers that are smaller and easily manageable. The data is mostly used by the same department of the company and is accessed by a small group of people.

Multimodal database:

The multimodal database is a type of data processing platform that supports multiple data models that define how the certain knowledge and information in a database should be organized and arranged.

Document/JSON database:

In a document-oriented database, the data is kept in document collections, usually using the XML, JSON, BSON formats. One record can store as much data as you want, in any data type (or types) you prefer.

PhpMyAdmin is a unique and popular web-based application/ administrative tool used to administer MySQL servers and databases. This tutorial explains how to create a new database and a new user to access that database on a MySQL Server using phpMyAdmin.

You will require a root or DBA user login to the MySQL server, or a user login with permission to create new databases.You will need to have access to an instance of phpMyAdmin appropriately configured to administrate the MySQL server.If you require a dedicated web server running MySQL and phpMyAdmin.

Using phpMyAdmin Version 3.5.1

Type your phpMyAdmin URL using your Internet Web Browser, and login using your root or dba user login as shown.

From the main menu choose Databases

In the create database field type in a name for your database. Leave the collation drop down box if you wish to use the default MySQL schema collation. Click Create.

Your database will now be visible on the right hand side under the list of available databases. To setup a new user login to access this database, click on Users in the main menu. Choose the Add User option under the list of available server users.

In the section titledLogin Information – type in a username, localhost and a password in the fields as shown. Optionally you can press the Generate button to create a random password for you.

The section that relates to the users GLOBAL privileges are privileges you want to assign to this user which apply to ALL databases on the server. It is recommended that you do NOT assign these permissions unless you know exactly what you are doing. It is far more secure to assign seperate user logins to each piece of software or website that will require access to only a particular database. Therefore leave this section BLANK, and then click the Add User button.

After the user is created, you can see it listed on the Users page. Click Edit Privileges to assign access to a specific database.

Once again leave the Global Privileges section BLANK. Scroll down to the section titled Database-Specific Privileges. Choose the database you want the user to be able to access from the list, and click GO.

Assign the permissions as shown to provide the user with access to the given database. The following permissions are recommended for compatibility with most modern web-based software applications.

Select, Insert, Update, Delete, Create, Alter, Index, Drop, Create Temporary Tables, Lock Tables

Click GO after selecting the relevant privileges.

If you click on the users Edit Privileges option now, you will see that new privileges for the specific database are now listed as belonging to the user.

Click the Logout option in the top left corner, and test your new user login with phpMyAdmin.

Testing Your User Login

Test your new user login by using it to login to phpMyAdmin.

NOTE: phpMyAdmin must be configured in the default cookie authentication mode to be able to login to MySQL server with any username.

If you can only view your new database in the list of schema’s on the left then your new database and username is most likely ready for use.

Once the creating of database is complete,for the database to work with a website,you need to connect the website to the database.