Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: How do I create a MySQL Database?

  1. #1
    Join Date
    Jul 2008
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy How do I create a MySQL Database?

    I need help creating a database... I'm completely confused. Can anyone help?

  2. #2
    Join Date
    Oct 2006
    Posts
    183
    Thanks
    0
    Thanked 11 Times in 11 Posts

  3. #3
    Join Date
    Jul 2008
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Actually, that was the page that made me start this thread in the first place. :P

    I'm not sure I fully understand.

    Another person told me there was a code I copy to set up the main database, and save it to my server- then all I had to do was add to it when neccessary.

  4. #4
    Join Date
    Jul 2006
    Location
    Canada
    Posts
    2,581
    Thanks
    13
    Thanked 28 Times in 28 Posts

    Default

    Nope, it doesn't work quite like that. You either have a database or you don't, it's determined by your server specifications. Contact your server administrator and ask if a MySql database is set up. If so, they will probably give you a link to manage it (probably PHPmyadmin).
    - Mike

  5. #5
    Join Date
    Mar 2007
    Location
    New York, NY
    Posts
    557
    Thanks
    8
    Thanked 66 Times in 66 Posts

    Default

    there are so many ways--and it depends on your system. Be more specific
    - Josh

  6. #6
    Join Date
    Mar 2008
    Posts
    218
    Thanks
    7
    Thanked 19 Times in 19 Posts

    Default

    If you need a graphical tool you can try heidisql

  7. #7
    Join Date
    Jun 2005
    Location
    英国
    Posts
    11,876
    Thanks
    1
    Thanked 180 Times in 172 Posts
    Blog Entries
    2

    Default

    You have to have a database server running. If your host supports it, they should give you the address of that server and access details. Then, connect to it using the mysql client:
    Code:
    $ mysql -h mysqlserver.example.com -u your_username -p
    Password: 
    mysql> create database database_name;
    Twey | I understand English | 日本語が分かります | mi jimpe fi le jbobau | mi esperanton komprenas | je comprends franšais | entiendo espa˝ol | t˘i Ýt hiểu tiếng Việt | ich verstehe ein bisschen Deutsch | beware XHTML | common coding mistakes | tutorials | various stuff | argh PHP!

  8. #8
    Join Date
    Jul 2006
    Location
    Canada
    Posts
    2,581
    Thanks
    13
    Thanked 28 Times in 28 Posts

    Default

    I was confused with this too, at first, but you have to play around with it for a while before you fully get it.
    - Mike

  9. #9
    Join Date
    Oct 2008
    Location
    Atl
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    If you are using PHP, then MySQL is your best option as they are almost inseparable.

  10. #10
    Join Date
    Jun 2005
    Location
    英国
    Posts
    11,876
    Thanks
    1
    Thanked 180 Times in 172 Posts
    Blog Entries
    2

    Default

    Not really: PostgreSQL has just as much support, as well as being a more advanced implementation capable of frightfully advanced operations that MySQL seems to lack, like, er, subqueries.

    However, I'm not quite sure how this relates to the thread...
    Twey | I understand English | 日本語が分かります | mi jimpe fi le jbobau | mi esperanton komprenas | je comprends franšais | entiendo espa˝ol | t˘i Ýt hiểu tiếng Việt | ich verstehe ein bisschen Deutsch | beware XHTML | common coding mistakes | tutorials | various stuff | argh PHP!

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •