RE: MySQL_Connect error ???

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 'mysql -u
--password= -D -h'

Is what I get when I run that command line. What is confusing me is why
it keeps saying "[email protected]" since I changed everything I could find
that referenced "root" to the database name. (and no the reinstall
didn't help :) ) Thanks for the suggestion Richard.

I'm starting to think Xaraya might be a bit much for a newbie to PHP and
MySQL to deal with. But darn it I really want to figure this thing out
:)

Ken
-----Original Message-----
From: xaraya_knowledge-base-bounces-n5IRV0TL0hwRxVAL8JNkPw@public.gmane.org
[mailto:xaraya_knowledge-base-bounces-n5IRV0TL0hwRxVAL8JNkPw@public.gmane.org] On Behalf Of
Richard Cave
Sent: Thursday, May 06, 2004 1:36 PM
To: [email protected]
Subject: Re: [Xaraya_knowledge-base] MySQL_Connect error ???

You could also have a connection error due to an incorrect database or
hostname.  Make sure that you can connect to the database from the
command line:

mysql -u <USERNAME> --password=<PASSWORD> -D <DATABASE> -h <HOSTNAME>

These parameters will line up exactly with the following in
var/config.system.php:

$systemConfiguration['DB.UserName'] = '<USERNAME>';
$systemConfiguration['DB.Password'] = '<PASSWORD>';
$systemConfiguration['DB.Host'] = '<HOSTNAME>';
$systemConfiguration['DB.Name'] = '<DATABASE>';


Cheers
Rich


Dark Yoda wrote:
> Well I had to go in and edit that so it had the right info. For some
> reason it didn't have the right info before. But it still didn't work
at
> fixing the connection error.
>
> Thanks,
>
> Ken
>
> -----Original Message-----
> From: xaraya_knowledge-base-bounces-n5IRV0TL0hwRxVAL8JNkPw@public.gmane.org
> [mailto:xaraya_knowledge-base-bounces-n5IRV0TL0hwRxVAL8JNkPw@public.gmane.org] On Behalf Of
> Chris Dudley
> Sent: Friday, April 30, 2004 4:11 PM
> To: [email protected]
> Subject: Re: [Xaraya_knowledge-base] MySQL_Connect error ???
>
> Dark Yoda wrote:
>
>>Hi all. Im new to using PHP and MySQL stuff sooo please go easy on me
>>:-)
>>
>>Anyways I keep getting this error every time I log in to my xaraya
>
> site.
>
>>At: /home/u3/darkyoda/html/xaradodb/drivers/adodb-mysql.inc.php (Line:
>>325)
>>
>>mysql_connect(): Access denied for user: '[email protected]' (Using
>>password: NO)
>>
>>Now I went to every place I could think to look and made sure that
>>root was changed to the user name and that the password and all was
>>right. And it just still is doing it.
>>I did not install xaraya into a database named xaraya(instead
>
> installing
>
>>it into one already there that I had been using for phpBB2). Hmm it
>>seems like it should work but I get the feeling that maybe I screwed
>>something up on the install that is just making it weird now.
>>
>>Ken
>
> check the password and username for the database in
> html/var/config.system.php
>
> miko
> _______________________________________________
> Xaraya_knowledge-base mailing list
> [email protected]
> http://lists.xaraya.com/mailman/listinfo/xaraya_knowledge-base
_______________________________________________
Xaraya_knowledge-base mailing list
[email protected]
http://lists.xaraya.com/mailman/listinfo/xaraya_knowledge-base