MySQL installation help!

lisafelst12 · #1 Aug 31st, 2007, 15:22

I don't know what i'm doing wrong but I'm having loads of trouble installing MySQL, Apache and PHP on Windows! I think its a combination of me not actually understanding it fully or that even my lecturer doesn't know how to help

lol

Well, if anyone could give me a guide as to what to do with like the correct one to download etc I will be extremely grateful

And also, I have php on my MAC installed fine, but again confused about installing MySQL and Apache on there?

I have books but I just don't understand!
Thank you

jimz · #2 Aug 31st, 2007, 15:47

Doing it all from scratch is tough, especially when you've not done it before.

I still have nightmares about it.

Do you have any particular error messages?

For mac, try using this: http://www.mamp.info/en/index.php - I use this at home for testing and it's great.

alexgeek · #3 Aug 31st, 2007, 15:58

can't you use iis?

c010depunkk · #4 Aug 31st, 2007, 16:24

doesn't get any easier than this: http://www.apachefriends.org/en/xampp.html
download, run, select a drive root as target (ex: C:\ or D:\), wait for it to finish extracting, and start using!!!

alexgeek · #5 Aug 31st, 2007, 16:41

i downloaded the installer :

lisafelst12 · #6 Sep 2nd, 2007, 14:24

Thanks so much I have used http://www.apachefriends.org/en/xampp.html and I think I've got it working!

alexgeek · #7 Sep 2nd, 2007, 14:46

i didn't, it couldn't use port 80, (i think cos i have iis).
shame

lisafelst12 · #8 Sep 2nd, 2007, 21:36

well i've got everything but the mysql working, well it's working but the databases aren't linking to the php, I'm doing it locally and I keep getting errors on the page, mainly ;
An error occurred in script 'C:\xampp\htdocs\xampp\mysql_connect.php' on line 12:
mysql_connect() [function.mysql-connect]: Access denied for user 'username'@'localhost' (using password: YES)
Date/Time: 9-2-2007 22:35:47

YES isnt my password btw it just come up with that lol

Any suggestions what i need to do? thanks

alexgeek · #9 Sep 2nd, 2007, 22:03

have you used the mysql terminal to create a user?
also there may be a syntax error, post your code and **** your password

sannbe · #10 Sep 3rd, 2007, 03:41

Quote:

i didn't, it couldn't use port 80

try port 3306

dab42pat · #11 Sep 3rd, 2007, 08:51

Check the password setting in the xammp control panel. go to admin on mysql then check my.ini setup you should see the password assigned to mysql. so long as it corresponds to your connect.php it should work.
all the best

Pat

lisafelst12 · #12 Sep 3rd, 2007, 10:42

i dont seem to have connect.php :-S !!

lisafelst12 · #13 Sep 3rd, 2007, 10:49

I have this code, but it still doesnt seem to work?

PHP: Select all


<?php
// This file contains the database access information. 
// This file also establishes a connection to MySQL and selects the database.
// Set the database access information as constants.
DEFINE ('DB_USER', 'username');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'sitename');
// Make the connnection.
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() );
// Select the database.
@mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error() );
?>

dab42pat · #14 Sep 3rd, 2007, 13:46

You can try this.

PHP: Select all


<?php

$hostname_database = "your hostname";
$database_database = "your database name";
$username_database = "your username";
$password_database = "your password";
$database = mysql_pconnect($hostname_database, $username_database, $password_database) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

make sure the password and username are set in my.ini

alexgeek · #15 Sep 3rd, 2007, 15:55

Quote:

Originally Posted by sannbe

try port 3306

How can you change it?
it won't even start.
thanks

lisafelst12 · #16 Sep 3rd, 2007, 15:58

I think my problem is linking the php to the databases, I'm doing it on localhost. Is there something that I need to make the php script link to the database?

lisafelst12 · #17 Sep 3rd, 2007, 16:03

On phpMyAdmin I'm getting;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

What does this mean!? Sorry for all the questions!

jimz · #18 Sep 5th, 2007, 10:14

Quote:

Originally Posted by lisafelst12

On phpMyAdmin I'm getting;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Nice one mate, that means mysql's working.

It's basically saying the query you are doing is using incorrect syntax.

If you post the query you are trying to run and we can have a look.

		Webforumz.com > Main Forums > Program Your Website > Databases
MySQL installation help!