1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to create a database?

Discussion in 'Databases' started by Nina mitchell, May 8, 2016.

  1. #1
    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.
    SEMrush
     
    Nina mitchell, May 8, 2016 IP
    SEMrush
  2. mmerlinn

    mmerlinn Notable Member

    Messages:
    1,720
    Likes Received:
    195
    Best Answers:
    5
    Trophy Points:
    240
    #2
    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.
     
    mmerlinn, May 9, 2016 IP
  3. Alien_X

    Alien_X Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    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.
     
    Alien_X, May 9, 2016 IP
  4. webspider2005

    webspider2005 Well-Known Member

    Messages:
    383
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    108
    #4
    Install MYSQL locally and use MYSQL browser (a client based application) to manage your records.
     
    webspider2005, May 16, 2016 IP
  5. robinbd4u

    robinbd4u Banned

    Messages:
    155
    Likes Received:
    13
    Best Answers:
    1
    Trophy Points:
    63
    #5
    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.
     
    robinbd4u, May 26, 2016 IP
  6. Yatish Gaba

    Yatish Gaba Member

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #6
    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","");
     
    Yatish Gaba, Aug 31, 2016 IP
  7. Mike Lee

    Mike Lee Active Member

    Messages:
    58
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #7
    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!
     
    Mike Lee, Aug 31, 2016 IP
  8. irulsastra

    irulsastra Member

    Messages:
    67
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #8
    if you can't install via console like putty you can use cpanel
     
    irulsastra, Nov 14, 2016 IP
  9. GjB

    GjB Member

    Messages:
    44
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    33
    #9
    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
     
    GjB, Nov 23, 2016 IP