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
