Re users in mysql

2002-09-23 Thread Peter Goggin 

I have set up mysql under redhat 7.3 and imported the database from mysql
running on windows.

I have the root user running using passwords, but i cannot get the other
users to log on even thogh the passwords shoudl have been carrid across with
the import.

I have tried to reset the user passwords but still cannot get a logon.

For exmple if i log on and change a user password with:

GRANT INSERT ON stamps.customers TO reguser@'%'
IDENTIFIED BY 'regpassword';
 should let me log on as

mysql -D stamps -u reguser -pregpassword

I get the error message:
ERROR 1045 Access denied for user 'reguser@localhost' (Using password = YES)

I have tried changing the password with
update mysql.user set password = PASSWORD('regpassword')  and this does not
help

Can anyone suggest what I need todo?

Do I need to drop the users and run the full set of grant scripts again?

Regards

Peter Goggin


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: users in MySQL

2001-07-03 Thread Sherzod Ruzmetov 




Sent on Jul 3 by Daniel Aderhold to [EMAIL PROTECTED]

aderho Can anyone give the adress of another manual of MySQL (not from mysql.com).

Why is that ??? The manually you're not willing to use is indeed the *official*
manual, which also means the more comprehensive one you can think of. If you
don't find that comprehensive, there're none (I believe) to please you

Sorry

-- 
sherzod_ruzmetov (sherzodR)
email: [EMAIL PROTECTED]

I wasn't recommending that we make the links for them, only provide them
with the tools to do so if they want to take the gamble (or the gambol).
 -- Larry Wall in [EMAIL PROTECTED]




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php