Gerald posted good instructions for doing proper privileges, but: Login as root, and execute this command:
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'yourpassword';
This will apply permissions for user stw from host 127.0.0.1. You'll need a password to login. Run:
mysql -u stw -p
...enter the password when prompted, and you're in.
- Jim
On Monday, October 13, 2003, at 11:20 AM, Stephan Wölfel wrote:
thanks for the advise.
What you tell all works. But even after this I still get the same error 1045
when typing "grant all on *.* to stw". Why ?
----- James Cradock, [EMAIL PROTECTED]
me3 Technology Consultants, LLC 24 Preble Street Portland, Maine, USA 04101
207-772-3217 (office) 207-838-8678 (mobile)
http://www.me3.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]