, 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
I did the reload, but with no effect...
On Sat, 3 Mar 2007 09:17:36 +0700, 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
*Subject:* Re: [PHP-DB] Mysql autentication problem
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
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
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
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
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';
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
From: Roberto F Tavares Neto [EMAIL PROTECTED]
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
Ted,
The [EMAIL PROTECTED] 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 [EMAIL PROTECTED] from
mysql command line. It fails too...
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
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...
Strange. If you look at the users table, is there a password hash in the
password field?
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
- 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
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
Subject: Re: [PHP-DB] Mysql autentication problem
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
16 matches
Mail list logo