Re: the GRANT command
Re: the GRANT command
- Subject: Re: the GRANT command
- From: Craig Sutherland <email@hidden>
- Date: Sat, 8 Nov 2003 22:27:48 -0600
John-
Make sure you have the sql prompt > which shows mysql is running. Make
sure you are using the mysql database.
a startup command is-- mysql mysql -u username -ppassword.
Syntax for grant is-- grant all privileges on *.* to user@localhost
identified by 'password';
then grant all privileges on *.* to user@"%" identified by 'password';
Those are very very broad privileges and provide minimal security. This
need to be tuned to fit your particular needs.
Craig Sutherland
"Who is John Galt"
On Nov 8, 2003, at 8:59 PM, John Blumer wrote:
> Hello,
> Now that we are using .bash in X11 1.0, the "GRANT ALL PRIVILEGES on
> *.*" is not recognized for MySQL database. This may not be the best
> group for me to ask, but all of these things get a little convoluted.
> If someone knows about this, please let me know the correct command.
> Thanks
> --
> "Don't employ worry, it doesn't work."
> JB aka Col. Panic
> _______________________________________________
> x11-users mailing list | email@hidden
> Help/Unsubscribe/Archives:
> http://www.lists.apple.com/mailman/listinfo/x11-users
> X11 for Mac OS X FAQ: http://developer.apple.com/qa/qa2001/qa1232.html
> Report issues, request features, feedback:
> http://developer.apple.com/bugreporter
> Do not post admin requests to the list. They will be ignored.
_______________________________________________
x11-users mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/x11-users
X11 for Mac OS X FAQ: http://developer.apple.com/qa/qa2001/qa1232.html
Report issues, request features, feedback: http://developer.apple.com/bugreporter
Do not post admin requests to the list. They will be ignored.