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 <tavares@dep.ufscar.br> 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@dep.ufscar.br> 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 <mailto: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 <mailto:tavares@dep.ufscar.br> tel +55 16 3351-9240 http://www.dep.ufscar.br/docentes_desc.php?uid=165 ------------------------------------------------------------------------------------