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 new user is
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 password
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. The
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-
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 instead