At 6:36 PM +0800 11/23/01, you wrote:
>Hello Glenn,
>
>
>> There is a program called mysqlaccess that allows you to try access
>>privleges for other users/tables. I would look at the data in the
>>mysql.yser table and delete the extraneous bits (e.g., other than
>>localhost/root) and rebuild them.
>>
>
>I was able to look at the data in mysql.user, but I don't which
>parts to remove. There were some words scattered all over with a
>series of ^B^B^B and +-+-+-.
>Forgive my ignorance in this, would you please tell what these are
>and what do I need to delete?
>Using "select * from mysql.user;" would show the contents but will
>not be able to edit it, how do i edit it?
>
To delete lines try (at the mysql prompt)
DELETE FROM mysql.user WHERE user='userid' and host='hostname'
To add lines
INSERT INTO mysql.user SET host='hostname', user='userid',
password=PASSWORD(clear_password), select_priv='Y'
There is an excellent searchable manual at <http://www.mysql.com/doc/>.
--
--
Glenn Henshaw | Ottawa, Canada
Play: [EMAIL PROTECTED] | Work: [EMAIL PROTECTED]
_______________________________________________
Seawolf-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/seawolf-list
