I typed show Grants for root@localhost; and saw that the root has all permissions other then select. I can delete , insert data into the tables of all the databases but cannot select. How can i give the root@localhost 'select' permissions.
show grants for root@localhost displays: Grant insert,update, delete,create,drop, reload, shutdown,process, file,alter on *.* to 'root'@'localhost' with grant option Help is greatly appreciated, Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -----Original Message----- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 1:26 PM To: 'MySQL Mailing list' Subject: Permission problem I created a new database on mysql server using Telnet. Before creating it i could log onto telnet as su root and select,delete , insert data into the mysql database and every other database. After creating this new database now when i try to type in USE MYSQL, it changes to the mysql database . And when i type in mysql> select * from user; i get error message: Select command denied to user 'root@localhost' for table 'user' Where did i go wrong .. please help... i get the same error message when i try to use ne other database even the one i created just now. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
