954,600 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

MySQL. Setup?

Hi All,

I'm messing around with different PHP scripts on my server. I can't seem to setup MySQL. I have installed and configured it. But I have now idea what to do with it. Is it like PHP where all you have to do is install it and its done? How do I create databases? Are there any good tutorials out there? I am running a PIII 733MHz server with windows 2003 server data center edition.

Thanks

viperman224
Junior Poster
183 posts since Dec 2003
Reputation Points: 29
Solved Threads: 1
 

MySQL will just sit there unless something tells it to do something. An easy way to start creating databases and adding tables and data to them is to get a GUI ( Navicat is an easy one to get started with. When you are ready to learn some more in-depth commands for MySQL, you will want to start familiarizing yourself with the MySQL Reference Manual . When you are ready to start using MySQL from within PHP, you will want to read a good tutorial on the subject. This tutorial should do well for you.

chrisbliss18
Posting Shark
917 posts since Aug 2005
Reputation Points: 38
Solved Threads: 25
 

http://www.phpmyadmin.net/home_page/

Quote from their website :
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 50 languages.

This is the best web-based MySQL tool I have found.

chizy2
Junior Poster in Training
62 posts since Apr 2005
Reputation Points: 14
Solved Threads: 3
 

The MySQL server also needs to be running before using it. It is not like PHP, since PHP only runs when it needs to. Start -> Run -> "services.msc" -> Enter. Then select the MySQL service and hit 'Start'.

Gary King
PHP/vBulletin Guru
Team Colleague
417 posts since Nov 2003
Reputation Points: 53
Solved Threads: 5
 

MySQL when installed, automatically starts the service for you.. Check and make sure that it is set to autostart

chizy2
Junior Poster in Training
62 posts since Apr 2005
Reputation Points: 14
Solved Threads: 3
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You