Mysql autentication problem

Hello,

I'm trying to do a very simple thing: create a database and a user to
use it.

So, initially, I use the web interface phpmyadmin. Logged as root, I
created the database, and the user with some password.

But, I could not login using phpmyadmin. Either any php-based system
could connect to the BD.

So, I make sure that I got the "user@localhost" and "user@%" created,
with permissions and same password. Nothing.

But I *can* log on mysql shell.

One more info: when the user is set without password, it works fine on PHP.


Does anyone can give me a clue of what is happening?

Thanks!

Roberto

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

------=_Part_86502_5159998.1172841238841
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

So it works from PHP w/o a password, but with a password does not? What are
you using for a password? I don't mean post it here, but are there any
'funny' characters in it? I've had trouble because of that before, on other
systems. Try a dumb, obviously OK password, like 'apples' and see if that
works. Increase the password complexity from there...

Ted

On 3/2/07, Roberto F Tavares Neto wrote:
>
> Hello,
>
> I'm trying to do a very simple thing: create a database and a user to
> use it.
>
> So, initially, I use the web interface phpmyadmin. Logged as root, I
> created the database, and the user with some password.
>
> But, I could not login using phpmyadmin. Either any php-based system
> could connect to the BD.
>
> So, I make sure that I got the "user@localhost" and "user@%" created,
> with permissions and same password. Nothing.
>
> But I *can* log on mysql shell.
>
> One more info: when the user is set without password, it works fine on
> PHP.
>
>
> Does anyone can give me a clue of what is happening?
>
> Thanks!
>
> Roberto
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

------=_Part_86502_5159998.1172841238841--

Re: Mysql autentication problem

Ted,

I try the classic "abc" and had the same problem...

Roberto

Ted Fines escreveu:
> Hi,
>
> So it works from PHP w/o a password, but with a password does not?
> What are
> you using for a password? I don't mean post it here, but are there any
> 'funny' characters in it? I've had trouble because of that before, on
> other
> systems. Try a dumb, obviously OK password, like 'apples' and see if
> that
> works. Increase the password complexity from there...
>
> Ted
>
> On 3/2/07, Roberto F Tavares Neto wrote:
>>
>> Hello,
>>
>> I'm trying to do a very simple thing: create a database and a user to
>> use it.
>>
>> So, initially, I use the web interface phpmyadmin. Logged as root, I
>> created the database, and the user with some password.
>>
>> But, I could not login using phpmyadmin. Either any php-based system
>> could connect to the BD.
>>
>> So, I make sure that I got the "user@localhost" and "user@%" created,
>> with permissions and same password. Nothing.
>>
>> But I *can* log on mysql shell.
>>
>> One more info: when the user is set without password, it works fine on
>> PHP.
>>
>>
>> Does anyone can give me a clue of what is happening?
>>
>> Thanks!
>>
>> Roberto
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>


--
------------------------------------------------------------ ------------------------
Roberto Fernandes Tavares Neto
Prof. Assistente
Departamento de Engenharia de Produção
Universidade Federal de São Carlos
tavares@dep.ufscar.br tel +55 16
3351-9240
http://www.dep.ufscar.br/docentes_desc.php?uid=165
------------------------------------------------------------ ------------------------

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

------=_Part_86766_8998708.1172842003995
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,

When you're connecting from your PHP script, are you connecting from the
same machine that the db is on, or a different one? If a different one,
you'll need to do grant commands like:
grant all privileges on mydbname.* to 'mydbuser'@'myhostname.mycompany.net'
identified by 'mypassword';

Ted
On 3/2/07, Roberto F Tavares Neto wrote:
>
> Ted,
>
> I try the classic "abc" and had the same problem...
>
> Roberto
>
> Ted Fines escreveu:
> > Hi,
> >
> > So it works from PHP w/o a password, but with a password does not?
> > What are
> > you using for a password? I don't mean post it here, but are there any
> > 'funny' characters in it? I've had trouble because of that before, on
> > other
> > systems. Try a dumb, obviously OK password, like 'apples' and see if
> > that
> > works. Increase the password complexity from there...
> >
> > Ted
> >
> > On 3/2/07, Roberto F Tavares Neto wrote:
> >>
> >> Hello,
> >>
> >> I'm trying to do a very simple thing: create a database and a user to
> >> use it.
> >>
> >> So, initially, I use the web interface phpmyadmin. Logged as root, I
> >> created the database, and the user with some password.
> >>
> >> But, I could not login using phpmyadmin. Either any php-based system
> >> could connect to the BD.
> >>
> >> So, I make sure that I got the "user@localhost" and "user@%" created,
> >> with permissions and same password. Nothing.
> >>
> >> But I *can* log on mysql shell.
> >>
> >> One more info: when the user is set without password, it works fine on
> >> PHP.
> >>
> >>
> >> Does anyone can give me a clue of what is happening?
> >>
> >> Thanks!
> >>
> >> Roberto
> >>
> >> --
> >> PHP Database Mailing List (http://www.php.net/)
> >> To unsubscribe, visit: http://www.php.net/unsub.php
> >>
> >>
> >
>
>
> --
>
> ------------------------------------------------------------ -------------=
-----------
> Roberto Fernandes Tavares Neto
> Prof. Assistente
> Departamento de Engenharia de Produção
> Universidade Federal de S=E3o Carlos
> tavares@dep.ufscar.br tel +55 16
> 3351-9240
> http://www.dep.ufscar.br/docentes_desc.php?uid=3D165
>
> ------------------------------------------------------------ -------------=
-----------
>

------=_Part_86766_8998708.1172842003995--

RE: Mysql autentication problem

have you tried to 'flush privileges' to get the server to recognize the user
account. Another option might be to open the mysqld from the command line
and use the GRANT statement to create user without the gui.

bastien


>From: Roberto F Tavares Neto
>To: php-db@lists.php.net
>Subject: [PHP-DB] Mysql autentication problem
>Date: Fri, 02 Mar 2007 10:05:54 -0300
>
>Hello,
>
>I'm trying to do a very simple thing: create a database and a user to use
>it.
>
>So, initially, I use the web interface phpmyadmin. Logged as root, I
>created the database, and the user with some password.
>
>But, I could not login using phpmyadmin. Either any php-based system could
>connect to the BD.
>
>So, I make sure that I got the "user@localhost" and "user@%" created, with
>permissions and same password. Nothing.
>
>But I *can* log on mysql shell.
>
>One more info: when the user is set without password, it works fine on PHP.
>
>
>Does anyone can give me a clue of what is happening?
>
>Thanks!
>
>Roberto
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>

____________________________________________________________ _____
Free Alerts : Be smart - let your information find you !
http://alerts.live.com/Alerts/Default.aspx

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

I tried both already. It does not work.

Roberto

Bastien Koert escreveu:
> have you tried to 'flush privileges' to get the server to recognize
> the user account. Another option might be to open the mysqld from the
> command line and use the GRANT statement to create user without the gui.
>
> bastien
>
>
>> From: Roberto F Tavares Neto
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] Mysql autentication problem
>> Date: Fri, 02 Mar 2007 10:05:54 -0300
>>
>> Hello,
>>
>> I'm trying to do a very simple thing: create a database and a user to
>> use it.
>>
>> So, initially, I use the web interface phpmyadmin. Logged as root, I
>> created the database, and the user with some password.
>>
>> But, I could not login using phpmyadmin. Either any php-based system
>> could connect to the BD.
>>
>> So, I make sure that I got the "user@localhost" and "user@%" created,
>> with permissions and same password. Nothing.
>>
>> But I *can* log on mysql shell.
>>
>> One more info: when the user is set without password, it works fine
>> on PHP.
>>
>>
>> Does anyone can give me a clue of what is happening?
>>
>> Thanks!
>>
>> Roberto
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> ____________________________________________________________ _____
> Free Alerts : Be smart - let your information find you !
> http://alerts.live.com/Alerts/Default.aspx
>


--
------------------------------------------------------------ ------------------------
Roberto Fernandes Tavares Neto
Prof. Assistente
Departamento de Engenharia de Produção
Universidade Federal de São Carlos
tavares@dep.ufscar.br tel +55 16
3351-9240
http://www.dep.ufscar.br/docentes_desc.php?uid=165
------------------------------------------------------------ ------------------------

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

Ted,

The user@% does the same effect as 'mydbuser'@'myhostname.mycompany.net'
, right?

Btw, for web apps, I got another user, @localhost only. This user is
working...

I thought it was a problem on the GUI, so I tried a test@localhos from
mysql command line. It fails too...

Tks!

Roberto

Ted Fines escreveu:
> Hi,
>
> When you're connecting from your PHP script, are you connecting from the
> same machine that the db is on, or a different one? If a different one,
> you'll need to do grant commands like:
> grant all privileges on mydbname.* to
> 'mydbuser'@'myhostname.mycompany.net'
> identified by 'mypassword';
>
> Ted
> On 3/2/07, Roberto F Tavares Neto wrote:
>>
>> Ted,
>>
>> I try the classic "abc" and had the same problem...
>>
>> Roberto
>>
>> Ted Fines escreveu:
>> > Hi,
>> >
>> > So it works from PHP w/o a password, but with a password does not?
>> > What are
>> > you using for a password? I don't mean post it here, but are there
>> any
>> > 'funny' characters in it? I've had trouble because of that before, on
>> > other
>> > systems. Try a dumb, obviously OK password, like 'apples' and see if
>> > that
>> > works. Increase the password complexity from there...
>> >
>> > Ted
>> >
>> > On 3/2/07, Roberto F Tavares Neto wrote:
>> >>
>> >> Hello,
>> >>
>> >> I'm trying to do a very simple thing: create a database and a user to
>> >> use it.
>> >>
>> >> So, initially, I use the web interface phpmyadmin. Logged as root, I
>> >> created the database, and the user with some password.
>> >>
>> >> But, I could not login using phpmyadmin. Either any php-based system
>> >> could connect to the BD.
>> >>
>> >> So, I make sure that I got the "user@localhost" and "user@%" created,
>> >> with permissions and same password. Nothing.
>> >>
>> >> But I *can* log on mysql shell.
>> >>
>> >> One more info: when the user is set without password, it works
>> fine on
>> >> PHP.
>> >>
>> >>
>> >> Does anyone can give me a clue of what is happening?
>> >>
>> >> Thanks!
>> >>
>> >> Roberto
>> >>
>> >> --
>> >> PHP Database Mailing List (http://www.php.net/)
>> >> To unsubscribe, visit: http://www.php.net/unsub.php
>> >>
>> >>
>> >
>>
>>
>> --
>>
>> ------------------------------------------------------------ ------------------------
>>
>> Roberto Fernandes Tavares Neto
>> Prof. Assistente
>> Departamento de Engenharia de Produção
>> Universidade Federal de São Carlos
>> tavares@dep.ufscar.br tel +55 16
>> 3351-9240
>> http://www.dep.ufscar.br/docentes_desc.php?uid=165
>>
>> ------------------------------------------------------------ ------------------------
>>
>>
>


--
------------------------------------------------------------ ------------------------
Roberto Fernandes Tavares Neto
Prof. Assistente
Departamento de Engenharia de Produção
Universidade Federal de São Carlos
tavares@dep.ufscar.br tel +55 16
3351-9240
http://www.dep.ufscar.br/docentes_desc.php?uid=165
------------------------------------------------------------ ------------------------

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

--------------010606040205000509020408
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Did you give the user permissions to use the database in question?

Here's my sequence of actions:

..
1) Create DB if it doesn't exist
2) Create the user w/password
3) Give the user permission to use the database.
4) Flush privileges to update the server.
5) login and enjoy.

-Micah

Roberto F Tavares Neto wrote:
> Hello,
>
> I'm trying to do a very simple thing: create a database and a user to
> use it.
>
> So, initially, I use the web interface phpmyadmin. Logged as root, I
> created the database, and the user with some password.
>
> But, I could not login using phpmyadmin. Either any php-based system
> could connect to the BD.
>
> So, I make sure that I got the "user@localhost" and "user@%" created,
> with permissions and same password. Nothing.
>
> But I *can* log on mysql shell.
>
> One more info: when the user is set without password, it works fine on
> PHP.
>
>
> Does anyone can give me a clue of what is happening?
>
> Thanks!
>
> Roberto
>


--------------010606040205000509020408
Content-Type: text/plain; charset=us-ascii

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--------------010606040205000509020408--

Re: Mysql autentication problem

Micah:

I did create the database. Then, I use the:

GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'password'

to do the 2 and 3 steps.

FLUSH PRIVILEGES

to do the step 4.

But the step 5 really does not work... only on the shell or when I
remove the password from the user...

Roberto

