Re: Mysql autentication problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <tavares@xxxxxxxxxxxxx> 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 <tavares@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx <mailto:tavares@xxxxxxxxxxxxx>      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@xxxxxxxxxxxxx <mailto:tavares@xxxxxxxxxxxxx> 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux