March 03, 2007 1:48 PM
*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:
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:
> Sent: Saturday, March
2/2007 06:17 PM, bedul wrote:
> > - Original Message -
> > From: "Micah Stevens" <[EMAIL PROTECTED]>
> > To: "Roberto F Tavares Neto" <[EMAIL PROTECTED]>
> > Cc:
> > Sent: Saturday, March 03, 2007 3:17 AM
> > Subject: Re: [
Yep, there is a hash... and the hash is valid - I can connect using the shell
with this password...
On Fri, 02 Mar 2007 12:17:33 -0800, Micah Stevens wrote
> Strange. If you look at the users table, is there a password hash in
> the password field?
>
> Roberto F Tavares Neto wrote:
> > Micah:
>
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 St
oberto F Tavares Neto" <[EMAIL PROTECTED]>
Cc:
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?? i
- Original Message -
From: "Micah Stevens" <[EMAIL PROTECTED]>
To: "Roberto F Tavares Neto" <[EMAIL PROTECTED]>
Cc:
Sent: Saturday, March 03, 2007 3:17 AM
Subject: Re: [PHP-DB] Mysql autentication problem
> Strange. If you look at the users tab
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
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...
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 Tav
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...
bastien
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
]>
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 us
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
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 o
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
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 connec
17 matches
Mail list logo