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