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 [EMAIL PROTECTED]
To: Roberto F Tavares Neto [EMAIL PROTECTED]
Cc: php-db@lists.php.net
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] and [EMAIL
PROTECTED]
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