Anton Mc Kee wrote:
>> INSERT INTO user (Host, User, Password, Select_priv, Insert_priv,
> Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
> Process_priv, File_priv, Grant_priv, References_priv, Index_priv,
> Alter_priv) VALUES ('localhost', 'UserName', 'PassWord', 'Y', 'Y', 'Y', 'Y',
> 'Y', 'Y', 'Y', 'Y', 'Y',
> 'Y', 'Y', 'Y', 'Y', 'Y')
This is not a great idea for two reasons:
1. You're giving full access to the user name over all the
databases. It's the equivalent of creating a user with uid 0.
2. You should almost certainly use "password('password_string')"
rather than 'password_string', as otherwise you won't be entering the
password you think you are entering.
Thomas Bridge 26 Upper Fitzwilliam St.,
Senior Hostmaster/Sysadmin, Dublin 2,
VIA NET.WORKS Ireland. Ph: +353 1 6763600
thomas.bridge at via-net-works.ie Fax: +353 1 6627674
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!