my php can"t connect the mysql

A question : why my php can't connect the mysql.

my php version is 5.014 and my mysql version is also 5.0,
but i run them on the windows xp system.
who knows the real problem?

I searched this at google,but I still haven't got the way to deal with
my problem.

Re: my php can"t connect the mysql

On 16 Aug., 03:10, "zhenwe...@gmail.com" wrote:
> A question : why my php can't connect the mysql.
>
> my php version is 5.014 and my mysql version is also 5.0,
> but i run them on the windows xp system.
> who knows the real problem?
>
> I searched this at google,but I still haven't got the way to deal with
> my problem.


more information!

propably your PHP code to connect is wrong or your mysql is not
running..!

Re: my php can"t connect the mysql

..oO(zhenwenxu@gmail.com)

>A question : why my php can't connect the mysql.
>
>my php version is 5.014 and my mysql version is also 5.0,
>but i run them on the windows xp system.
>who knows the real problem?

Could be anything. What does mysql_error() return? Is error_reporting
set to E_ALL?

Micha

Re: my php can"t connect the mysql

On Aug 16, 9:48 am, Michael Fesser wrote:
> .oO(zhenwe...@gmail.com)
>
> >A question : why my php can't connect the mysql.
>
> >my php version is 5.014 and my mysql version is also 5.0,
> >but i run them on the windows xp system.
> >who knows the real problem?
>
> Could be anything. What does mysql_error() return? Is error_reporting
> set to E_ALL?
>
> Micha

here is the error messages:
1:
#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
NO)
Warning: mysql_connect() [function.mysql-connect]: Access denied for
user 'SYSTEM'@'localhost' (using password: NO)

2:Could not connect: Access denied for user
'SYSTEM'@'localhost' (using password: NO)


3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
NO)
[Documentation]
http://www.mysql.com/doc/en/Error-returns.html

It showed me three different error messages becouse of my different
test.

Re: my php can"t connect the mysql

On Fri, 17 Aug 2007 03:18:45 +0200, zhenwenxu@gmail.com
wrote:

> On Aug 16, 9:48 am, Michael Fesser wrote:
>> .oO(zhenwe...@gmail.com)
>>
>> >A question : why my php can't connect the mysql.
>>
>> >my php version is 5.014 and my mysql version is also 5.0,
>> >but i run them on the windows xp system.
>> >who knows the real problem?
>>
>> Could be anything. What does mysql_error() return? Is error_reporting
>> set to E_ALL?
>>
>> Micha
>
> here is the error messages:
> 1:
> #1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
> NO)
> Warning: mysql_connect() [function.mysql-connect]: Access denied for
> user 'SYSTEM'@'localhost' (using password: NO)
>
> 2:Could not connect: Access denied for user
> 'SYSTEM'@'localhost' (using password: NO)
>
>
> 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
> NO)
> [Documentation]
> http://www.mysql.com/doc/en/Error-returns.html
>
> It showed me three different error messages becouse of my different
> test.

Well, exactly as it sais, you cannot connect to mysql as the user 'SYSTEM'
without a password. Either create that user or change the code to a
user/pass that can. (Hint: if you haven't touched your MySQL installation,
you _can_ connect with user 'root' and no password. It's advisable give it
a password though).
--
Rik Wasmus

Re: my php can"t connect the mysql

On Aug 17, 9:31 am, Rik wrote:
> On Fri, 17 Aug 2007 03:18:45 +0200, zhenwe...@gmail.com
>
>
>
>
>
> wrote:
> > On Aug 16, 9:48 am, Michael Fesser wrote:
> >> .oO(zhenwe...@gmail.com)
>
> >> >A question : why my php can't connect the mysql.
>
> >> >my php version is 5.014 and my mysql version is also 5.0,
> >> >but i run them on the windows xp system.
> >> >who knows the real problem?
>
> >> Could be anything. What does mysql_error() return? Is error_reporting
> >> set to E_ALL?
>
> >> Micha
>
> > here is the error messages:
> > 1:
> > #1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
> > NO)
> > Warning: mysql_connect() [function.mysql-connect]: Access denied for
> > user 'SYSTEM'@'localhost' (using password: NO)
>
> > 2:Could not connect: Access denied for user
> > 'SYSTEM'@'localhost' (using password: NO)
>
> > 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
> > NO)
> > [Documentation]
> >http://www.mysql.com/doc/en/Error-returns.html
>
> > It showed me three different error messages becouse of my different
> > test.
>
> Well, exactly as it sais, you cannot connect to mysql as the user 'SYSTEM'
> without a password. Either create that user or change the code to a
> user/pass that can. (Hint: if you haven't touched your MySQL installation,
> you _can_ connect with user 'root' and no password. It's advisable give it
> a password though).
> --
> Rik Wasmus- Hide quoted text -
>
> - Show quoted text -

