Page 2 of 3
Posted: Wed Jul 26, 2006 1:59 pm
by dandare
php 4.4.2
mysql 4.1.20=standar-log
(i was typing in my correct username and password Daedalus - that was just spoof information)
Posted: Wed Jul 26, 2006 2:00 pm
by Benjamin
Is your DB username mechacol_UEL by chance?
Posted: Wed Jul 26, 2006 2:00 pm
by feyd
You might need to try
mysqli instead of mysql.
Posted: Wed Jul 26, 2006 2:01 pm
by RobertGonzalez
You know, it did not clarify that for him.
dandare, in my code sample, replace the db parameters with your actual login details. Sorry about that.

Posted: Wed Jul 26, 2006 2:02 pm
by RobertGonzalez
Can you get into your database with phpMyAdmin?
Posted: Wed Jul 26, 2006 2:16 pm
by dandare
(correction on the last post i made - i WASN'T typing in my correct user/password details)
yes, my database name is mechacol_UEL, astions
Feyd i will try replacing mysql to mysqli in a second
Everah i DID replace the db lines with my correct details and I can access the database through phpmyadmin
Posted: Wed Jul 26, 2006 2:38 pm
by dandare
Feyd
I got back the:
Fatal error: Call to undefined function: mysqli_connect() in ..... line 6
when i tried mysqli
hmm
i have know idea what it can be

Posted: Wed Jul 26, 2006 2:40 pm
by Benjamin
dandare wrote:yes, my database name is mechacol_UEL
I meant your username..
Posted: Wed Jul 26, 2006 2:44 pm
by dandare
no my username is different, astions
Posted: Wed Jul 26, 2006 2:48 pm
by Benjamin
Try using the username root with a blank password, which is what phpMyAdmin uses by default.
Posted: Wed Jul 26, 2006 2:53 pm
by dandare
Anyone think that it maybe to do with the php.ini file?
Only prroblem is I wouldn't think the company I purchased hosting with would offer both php and mysql without it being configured correctly

Posted: Wed Jul 26, 2006 3:02 pm
by dandare
Sorry astions,
do you mean using the correct usernem wit a blank password field? (within the con.php file)
if so i have tried that and it recognises when the password is incorrect or blank
Posted: Wed Jul 26, 2006 3:06 pm
by Benjamin
Blank password with root as the username
Posted: Wed Jul 26, 2006 3:51 pm
by dandare
ok i phoned up the hosting company. They suggested creating an new user and password for the database which kind of work.
It stated 'We're in' but it couldn't retrieve data.
Also tried root and no password which took me to the php version screen.
Posted: Wed Jul 26, 2006 3:59 pm
by dandare
ouch... scrap that last bit
username = root
password =
showed up with
Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO)