> > Is it wrong to hand edit these tables? root with the
> > password "new_password" is a valid logon for this db.
> Don't touch MySQL privilege tables, except host table.
> That way you just mess up the things, as you did.
> Use GRANT / REVOKE / SET PASSWORD ..
OK - fair enough - two questions though.
Can I just hand delete the records that I manually inserted?
What is the syntax of the grant?
I log on as the root to the MySQL db and then I want to grant a user "root"
password, "new_password" all possible privilges from a machine with
ip_address
of xx.yy.zz.aa and all of this on a database called "bugs".
Grant all to root on bugs?
Thanks for the help so far.
Paul...
---------------------------------------------------------------------
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