no.My php script which is used to connect to my mysql user the user
name 'root' and
password,but I still can't connect to mqsql.

But it can connect to mysql with 'root' and my passwoed by mysql admin
tools.

Also the phpadmin can't connect to the mysql,I think my php script is
right.

I think there is something wrong with my mysql.

Re: my php can"t connect the mysql

zhenwenxu@gmail.com wrote:
> On Aug 17, 9:31 am, Rik wrote:
>> On Fri, 17 Aug 2007 03:18:45 +0200, zhenwe...@gmail.com
>>
>>
>>
>>
>>
>> wrote:
>>> On Aug 16, 9:48 am, Michael Fesser wrote:
>>>> .oO(zhenwe...@gmail.com)
>>>>> A question : why my php can't connect the mysql.
>>>>> my php version is 5.014 and my mysql version is also 5.0,
>>>>> but i run them on the windows xp system.
>>>>> who knows the real problem?
>>>> Could be anything. What does mysql_error() return? Is error_reporting
>>>> set to E_ALL?
>>>> Micha
>>> here is the error messages:
>>> 1:
>>> #1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
>>> NO)
>>> Warning: mysql_connect() [function.mysql-connect]: Access denied for
>>> user 'SYSTEM'@'localhost' (using password: NO)
>>> 2:Could not connect: Access denied for user
>>> 'SYSTEM'@'localhost' (using password: NO)
>>> 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
>>> NO)
>>> [Documentation]
>>> http://www.mysql.com/doc/en/Error-returns.html
>>> It showed me three different error messages becouse of my different
>>> test.
>> Well, exactly as it sais, you cannot connect to mysql as the user 'SYSTEM'
>> without a password. Either create that user or change the code to a
>> user/pass that can. (Hint: if you haven't touched your MySQL installation,
>> you _can_ connect with user 'root' and no password. It's advisable give it
>> a password though).
>> --
>> Rik Wasmus- Hide quoted text -
>>
>> - Show quoted text -
>
> no.My php script which is used to connect to my mysql user the user
> name 'root' and
> password,but I still can't connect to mqsql.
>
> But it can connect to mysql with 'root' and my passwoed by mysql admin
> tools.
>
> Also the phpadmin can't connect to the mysql,I think my php script is
> right.
>
> I think there is something wrong with my mysql.
>

I think there's something wrong with your code. Try posting it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: my php can"t connect the mysql

On Aug 18, 1:20 am, Jerry Stuckle wrote:
> zhenwe...@gmail.com wrote:
> > On Aug 17, 9:31 am, Rik wrote:
> >> On Fri, 17 Aug 2007 03:18:45 +0200, zhenwe...@gmail.com
>
> >> wrote:
> >>> On Aug 16, 9:48 am, Michael Fesser wrote:
> >>>> .oO(zhenwe...@gmail.com)
> >>>>> A question : why my php can't connect the mysql.
> >>>>> my php version is 5.014 and my mysql version is also 5.0,
> >>>>> but i run them on the windows xp system.
> >>>>> who knows the real problem?
> >>>> Could be anything. What does mysql_error() return? Is error_reporting
> >>>> set to E_ALL?
> >>>> Micha
> >>> here is the error messages:
> >>> 1:
> >>> #1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
> >>> NO)
> >>> Warning: mysql_connect() [function.mysql-connect]: Access denied for
> >>> user 'SYSTEM'@'localhost' (using password: NO)
> >>> 2:Could not connect: Access denied for user
> >>> 'SYSTEM'@'localhost' (using password: NO)
> >>> 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
> >>> NO)
> >>> [Documentation]
> >>>http://www.mysql.com/doc/en/Error-returns.html
> >>> It showed me three different error messages becouse of my different
> >>> test.
> >> Well, exactly as it sais, you cannot connect to mysql as the user 'SYSTEM'
> >> without a password. Either create that user or change the code to a
> >> user/pass that can. (Hint: if you haven't touched your MySQL installation,
> >> you _can_ connect with user 'root' and no password. It's advisable give it
> >> a password though).
> >> --
> >> Rik Wasmus- Hide quoted text -
>
> >> - Show quoted text -
>
> > no.My php script which is used to connect to my mysql user the user
> > name 'root' and
> > password,but I still can't connect to mqsql.
>
> > But it can connect to mysql with 'root' and my passwoed by mysql admin
> > tools.
>
> > Also the phpadmin can't connect to the mysql,I think my php script is
> > right.
>
> > I think there is something wrong with my mysql.
>
> I think there's something wrong with your code. Try posting it.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -

