How to create a database?

Hello,everybody

I want to know if the MySQL is the best database? How to create and manage my own database? I browse some installation guides but not worked. Please help me with the chart as much as possible. Thanks a lot.

 

Considering you do not tell us what you want to use the database for nor how you want to use the database, there is no way we can help you determine if MySql is the best database for your needs.

Until you know that, it is useless trying to tell you how to install and use it.

 

If you want to go with the free way, you have MySQL, SQlite, Postgresql. as mmerlinn said you need to provide us your use case to help you out better.

 

Install MYSQL locally and use MYSQL browser (a client based application) to manage your records.

 

You are absolutely right. I agree with you. I think she have to explain little bit more about her needs ?

Another thing she told that
I browse some installation guides but not worked

Hey @ninamitchel

are you trying to just install or create a mysql data base in cpanel ? If you wish that then look in at cpanel page and find the database tab and click mysql then there you will find option to create new database.

 

Following steps are use to create database -
Step 1 - Login as the mysql root user to create database: $ mysql -u root -p
Step 2- Add a database called books, enter: mysql> CREATE DATABASE books;
Step 3- Now, database is created. Use a database with use command, type: mysql> USE books;
Step 4- Next, create a table called authors with name, email and id as fields: mysql> CREATE TABLE authors (id INT, name VARCHAR(20), email VARCHAR(20));
Step 5- To display your tables in books database, enter: mysql> SHOW TABLES;
Step 6- Finally, add a data i.e. row to table books using INSERT statement, run: mysql> INSERT INTO authors (id,name,email) VALUES(1,"Vivek","");

 

If you want to create a MySQL database, you can go phpMyAdmin and create one.

It is easier and does not need coding skills.

Try to Google "create mysql database using phpmyadmin" and you will find many useful guides.

Hope this helps!

 

if you can't install via console like putty you can use cpanel

 

I know this is an older thread, but if you follow these short videos you will end up creating a database, and a search engine. I followed them recently to start learning PHP.
https://www.youtube.com/playlist?list=PL_QXkBHy8yVrA5cPsVh2JcU1Cj4q8iORN