Welcome to WebmasterWorld Guest from 54.224.103.186

Forum Moderators: open

Message Too Old, No Replies

First MySQL enabled website

Can I do it all in phpMyAdmin

     
12:45 pm on Apr 13, 2007 (gmt 0)

New User

5+ Year Member

joined:Mar 14, 2007
posts:40
votes: 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.

12:48 pm on Apr 13, 2007 (gmt 0)

New User

10+ Year Member

joined:Mar 22, 2006
posts:38
votes: 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.

12:59 pm on Apr 13, 2007 (gmt 0)

New User

5+ Year Member

joined:Mar 14, 2007
posts:40
votes: 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.

1:48 pm on Apr 13, 2007 (gmt 0)

Junior Member

5+ Year Member

joined:Oct 4, 2006
posts:44
votes: 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.

1:59 am on Apr 14, 2007 (gmt 0)

New User

5+ Year Member

joined:Mar 27, 2007
posts: 15
votes: 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.

4:52 am on Apr 14, 2007 (gmt 0)

Junior Member

5+ Year Member

joined:Oct 4, 2006
posts:44
votes: 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]

5:39 am on Apr 14, 2007 (gmt 0)

New User

5+ Year Member

joined:Mar 27, 2007
posts: 15
votes: 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 :-)

8:02 am on Apr 14, 2007 (gmt 0)

Preferred Member

10+ Year Member

joined:Mar 14, 2003
posts:508
votes: 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.

1:14 pm on Apr 14, 2007 (gmt 0)

Junior Member

5+ Year Member

joined:Oct 4, 2006
posts:44
votes: 0


ooh, thanks again, i will sure try.
5:37 pm on Apr 14, 2007 (gmt 0)

New User

5+ Year Member

joined:Mar 27, 2007
posts:15
votes: 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.

7:19 pm on Apr 15, 2007 (gmt 0)

Preferred Member

10+ Year Member

joined:Mar 14, 2003
posts:508
votes: 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.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members