Web Hosting Forum | Lunarpages

Author Topic: Create Database  (Read 49339 times)

Offline Arron12pet

  • Newbie
  • *
  • Posts: 1
Create Database
« on: October 29, 2010, 11:56:27 PM »
I want to create MYSQL database for my project can you please tell me the procedure how to create.

katrina1

  • Guest
Re: Create Database
« Reply #1 on: October 30, 2010, 12:25:44 AM »

Offline Lunartique

  • Intergalactic Cowboy
  • *****
  • Posts: 51
  • LUNAFIL
    • LUNAR BONUS
Re: Create Database
« Reply #2 on: February 01, 2011, 10:00:02 AM »
In addition to those provided by katrina, you may help from http://support.lunarpages.com/knowledge_bases/article/279
and to add tabels to you existing database, please go through: http://support.lunarpages.com/knowledge_bases/article/155

Offline smartkathy

  • Spacescooter Operator
  • *****
  • Posts: 37
Re: Create Database
« Reply #3 on: January 18, 2012, 04:38:16 AM »
Hey,

Great resources there, I m sure they are very useful for everyone, was myself looking for something like this.
Thank you for sharing them.
Cheers.

Offline konetkar500

  • Trekkie
  • **
  • Posts: 13
Re: Create Database
« Reply #4 on: February 03, 2012, 04:42:58 AM »
really very nicely explain the link shared here helps me to create my  database very easily .

Offline Poptarted

  • Pong! (the videogame) Master
  • *****
  • Posts: 22
Re: Create Database
« Reply #5 on: April 05, 2012, 10:13:17 AM »
really very nicely explain the link shared here helps me to create my  database very easily .

we try. :-) 

One thing to remember though when setting up your databases. Always make sure you set the proper permissions for the username that will be set to connect to that database. If your forget to allow them, it can screw up a lot of stuff that needs read/write access, etc.

Offline danielchrleng

  • Newbie
  • *
  • Posts: 3
Re: Create Database
« Reply #6 on: June 22, 2012, 02:31:44 AM »
Hi

Try:-
$ mysql -u root -p
Enter password:......................

<spam links removed>
« Last Edit: June 22, 2012, 11:32:33 AM by MrPhil »

Offline annaharris

  • Spacescooter Operator
  • *****
  • Posts: 48
    • PHP Development Comapny
Re: Create Database
« Reply #7 on: April 01, 2013, 05:17:17 AM »
As Katrina has suggested the link, I would say that just follow that link and it will guide you to create your own MYSqL database.

Offline noahwilson

  • Intergalactic Cowboy
  • *****
  • Posts: 51
Re: Create Database
« Reply #8 on: May 11, 2013, 02:48:09 AM »
thanks to all of you sharing your suggestion on this topic, its really so interesting and helpful for me.

Offline annaharris

  • Spacescooter Operator
  • *****
  • Posts: 48
    • PHP Development Comapny
Re: Create Database
« Reply #9 on: May 27, 2013, 03:10:19 AM »
Check this tutorial video, which describes step by step information about how to create mysql database. I hope it will be helpful for your project.
http://www.youtube.com/watch?v=aJVnYlRpET0

Offline webcreations

  • Hemant Latawa
  • Spaceship Navigator
  • *****
  • Posts: 86
    • Oil Expeller
Re: Create Database
« Reply #10 on: June 25, 2013, 08:50:34 PM »
The best way to create and manage a MySQL database is to download an open source program called PhpMyAdmin. This allows you to create and drop databases, create, drop, or alter tables, delete, edit, or add fields, execute any SQL statement, manage keys on fields, manage privileges, and import and export data into various formats.
For a complete demo see: http://www.phpmyadmin.net/phpMyAdmin/

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6208
Re: Create Database
« Reply #11 on: June 26, 2013, 05:13:45 AM »
Why are you telling people to d/l and install phpMyAdmin? It comes already installed on all Linux servers at Lunarpages (I don't know about Windows servers).
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

Offline sarah25

  • Space Explorer
  • ***
  • Posts: 6
Re: Create Database
« Reply #12 on: July 15, 2013, 08:23:26 PM »
Install wamp server on your pc. It is free an you can easily get it from their official website. Then go to phpmyamin section and create tables and databases easily without any particular guidence



<spam link removed>
« Last Edit: July 20, 2013, 07:27:54 AM by MrPhil »

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6208
Re: Create Database
« Reply #13 on: July 20, 2013, 07:30:52 AM »
So was the OP trying to run a test server on a PC? Why couldn't they have said so at the beginning!
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

Offline TigerAero

  • Intergalactic Superstar
  • *****
  • Posts: 196
    • X13: The Xeno Society
Re: Create Database
« Reply #14 on: November 01, 2013, 02:06:14 PM »
See http://wiki.lunarpages.com/Setup_MySQL_Databases or http://wiki.lunarpages.com/Create_and_Delete_MySQL_Databases_in_LPCP  depending on the control panel you are using.

Wow nice. :)

I was basically going to say all that in a numbered list lol. :)
X13: Xeno Society
Have the will to change the world. #x13

 

Share |