hello all,
i would like to put a problem as what iam facing... i created a new database
new user, but i didn't give the password...
then i logged in to mysql
ie
c:\mysql\bin mysql
then
mysql use mysql
then
mysqlupdate user set password=password('pswd') where user= 'username';
then i got the
Everytime you use UPDATE, INSERT, DELETE to update user privileges you
must do a FLUSH PRIVILEGES for changes to take effect.
Check the manual:
http://www.mysql.com/doc/en/Privilege_changes.html
On Tue, 2003-02-18 at 11:57, Ganesh Rajan wrote:
hello all,
i would like to put a problem as
Message -
From: Diana Soares [EMAIL PROTECTED]
To: Ganesh Rajan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 8:59 PM
Subject: Re: problem in connecting to DB
Everytime you use UPDATE, INSERT, DELETE to update user privileges you
must do a FLUSH PRIVILEGES for changes
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 10:26 AM
Subject: Re: problem in connecting to DB
Thanks for the response but as the document states to RUN mysqladmin
flush-privileges and mysqladmin reload i tried bothways... but in
vain
... i still get
@localhost wherein it should give me as
username@IPaddress
Thanks
Ganesh Rajan
- Original Message -
From: Ganesh Rajan [EMAIL PROTECTED]
To: Diana Soares [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 10:26 AM
Subject: Re: problem in connecting to DB