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