This is my script:
$conn=mysql_connect(`localhsot`,`root`,`123456`);
`123456` is my password.

Re: my php can"t connect the mysql

zhenwenxu@gmail.com wrote:
> On Aug 18, 1:20 am, Jerry Stuckle wrote:
>> zhenwe...@gmail.com wrote:
>>> On Aug 17, 9:31 am, Rik wrote:
>>>> On Fri, 17 Aug 2007 03:18:45 +0200, zhenwe...@gmail.com
>>>> wrote:
>>>>> On Aug 16, 9:48 am, Michael Fesser wrote:
>>>>>> .oO(zhenwe...@gmail.com)
>>>>>>> A question : why my php can't connect the mysql.
>>>>>>> my php version is 5.014 and my mysql version is also 5.0,
>>>>>>> but i run them on the windows xp system.
>>>>>>> who knows the real problem?
>>>>>> Could be anything. What does mysql_error() return? Is error_reporting
>>>>>> set to E_ALL?
>>>>>> Micha
>>>>> here is the error messages:
>>>>> 1:
>>>>> #1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
>>>>> NO)
>>>>> Warning: mysql_connect() [function.mysql-connect]: Access denied for
>>>>> user 'SYSTEM'@'localhost' (using password: NO)
>>>>> 2:Could not connect: Access denied for user
>>>>> 'SYSTEM'@'localhost' (using password: NO)
>>>>> 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
>>>>> NO)
>>>>> [Documentation]
>>>>> http://www.mysql.com/doc/en/Error-returns.html
>>>>> It showed me three different error messages becouse of my different
>>>>> test.
>>>> Well, exactly as it sais, you cannot connect to mysql as the user 'SYSTEM'
>>>> without a password. Either create that user or change the code to a
>>>> user/pass that can. (Hint: if you haven't touched your MySQL installation,
>>>> you _can_ connect with user 'root' and no password. It's advisable give it
>>>> a password though).
>>>> --
>>>> Rik Wasmus- Hide quoted text -
>>>> - Show quoted text -
>>> no.My php script which is used to connect to my mysql user the user
>>> name 'root' and
>>> password,but I still can't connect to mqsql.
>>> But it can connect to mysql with 'root' and my passwoed by mysql admin
>>> tools.
>>> Also the phpadmin can't connect to the mysql,I think my php script is
>>> right.
>>> I think there is something wrong with my mysql.
>> I think there's something wrong with your code. Try posting it.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================- Hide quoted text -
>>
>> - Show quoted text -
>
> This is my script:
> $conn=mysql_connect(`localhsot`,`root`,`123456`);
> `123456` is my password.
>

Are you actually using back ticks? These should be apostrophes.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: my php can"t connect the mysql

On Aug 18, 11:21 am, "zhenwe...@gmail.com"
wrote:
> On Aug 18, 1:20 am, Jerry Stuckle wrote:
>
>
>
> > zhenwe...@gmail.com wrote:
> > > On Aug 17, 9:31 am, Rik wrote:
> > >> On Fri, 17 Aug 2007 03:18:45 +0200, zhenwe...@gmail.com
>
> > >> wrote:
> > >>> On Aug 16, 9:48 am, Michael Fesser wrote:
> > >>>> .oO(zhenwe...@gmail.com)
> > >>>>> A question : why my php can't connect the mysql.
> > >>>>> my php version is 5.014 and my mysql version is also 5.0,
> > >>>>> but i run them on the windows xp system.
> > >>>>> who knows the real problem?
> > >>>> Could be anything. What does mysql_error() return? Is error_reporting
> > >>>> set to E_ALL?
> > >>>> Micha
> > >>> here is the error messages:
> > >>> 1:
> > >>> #1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
> > >>> NO)
> > >>> Warning: mysql_connect() [function.mysql-connect]: Access denied for
> > >>> user 'SYSTEM'@'localhost' (using password: NO)
> > >>> 2:Could not connect: Access denied for user
> > >>> 'SYSTEM'@'localhost' (using password: NO)
> > >>> 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
> > >>> NO)
> > >>> [Documentation]
> > >>>http://www.mysql.com/doc/en/Error-returns.html
> > >>> It showed me three different error messages becouse of my different
> > >>> test.
> > >> Well, exactly as it sais, you cannot connect to mysql as the user 'SYSTEM'
> > >> without a password. Either create that user or change the code to a
> > >> user/pass that can. (Hint: if you haven't touched your MySQL installation,
> > >> you _can_ connect with user 'root' and no password. It's advisable give it
> > >> a password though).
> > >> --
> > >> Rik Wasmus- Hide quoted text -
>
> > >> - Show quoted text -
>
> > > no.My php script which is used to connect to my mysql user the user
> > > name 'root' and
> > > password,but I still can't connect to mqsql.
>
> > > But it can connect to mysql with 'root' and my passwoed by mysql admin
> > > tools.
>
> > > Also the phpadmin can't connect to the mysql,I think my php script is
> > > right.
>
> > > I think there is something wrong with my mysql.
>
> > I think there's something wrong with your code. Try posting it.
>
> > --
> > ==================
> > Remove the "x" from my email address
> > Jerry Stuckle
> > JDS Computer Training Corp.
> > jstuck...@attglobal.net
> > ==================- Hide quoted text -
>
> > - Show quoted text -
>
> This is my script:
> $conn=mysql_connect(`localhsot`,`root`,`123456`);
> `123456` is my password.


if your code as you posted.There is a simple error localhsot ->
localhost :)

--
Gokhan Altinsoy ~= 10546-->
http://www.itinfomap.com/bilin/person.php?this=this&op=view& itemid=106

Re: my php can"t connect the mysql

On Aug 19, 3:27 pm, Gökhan Alt nsoy wrote:
> On Aug 18, 11:21 am, "zhenwe...@gmail.com"
> wrote:
>
>
>
>
>
> > On Aug 18, 1:20 am, Jerry Stuckle wrote:
>
> > > zhenwe...@gmail.com wrote:
> > > > On Aug 17, 9:31 am, Rik wrote:
> > > >> On Fri, 17 Aug 2007 03:18:45 +0200, zhenwe...@gmail.com
>
> > > >> wrote:
> > > >>> On Aug 16, 9:48 am, Michael Fesser wrote:
> > > >>>> .oO(zhenwe...@gmail.com)
> > > >>>>> A question : why my php can't connect the mysql.
> > > >>>>> my php version is 5.014 and my mysql version is also 5.0,
> > > >>>>> but i run them on the windows xp system.
> > > >>>>> who knows the real problem?
> > > >>>> Could be anything. What does mysql_error() return? Is error_repo=
rting
> > > >>>> set to E_ALL?
> > > >>>> Micha
> > > >>> here is the error messages:
> > > >>> 1:
> > > >>> #1045 - Access denied for user 'SYSTEM'@'localhost' (using passwo=
rd:
> > > >>> NO)
> > > >>> Warning: mysql_connect() [function.mysql-connect]: Access denied =
for
> > > >>> user 'SYSTEM'@'localhost' (using password: NO)
> > > >>> 2:Could not connect: Access denied for user
> > > >>> 'SYSTEM'@'localhost' (using password: NO)
> > > >>> 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using pass=
word:
> > > >>> NO)
> > > >>> [Documentation]
> > > >>>http://www.mysql.com/doc/en/Error-returns.html
> > > >>> It showed me three different error messages becouse of my differe=
nt
> > > >>> test.
> > > >> Well, exactly as it sais, you cannot connect to mysql as the user =
'SYSTEM'
> > > >> without a password. Either create that user or change the code to a
> > > >> user/pass that can. (Hint: if you haven't touched your MySQL insta=
llation,
> > > >> you _can_ connect with user 'root' and no password. It's advisable=
give it
> > > >> a password though).
> > > >> --
> > > >> Rik Wasmus- Hide quoted text -
>
> > > >> - Show quoted text -
>
> > > > no.My php script which is used to connect to my mysql user the user
> > > > name 'root' and
> > > > password,but I still can't connect to mqsql.
>
> > > > But it can connect to mysql with 'root' and my passwoed by mysql ad=
min
> > > > tools.
>
> > > > Also the phpadmin can't connect to the mysql,I think my php script =
is
> > > > right.
>
> > > > I think there is something wrong with my mysql.
>
> > > I think there's something wrong with your code. Try posting it.
>
> > > --
> > > ==================
> > > Remove the "x" from my email address
> > > Jerry Stuckle
> > > JDS Computer Training Corp.
> > > jstuck...@attglobal.net
> > > ==================- Hide quoted t=
ext -
>
> > > - Show quoted text -
>
> > This is my script:
> > $conn=3Dmysql_connect(`localhsot`,`root`,`123456`);
> > `123456` is my password.
>
> if your code as you posted.There is a simple error localhsot ->
> localhost :)
>
> --
> Gokhan Altinsoy ~=3D 10546-->http://www.itinfomap.com/bilin/person.php?t=
his=3Dthis&op=3Dview&itemid=3D106- Hide quoted text -
>
> - Show quoted text -
yes ,localhsot->localhost
$conn=3Dmysql_connect(`localhost`,`root`,`123456`);

Re: my php can"t connect the mysql

On Aug 19, 3:27 pm, Gökhan Alt nsoy wrote:
> On Aug 18, 11:21 am, "zhenwe...@gmail.com"
> wrote:
>
>
>
>
>
> > On Aug 18, 1:20 am, Jerry Stuckle wrote:
>
> > > zhenwe...@gmail.com wrote:
> > > > On Aug 17, 9:31 am, Rik wrote:
> > > >> On Fri, 17 Aug 2007 03:18:45 +0200, zhenwe...@gmail.com
>
> > > >> wrote:
> > > >>> On Aug 16, 9:48 am, Michael Fesser wrote:
> > > >>>> .oO(zhenwe...@gmail.com)
> > > >>>>> A question : why my php can't connect the mysql.
> > > >>>>> my php version is 5.014 and my mysql version is also 5.0,
> > > >>>>> but i run them on the windows xp system.
> > > >>>>> who knows the real problem?
> > > >>>> Could be anything. What does mysql_error() return? Is error_repo=
rting
> > > >>>> set to E_ALL?
> > > >>>> Micha
> > > >>> here is the error messages:
> > > >>> 1:
> > > >>> #1045 - Access denied for user 'SYSTEM'@'localhost' (using passwo=
rd:
> > > >>> NO)
> > > >>> Warning: mysql_connect() [function.mysql-connect]: Access denied =
for
> > > >>> user 'SYSTEM'@'localhost' (using password: NO)
> > > >>> 2:Could not connect: Access denied for user
> > > >>> 'SYSTEM'@'localhost' (using password: NO)
> > > >>> 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using pass=
word:
> > > >>> NO)
> > > >>> [Documentation]
> > > >>>http://www.mysql.com/doc/en/Error-returns.html
> > > >>> It showed me three different error messages becouse of my differe=
nt
> > > >>> test.
> > > >> Well, exactly as it sais, you cannot connect to mysql as the user =
'SYSTEM'
> > > >> without a password. Either create that user or change the code to a
> > > >> user/pass that can. (Hint: if you haven't touched your MySQL insta=
llation,
> > > >> you _can_ connect with user 'root' and no password. It's advisable=
give it
> > > >> a password though).
> > > >> --
> > > >> Rik Wasmus- Hide quoted text -
>
> > > >> - Show quoted text -
>
> > > > no.My php script which is used to connect to my mysql user the user
> > > > name 'root' and
> > > > password,but I still can't connect to mqsql.
>
> > > > But it can connect to mysql with 'root' and my passwoed by mysql ad=
min
> > > > tools.
>
> > > > Also the phpadmin can't connect to the mysql,I think my php script =
is
> > > > right.
>
> > > > I think there is something wrong with my mysql.
>
> > > I think there's something wrong with your code. Try posting it.
>
> > > --
> > > ==================
> > > Remove the "x" from my email address
> > > Jerry Stuckle
> > > JDS Computer Training Corp.
> > > jstuck...@attglobal.net
> > > ==================- Hide quoted t=
ext -
>
> > > - Show quoted text -
>
> > This is my script:
> > $conn=3Dmysql_connect(`localhsot`,`root`,`123456`);
> > `123456` is my password.
>
> if your code as you posted.There is a simple error localhsot ->
> localhost :)
>
> --
> Gokhan Altinsoy ~=3D 10546-->http://www.itinfomap.com/bilin/person.php?t=
his=3Dthis&op=3Dview&itemid=3D106- Hide quoted text -
>
> - Show quoted text -

But I can't understand my login name is "root",my error message is
like this:the login name is "SYSTEM"
here is the error messages:
1:
#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
NO)
Warning: mysql_connect() [function.mysql-connect]: Access denied for
user 'SYSTEM'@'localhost' (using password: NO)

2:Could not connect: Access denied for user
'SYSTEM'@'localhost' (using password: NO)


3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using
password:
NO)
[Documentation]
http://www.mysql.com/doc/en/Error-returns.html

Re: my php can"t connect the mysql

On Aug 19, 3:27 pm, Gökhan Alt nsoy wrote:
> On Aug 18, 11:21 am, "zhenwe...@gmail.com"
> wrote:
>
>
>
>
>
> > On Aug 18, 1:20 am, Jerry Stuckle wrote:
>
> > > zhenwe...@gmail.com wrote:
> > > > On Aug 17, 9:31 am, Rik wrote:
> > > >> On Fri, 17 Aug 2007 03:18:45 +0200, zhenwe...@gmail.com
>
> > > >> wrote:
> > > >>> On Aug 16, 9:48 am, Michael Fesser wrote:
> > > >>>> .oO(zhenwe...@gmail.com)
> > > >>>>> A question : why my php can't connect the mysql.
> > > >>>>> my php version is 5.014 and my mysql version is also 5.0,
> > > >>>>> but i run them on the windows xp system.
> > > >>>>> who knows the real problem?
> > > >>>> Could be anything. What does mysql_error() return? Is error_repo=
rting
> > > >>>> set to E_ALL?
> > > >>>> Micha
> > > >>> here is the error messages:
> > > >>> 1:
> > > >>> #1045 - Access denied for user 'SYSTEM'@'localhost' (using passwo=
rd:
> > > >>> NO)
> > > >>> Warning: mysql_connect() [function.mysql-connect]: Access denied =
for
> > > >>> user 'SYSTEM'@'localhost' (using password: NO)
> > > >>> 2:Could not connect: Access denied for user
> > > >>> 'SYSTEM'@'localhost' (using password: NO)
> > > >>> 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using pass=
word:
> > > >>> NO)
> > > >>> [Documentation]
> > > >>>http://www.mysql.com/doc/en/Error-returns.html
> > > >>> It showed me three different error messages becouse of my differe=
nt
> > > >>> test.
> > > >> Well, exactly as it sais, you cannot connect to mysql as the user =
'SYSTEM'
> > > >> without a password. Either create that user or change the code to a
> > > >> user/pass that can. (Hint: if you haven't touched your MySQL insta=
llation,
> > > >> you _can_ connect with user 'root' and no password. It's advisable=
give it
> > > >> a password though).
> > > >> --
> > > >> Rik Wasmus- Hide quoted text -
>
> > > >> - Show quoted text -
>
> > > > no.My php script which is used to connect to my mysql user the user
> > > > name 'root' and
> > > > password,but I still can't connect to mqsql.
>
> > > > But it can connect to mysql with 'root' and my passwoed by mysql ad=
min
> > > > tools.
>
> > > > Also the phpadmin can't connect to the mysql,I think my php script =
is
> > > > right.
>
> > > > I think there is something wrong with my mysql.
>
> > > I think there's something wrong with your code. Try posting it.
>
> > > --
> > > ==================
> > > Remove the "x" from my email address
> > > Jerry Stuckle
> > > JDS Computer Training Corp.
> > > jstuck...@attglobal.net
> > > ==================- Hide quoted t=
ext -
>
> > > - Show quoted text -
>
> > This is my script:
> > $conn=3Dmysql_connect(`localhsot`,`root`,`123456`);
> > `123456` is my password.
>
> if your code as you posted.There is a simple error localhsot ->
> localhost :)
>
> --
> Gokhan Altinsoy ~=3D 10546-->http://www.itinfomap.com/bilin/person.php?t=
his=3Dthis&op=3Dview&itemid=3D106- Hide quoted text -
>
> - Show quoted text -

I have got the answer!
It seems that php5.0 can't support the mysql5.0.
Now my php is 5.2,it runs ok!
Thank you for your answers.
Thanks anyway.

Re: my php can"t connect the mysql

zhenwenxu@gmail.com wrote:
> On Aug 19, 3:27 pm, Gökhan Alt nsoy wrote:
>> On Aug 18, 11:21 am, "zhenwe...@gmail.com"
>> wrote:
>>
>>
>>
>>
>>
>>> On Aug 18, 1:20 am, Jerry Stuckle wrote:
>>>> zhenwe...@gmail.com wrote:
>>>>> On Aug 17, 9:31 am, Rik wrote:
>>>>>> On Fri, 17 Aug 2007 03:18:45 +0200, zhenwe...@gmail.com
>>>>>> wrote:
>>>>>>> On Aug 16, 9:48 am, Michael Fesser wrote:
>>>>>>>> .oO(zhenwe...@gmail.com)
>>>>>>>>> A question : why my php can't connect the mysql.
>>>>>>>>> my php version is 5.014 and my mysql version is also 5.0,
>>>>>>>>> but i run them on the windows xp system.
>>>>>>>>> who knows the real problem?
>>>>>>>> Could be anything. What does mysql_error() return? Is error_reporting
>>>>>>>> set to E_ALL?
>>>>>>>> Micha
>>>>>>> here is the error messages:
>>>>>>> 1:
>>>>>>> #1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
>>>>>>> NO)
>>>>>>> Warning: mysql_connect() [function.mysql-connect]: Access denied for
>>>>>>> user 'SYSTEM'@'localhost' (using password: NO)
>>>>>>> 2:Could not connect: Access denied for user
>>>>>>> 'SYSTEM'@'localhost' (using password: NO)
>>>>>>> 3:#1045 - Access denied for user 'SYSTEM'@'localhost' (using password:
>>>>>>> NO)
>>>>>>> [Documentation]
>>>>>>> http://www.mysql.com/doc/en/Error-returns.html
>>>>>>> It showed me three different error messages becouse of my different
>>>>>>> test.
>>>>>> Well, exactly as it sais, you cannot connect to mysql as the user 'SYSTEM'
>>>>>> without a password. Either create that user or change the code to a
>>>>>> user/pass that can. (Hint: if you haven't touched your MySQL installation,
>>>>>> you _can_ connect with user 'root' and no password. It's advisable give it
>>>>>> a password though).
>>>>>> --
>>>>>> Rik Wasmus- Hide quoted text -
>>>>>> - Show quoted text -
>>>>> no.My php script which is used to connect to my mysql user the user
>>>>> name 'root' and
>>>>> password,but I still can't connect to mqsql.
>>>>> But it can connect to mysql with 'root' and my passwoed by mysql admin
>>>>> tools.
>>>>> Also the phpadmin can't connect to the mysql,I think my php script is
>>>>> right.
>>>>> I think there is something wrong with my mysql.
>>>> I think there's something wrong with your code. Try posting it.
>>>> --
>>>> ==================
>>>> Remove the "x" from my email address
>>>> Jerry Stuckle
>>>> JDS Computer Training Corp.
>>>> jstuck...@attglobal.net
>>>> ==================- Hide quoted text -
>>>> - Show quoted text -
>>> This is my script:
>>> $conn=mysql_connect(`localhsot`,`root`,`123456`);
>>> `123456` is my password.
>> if your code as you posted.There is a simple error localhsot ->
>> localhost :)
>>
>> --
>> Gokhan Altinsoy ~= 10546-->http://www.itinfomap.com/bilin/person.php?this=this& op=view&itemid=106- Hide quoted text -
>>
>> - Show quoted text -
>
> I have got the answer!
> It seems that php5.0 can't support the mysql5.0.
> Now my php is 5.2,it runs ok!
> Thank you for your answers.
> Thanks anyway.
>

Your problem is interesting, but PHP 5.0 supports mysql 5.0 quite well.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================