-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello Marcus,
i think you forgot the mysql> flush privileges; Regards, Sherwin T. Ang Web Technical Administrator / Programmer Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Philippines Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - ----- Original Message ----- From: "Marcus - Videomoviehouse.com" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 6:59 PM Subject: Is Addition To Previous Post > Here are some results from what I have tried in a addition to my > previous post. > > mysql> GRANT ALL ON *.* TO root@localhost IDENTIFIED BY 'pasword'; > ERROR 1045: Access denied for user: 'root@localhost' (Using > password: YES) > mysql> show GRANTS for root@localhost; > +------------------------------------------------------------------- > ---- -------------------------------+ > | Grants for root@localhost > | > +------------------------------------------------------------------- > ---- -------------------------------+ > | GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD > '5555555555' WITH GRANT OPTION | > +------------------------------------------------------------------- > ---- -------------------------------+ > 1 row in set (0.00 sec) > > mysql> > > I can set the USAGE setting but anything else I get access denied, > I have run out of options please help. I am guessing next thing > would be to re-install mysql and rebuild the server? If I copy my > tables from my var directory can I copy them back after and have it > work? -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPKtVhXHqbCYZYnEDEQKL/gCgjLOVigDDvxjMBIi2QThzPgVaJngAoOGo hdlQjc3d/cqjqDcLwY3GxS4Z =GpJj -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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