Micah Stevens escreveu:
> Did you give the user permissions to use the database in question?
>
> Here's my sequence of actions:
>
> .
> 1) Create DB if it doesn't exist
> 2) Create the user w/password
> 3) Give the user permission to use the database.
> 4) Flush privileges to update the server.
> 5) login and enjoy.
>
> -Micah
>
> Roberto F Tavares Neto wrote:
>> Hello,
>>
>> I'm trying to do a very simple thing: create a database and a user to
>> use it.
>>
>> So, initially, I use the web interface phpmyadmin. Logged as root, I
>> created the database, and the user with some password.
>>
>> But, I could not login using phpmyadmin. Either any php-based system
>> could connect to the BD.
>>
>> So, I make sure that I got the "user@localhost" and "user@%" created,
>> with permissions and same password. Nothing.
>>
>> But I *can* log on mysql shell.
>>
>> One more info: when the user is set without password, it works fine
>> on PHP.
>>
>>
>> Does anyone can give me a clue of what is happening?
>>
>> Thanks!
>>
>> Roberto
>>
>


--
------------------------------------------------------------ ------------------------
Roberto Fernandes Tavares Neto
Prof. Assistente
Departamento de Engenharia de Produção
Universidade Federal de São Carlos
tavares@dep.ufscar.br tel +55 16
3351-9240
http://www.dep.ufscar.br/docentes_desc.php?uid=165
------------------------------------------------------------ ------------------------

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

--------------040100000601040605030508
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Strange. If you look at the users table, is there a password hash in the
password field?

Roberto F Tavares Neto wrote:
> Micah:
>
> I did create the database. Then, I use the:
>
> GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'password'
>
> to do the 2 and 3 steps.
>
> FLUSH PRIVILEGES
>
> to do the step 4.
>
> But the step 5 really does not work... only on the shell or when I
> remove the password from the user...
>
> Roberto
>
> Micah Stevens escreveu:
>> Did you give the user permissions to use the database in question?
>>
>> Here's my sequence of actions:
>>
>> .
>> 1) Create DB if it doesn't exist
>> 2) Create the user w/password
>> 3) Give the user permission to use the database.
>> 4) Flush privileges to update the server.
>> 5) login and enjoy.
>>
>> -Micah
>>
>> Roberto F Tavares Neto wrote:
>>> Hello,
>>>
>>> I'm trying to do a very simple thing: create a database and a user
>>> to use it.
>>>
>>> So, initially, I use the web interface phpmyadmin. Logged as root, I
>>> created the database, and the user with some password.
>>>
>>> But, I could not login using phpmyadmin. Either any php-based system
>>> could connect to the BD.
>>>
>>> So, I make sure that I got the "user@localhost" and "user@%"
>>> created, with permissions and same password. Nothing.
>>>
>>> But I *can* log on mysql shell.
>>>
>>> One more info: when the user is set without password, it works fine
>>> on PHP.
>>>
>>>
>>> Does anyone can give me a clue of what is happening?
>>>
>>> Thanks!
>>>
>>> Roberto
>>>
>>
>
>


--------------040100000601040605030508
Content-Type: text/plain; charset=us-ascii

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--------------040100000601040605030508--

Re: Mysql autentication problem

----- Original Message -----
From: "Micah Stevens"
To: "Roberto F Tavares Neto"
Cc:
Sent: Saturday, March 03, 2007 3:17 AM
Subject: Re: [PHP-DB] Mysql autentication problem


> Strange. If you look at the users table, is there a password hash in the
> password field?
>

i think this must be reload?? not just flush?? it happen to me..
or perhaps need some times to realy reload??
> Roberto F Tavares Neto wrote:
> > Micah:
> >
> > I did create the database. Then, I use the:
> >
> > GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'password'
> >
> > to do the 2 and 3 steps.
> >
> > FLUSH PRIVILEGES
> >
> > to do the step 4.
> >
> > But the step 5 really does not work... only on the shell or when I
> > remove the password from the user...
> >
> > Roberto
> >
> > Micah Stevens escreveu:
> >> Did you give the user permissions to use the database in question?
> >>
> >> Here's my sequence of actions:
> >>
> >> .
> >> 1) Create DB if it doesn't exist
> >> 2) Create the user w/password
> >> 3) Give the user permission to use the database.
> >> 4) Flush privileges to update the server.
> >> 5) login and enjoy.
> >>
> >> -Micah
> >>
> >> Roberto F Tavares Neto wrote:
> >>> Hello,
> >>>
> >>> I'm trying to do a very simple thing: create a database and a user
> >>> to use it.
> >>>
> >>> So, initially, I use the web interface phpmyadmin. Logged as root, I
> >>> created the database, and the user with some password.
> >>>
> >>> But, I could not login using phpmyadmin. Either any php-based system
> >>> could connect to the BD.
> >>>
> >>> So, I make sure that I got the "user@localhost" and "user@%"
> >>> created, with permissions and same password. Nothing.
> >>>
> >>> But I *can* log on mysql shell.
> >>>
> >>> One more info: when the user is set without password, it works fine
> >>> on PHP.
> >>>
> >>>
> >>> Does anyone can give me a clue of what is happening?
> >>>
> >>> Thanks!
> >>>
> >>> Roberto
> >>>
> >>
> >
> >
>
>


------------------------------------------------------------ ----------------
----


> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

--------------060707050206060007060208
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Reloading the grant tables should happen almost immediately unless you
have an extremely large set of users, very little memory, or a very slow
computer.



On 03/02/2007 06:17 PM, bedul wrote:
> ----- Original Message -----
> From: "Micah Stevens"
> To: "Roberto F Tavares Neto"
> Cc:
> Sent: Saturday, March 03, 2007 3:17 AM
> Subject: Re: [PHP-DB] Mysql autentication problem
>
>
>
>> Strange. If you look at the users table, is there a password hash in the
>> password field?
>>
>>
>
> i think this must be reload?? not just flush?? it happen to me..
> or perhaps need some times to realy reload??
>
>> Roberto F Tavares Neto wrote:
>>
>>> Micah:
>>>
>>> I did create the database. Then, I use the:
>>>
>>> GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'password'
>>>
>>> to do the 2 and 3 steps.
>>>
>>> FLUSH PRIVILEGES
>>>
>>> to do the step 4.
>>>
>>> But the step 5 really does not work... only on the shell or when I
>>> remove the password from the user...
>>>
>>> Roberto
>>>
>>> Micah Stevens escreveu:
>>>
>>>> Did you give the user permissions to use the database in question?
>>>>
>>>> Here's my sequence of actions:
>>>>
>>>> .
>>>> 1) Create DB if it doesn't exist
>>>> 2) Create the user w/password
>>>> 3) Give the user permission to use the database.
>>>> 4) Flush privileges to update the server.
>>>> 5) login and enjoy.
>>>>
>>>> -Micah
>>>>
>>>> Roberto F Tavares Neto wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>> I'm trying to do a very simple thing: create a database and a user
>>>>> to use it.
>>>>>
>>>>> So, initially, I use the web interface phpmyadmin. Logged as root, I
>>>>> created the database, and the user with some password.
>>>>>
>>>>> But, I could not login using phpmyadmin. Either any php-based system
>>>>> could connect to the BD.
>>>>>
>>>>> So, I make sure that I got the "user@localhost" and "user@%"
>>>>> created, with permissions and same password. Nothing.
>>>>>
>>>>> But I *can* log on mysql shell.
>>>>>
>>>>> One more info: when the user is set without password, it works fine
>>>>> on PHP.
>>>>>
>>>>>
>>>>> Does anyone can give me a clue of what is happening?
>>>>>
>>>>> Thanks!
>>>>>
>>>>> Roberto
>>>>>
>>>>>
>>>
>>
>
>
> ------------------------------------------------------------ ----------------
> ----
>
>
>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
>

--------------060707050206060007060208--

Re: Mysql autentication problem

------=_NextPart_000_00B7_01C75DA1.1FEDE270
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

now you mention it.
i hope the same problem will solve.

i use in windows (own pc)..not in real-life server.. thx for your repair =
on my missuderstanding
----- Original Message -----=20
From: Micah Stevens=20
To: bedul=20
Cc: php-db@lists.php.net=20
Sent: Saturday, March 03, 2007 1:48 PM
Subject: Re: [PHP-DB] Mysql autentication problem


Reloading the grant tables should happen almost immediately unless you =
have an extremely large set of users, very little memory, or a very slow =
computer.=20



On 03/02/2007 06:17 PM, bedul wrote:=20
----- Original Message -----
From: "Micah Stevens"
To: "Roberto F Tavares Neto"
Cc:
Sent: Saturday, March 03, 2007 3:17 AM
Subject: Re: [PHP-DB] Mysql autentication problem


=20
Strange. If you look at the users table, is there a password hash in the
password field?

=20

i think this must be reload?? not just flush?? it happen to me..
or perhaps need some times to realy reload??
=20
Roberto F Tavares Neto wrote:
=20
Micah:

I did create the database. Then, I use the:

GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'password'

to do the 2 and 3 steps.

FLUSH PRIVILEGES

to do the step 4.

But the step 5 really does not work... only on the shell or when I
remove the password from the user...

Roberto

Micah Stevens escreveu:
=20
Did you give the user permissions to use the database in question?

Here's my sequence of actions:

..
1) Create DB if it doesn't exist
2) Create the user w/password
3) Give the user permission to use the database.
4) Flush privileges to update the server.
5) login and enjoy.

-Micah

Roberto F Tavares Neto wrote:
=20
Hello,

I'm trying to do a very simple thing: create a database and a user
to use it.

So, initially, I use the web interface phpmyadmin. Logged as root, I
created the database, and the user with some password.

But, I could not login using phpmyadmin. Either any php-based system
could connect to the BD.

So, I make sure that I got the "user@localhost" and "user@%"
created, with permissions and same password. Nothing.

But I *can* log on mysql shell.

One more info: when the user is set without password, it works fine
on PHP.


Does anyone can give me a clue of what is happening?

Thanks!

Roberto

=20
=20
=20


------------------------------------------------------------ -------------=
---
----


=20
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
=20

=20


------=_NextPart_000_00B7_01C75DA1.1FEDE270--

Re: Mysql autentication problem

Yep, there is a hash... and the hash is valid - I can connect using the shell
with this password...

On Fri, 02 Mar 2007 12:17:33 -0800, Micah Stevens wrote
> Strange. If you look at the users table, is there a password hash in
> the password field?
>
> Roberto F Tavares Neto wrote:
> > Micah:
> >
> > I did create the database. Then, I use the:
> >
> > GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'password'
> >
> > to do the 2 and 3 steps.
> >
> > FLUSH PRIVILEGES
> >
> > to do the step 4.
> >
> > But the step 5 really does not work... only on the shell or when I
> > remove the password from the user...
> >
> > Roberto
> >
> > Micah Stevens escreveu:
> >> Did you give the user permissions to use the database in question?
> >>
> >> Here's my sequence of actions:
> >>
> >> .
> >> 1) Create DB if it doesn't exist
> >> 2) Create the user w/password
> >> 3) Give the user permission to use the database.
> >> 4) Flush privileges to update the server.
> >> 5) login and enjoy.
> >>
> >> -Micah
> >>
> >> Roberto F Tavares Neto wrote:
> >>> Hello,
> >>>
> >>> I'm trying to do a very simple thing: create a database and a user
> >>> to use it.
> >>>
> >>> So, initially, I use the web interface phpmyadmin. Logged as root, I
> >>> created the database, and the user with some password.
> >>>
> >>> But, I could not login using phpmyadmin. Either any php-based system
> >>> could connect to the BD.
> >>>
> >>> So, I make sure that I got the "user@localhost" and "user@%"
> >>> created, with permissions and same password. Nothing.
> >>>
> >>> But I *can* log on mysql shell.
> >>>
> >>> One more info: when the user is set without password, it works fine
> >>> on PHP.
> >>>
> >>>
> >>> Does anyone can give me a clue of what is happening?
> >>>
> >>> Thanks!
> >>>
> >>> Roberto
> >>>
> >>
> >
> >


--
Roberto F Tavares Neto
Prof. Assistente - Departamento de Engenharia de Produção
Universidade Federal de São Carlos - UFSCAR

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

I got 5 or 6 users... and a respectable computer...

On Fri, 02 Mar 2007 22:48:52 -0800, Micah Stevens wrote
> Reloading the grant tables should happen almost immediately unless
> you have an extremely large set of users, very little memory, or a
> very slow computer.
>
> On 03/02/2007 06:17 PM, bedul wrote:
> > ----- Original Message -----
> > From: "Micah Stevens"
> > To: "Roberto F Tavares Neto"
> > Cc:
> > Sent: Saturday, March 03, 2007 3:17 AM
> > Subject: Re: [PHP-DB] Mysql autentication problem
> >
> >
> >
> >> Strange. If you look at the users table, is there a password hash in the
> >> password field?
> >>
> >>
> >
> > i think this must be reload?? not just flush?? it happen to me..
> > or perhaps need some times to realy reload??
> >
> >> Roberto F Tavares Neto wrote:
> >>
> >>> Micah:
> >>>
> >>> I did create the database. Then, I use the:
> >>>
> >>> GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'password'
> >>>
> >>> to do the 2 and 3 steps.
> >>>
> >>> FLUSH PRIVILEGES
> >>>
> >>> to do the step 4.
> >>>
> >>> But the step 5 really does not work... only on the shell or when I
> >>> remove the password from the user...
> >>>
> >>> Roberto
> >>>
> >>> Micah Stevens escreveu:
> >>>
> >>>> Did you give the user permissions to use the database in question?
> >>>>
> >>>> Here's my sequence of actions:
> >>>>
> >>>> .
> >>>> 1) Create DB if it doesn't exist
> >>>> 2) Create the user w/password
> >>>> 3) Give the user permission to use the database.
> >>>> 4) Flush privileges to update the server.
> >>>> 5) login and enjoy.
> >>>>
> >>>> -Micah
> >>>>
> >>>> Roberto F Tavares Neto wrote:
> >>>>
> >>>>> Hello,
> >>>>>
> >>>>> I'm trying to do a very simple thing: create a database and a user
> >>>>> to use it.
> >>>>>
> >>>>> So, initially, I use the web interface phpmyadmin. Logged as root, I
> >>>>> created the database, and the user with some password.
> >>>>>
> >>>>> But, I could not login using phpmyadmin. Either any php-based system
> >>>>> could connect to the BD.
> >>>>>
> >>>>> So, I make sure that I got the "user@localhost" and "user@%"
> >>>>> created, with permissions and same password. Nothing.
> >>>>>
> >>>>> But I *can* log on mysql shell.
> >>>>>
> >>>>> One more info: when the user is set without password, it works fine
> >>>>> on PHP.
> >>>>>
> >>>>>
> >>>>> Does anyone can give me a clue of what is happening?
> >>>>>
> >>>>> Thanks!
> >>>>>
> >>>>> Roberto
> >>>>>
> >>>>>
> >>>
> >>
> >
> >
> > ------------------------------------------------------------ ----------------
> > ----
> >
> >
> >
> >> --
> >> PHP Database Mailing List (http://www.php.net/)
> >> To unsubscribe, visit: http://www.php.net/unsub.php
> >>
> >
> >


--
Roberto F Tavares Neto
Prof. Assistente - Departamento de Engenharia de Produção
Universidade Federal de São Carlos - UFSCAR

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

I did the reload, but with no effect...

On Sat, 3 Mar 2007 09:17:36 +0700, bedul wrote
> ----- Original Message -----
> From: "Micah Stevens"
> To: "Roberto F Tavares Neto"
> Cc:
> Sent: Saturday, March 03, 2007 3:17 AM
> Subject: Re: [PHP-DB] Mysql autentication problem
>
> > Strange. If you look at the users table, is there a password hash in the
> > password field?
> >
>
> i think this must be reload?? not just flush?? it happen to me..
> or perhaps need some times to realy reload??
> > Roberto F Tavares Neto wrote:
> > > Micah:
> > >
> > > I did create the database. Then, I use the:
> > >
> > > GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'password'
> > >
> > > to do the 2 and 3 steps.
> > >
> > > FLUSH PRIVILEGES
> > >
> > > to do the step 4.
> > >
> > > But the step 5 really does not work... only on the shell or when I
> > > remove the password from the user...
> > >
> > > Roberto
> > >
> > > Micah Stevens escreveu:
> > >> Did you give the user permissions to use the database in question?
> > >>
> > >> Here's my sequence of actions:
> > >>
> > >> .
> > >> 1) Create DB if it doesn't exist
> > >> 2) Create the user w/password
> > >> 3) Give the user permission to use the database.
> > >> 4) Flush privileges to update the server.
> > >> 5) login and enjoy.
> > >>
> > >> -Micah
> > >>
> > >> Roberto F Tavares Neto wrote:
> > >>> Hello,
> > >>>
> > >>> I'm trying to do a very simple thing: create a database and a user
> > >>> to use it.
> > >>>
> > >>> So, initially, I use the web interface phpmyadmin. Logged as root, I
> > >>> created the database, and the user with some password.
> > >>>
> > >>> But, I could not login using phpmyadmin. Either any php-based system
> > >>> could connect to the BD.
> > >>>
> > >>> So, I make sure that I got the "user@localhost" and "user@%"
> > >>> created, with permissions and same password. Nothing.
> > >>>
> > >>> But I *can* log on mysql shell.
> > >>>
> > >>> One more info: when the user is set without password, it works fine
> > >>> on PHP.
> > >>>
> > >>>
> > >>> Does anyone can give me a clue of what is happening?
> > >>>
> > >>> Thanks!
> > >>>
> > >>> Roberto
> > >>>
> > >>
> > >
> > >
> >
> >
>
> ------------------------------------------------------------ ----------------
> ----
>
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


--
Roberto F Tavares Neto
Prof. Assistente - Departamento de Engenharia de Produção
Universidade Federal de São Carlos - UFSCAR

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Mysql autentication problem

--------------030407060807010909090609
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

In mysql 4.1, they changed the hash format of the passwords. If you
stored the password from a 3.x client, and area accessing with a 4.x or
5.x client, or the other way around, you might have similar problems.

Your command line client is likely the same version as the server, so
I'm guessing that your php might be older.

However, this situation is usually accompanied by a specific error
message referencing the client version. Do you have that?

-Micah

On 03/02/2007 11:35 PM, bedul wrote:
> now you mention it.
> i hope the same problem will solve.
>
> i use in windows (own pc)..not in real-life server.. thx for your
> repair on my missuderstanding
>
> ----- Original Message -----
> *From:* Micah Stevens
> *To:* bedul
> *Cc:* php-db@lists.php.net
> *Sent:* Saturday, March 03, 2007 1:48 PM
> *Subject:* Re: [PHP-DB] Mysql autentication problem
>
> Reloading the grant tables should happen almost immediately unless
> you have an extremely large set of users, very little memory, or a
> very slow computer.
>
>
>
> On 03/02/2007 06:17 PM, bedul wrote:
>> ----- Original Message -----
>> From: "Micah Stevens"
>> To: "Roberto F Tavares Neto"
>> Cc:
>> Sent: Saturday, March 03, 2007 3:17 AM
>> Subject: Re: [PHP-DB] Mysql autentication problem
>>
>>
>>
>>> Strange. If you look at the users table, is there a password hash in the
>>> password field?
>>>
>>>
>>
>> i think this must be reload?? not just flush?? it happen to me..
>> or perhaps need some times to realy reload??
>>
>>> Roberto F Tavares Neto wrote:
>>>
>>>> Micah:
>>>>
>>>> I did create the database. Then, I use the:
>>>>
>>>> GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'password'
>>>>
>>>> to do the 2 and 3 steps.
>>>>
>>>> FLUSH PRIVILEGES
>>>>
>>>> to do the step 4.
>>>>
>>>> But the step 5 really does not work... only on the shell or when I
>>>> remove the password from the user...
>>>>
>>>> Roberto
>>>>
>>>> Micah Stevens escreveu:
>>>>
>>>>> Did you give the user permissions to use the database in question?
>>>>>
>>>>> Here's my sequence of actions:
>>>>>
>>>>> .
>>>>> 1) Create DB if it doesn't exist
>>>>> 2) Create the user w/password
>>>>> 3) Give the user permission to use the database.
>>>>> 4) Flush privileges to update the server.
>>>>> 5) login and enjoy.
>>>>>
>>>>> -Micah
>>>>>
>>>>> Roberto F Tavares Neto wrote:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> I'm trying to do a very simple thing: create a database and a user
>>>>>> to use it.
>>>>>>
>>>>>> So, initially, I use the web interface phpmyadmin. Logged as root, I
>>>>>> created the database, and the user with some password.
>>>>>>
>>>>>> But, I could not login using phpmyadmin. Either any php-based system
>>>>>> could connect to the BD.
>>>>>>
>>>>>> So, I make sure that I got the "user@localhost" and "user@%"
>>>>>> created, with permissions and same password. Nothing.
>>>>>>
>>>>>> But I *can* log on mysql shell.
>>>>>>
>>>>>> One more info: when the user is set without password, it works fine
>>>>>> on PHP.
>>>>>>
>>>>>>
>>>>>> Does anyone can give me a clue of what is happening?
>>>>>>
>>>>>> Thanks!
>>>>>>
>>>>>> Roberto
>>>>>>
>>>>>>
>>>>
>>>
>>
>>
>> ------------------------------------------------------------ ----------------
>> ----
>>
>>
>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>
>>
>

--------------030407060807010909090609--