homepage Welcome to WebmasterWorld Guest from 54.167.174.90
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
First MySQL enabled website
Can I do it all in phpMyAdmin
bubster119

5+ Year Member



 
Msg#: 3310199 posted 12:45 pm on Apr 13, 2007 (gmt 0)

I want to create a simple MySQL enabled PHP website. The database will host a list of projects with I hope to sort by date and type.

My question is, my hosting allows me to create and manage MySQL databases through my control panel and phpMyAdmin so is it still necessary for me to install MySQL locally on my computer for such a simple database?

Any advice would be greatly appreciated since this is my first MySQL project.

 

rsndll

5+ Year Member



 
Msg#: 3310199 posted 12:48 pm on Apr 13, 2007 (gmt 0)

I have a mySQL-enabled web site and I don't have mySQL on my own PC.

The drawback is that you have to do all testing etc. online.

bubster119

5+ Year Member



 
Msg#: 3310199 posted 12:59 pm on Apr 13, 2007 (gmt 0)

I'm more than happy to test online, it's not much of an inconvenience considering the speed of broadband etc.

It would be more hassle to install it on my mac and have to configure the software firewall in OSX.

Discovery

5+ Year Member



 
Msg#: 3310199 posted 1:48 pm on Apr 13, 2007 (gmt 0)

Its good, If you can do testing stuffs in local machine for this you can install, using
1) LAMP package for linux
2)WAMP package for Windows

Or you can Install only Mysql.
[caucuscare.com...]
[washington.edu...]

But its not necessary mysql on local machine, What you can, you can created two database using phpmyadmin with your hosting company.
One for testing and other for your production.

souFrag

5+ Year Member



 
Msg#: 3310199 posted 1:59 am on Apr 14, 2007 (gmt 0)

I recommend you XAMPP:
[apachefriends.org...] (MacOS version)

It doesn't even require an "installation"... just unzip it and click on "start" when you want to run your local server.

Discovery

5+ Year Member



 
Msg#: 3310199 posted 4:52 am on Apr 14, 2007 (gmt 0)

thats, the great souFrag,

I have never tried this, because i don't have MacOS, this will really helpful for MacOS user.

[edited by: Discovery at 4:53 am (utc) on April 14, 2007]

souFrag

5+ Year Member



 
Msg#: 3310199 posted 5:39 am on Apr 14, 2007 (gmt 0)

XAMPP is available for Win, Linux, Solaris, Mac:
[apachefriends.org...]

It's really useful when you need a quick and simple test environment without having to "install" anything and mess up your OS :-)

steve

10+ Year Member



 
Msg#: 3310199 posted 8:02 am on Apr 14, 2007 (gmt 0)

I have XAMPP running on a USB stick, so I can move it between (Windows) computers.

It includes phpmyadmin which I've been using to create and populate databases and test SQL queries.

Its easy to install, just unzip and run the setup file, and away you go.

Discovery

5+ Year Member



 
Msg#: 3310199 posted 1:14 pm on Apr 14, 2007 (gmt 0)

ooh, thanks again, i will sure try.

souFrag

5+ Year Member



 
Msg#: 3310199 posted 5:37 pm on Apr 14, 2007 (gmt 0)

Its easy to install, just unzip and run the setup file, and away you go.

You don't even need to run a setup file if you download the ZIP version instead of the Installer :-)

With the ZIP version you've just got to unzip it and run xampp-control.exe.

steve

10+ Year Member



 
Msg#: 3310199 posted 7:19 pm on Apr 15, 2007 (gmt 0)

With the ZIP version you've just got to unzip it and run xampp-control.exe

I would avoid xampp-control it has a memory leak problem, use 'xampp start' and 'xampp stop' instead.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved