mysqladmin -uroot -ppassword reload
Curtis
On Tue, 24 Jun 2003, Riaan Oberholzer wrote:
> Hi,
>
> I am created a user by using:
>
> GRANT ALL ON *.* TO username@"%" IDENTIFIED BY
> "password"
>
> I did this from the mysql command line tool, logged in
> as root. The command succeeds and the n
The problem is that when I only define the "%" host,
then no password is required to log in... (not a
wanted feature!). I CAN log in, i just have to specify
no password.
The password checking is only done for localhost
--- [EMAIL PROTECTED] wrote:
> What about using the username only instea
What about using the username only instead of username@"%" ?
According to manual (section 7.34) it should be identic in behaviour:
[...]
The simple form user is a synonym for user@"%".
[...]
Does it do the same?
Lian
P.S. Andy, sorry for posting by mistake to you. ;-|
> -Original Message-
To also add priviliges on the local machine
GRANT ALL ON *.* TO username@"localhost" IDENTIFIED BY
"password"
Riaan Oberholzer wrote:
Hi,
I am created a user by using:
GRANT ALL ON *.* TO username@"%" IDENTIFIED BY
"password"
I did this from the mysql command line tool, logged in
as root. Th
I don't know if this apply when using GRANT but have you tried afterwards:
> flush privileges;
HTH,
Lian
> -Original Message-
> From: Riaan Oberholzer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 9:19 AM
> To: [EMAIL PROTECTED]
> Subject: Problem setting/activating passwo
