Hi Everybody Commands:
mysql -uroot
mysql> grant select,insert,update,delete on try.TBL_MACIP to 'tryAdmin1'@'localhost';
mysql -utryAdmin1
mysql> use try mysql> select * from TBL_MACIP;
/etc/init.d/mysql restrat mysql -utryAdmin1
mysql>use try ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'try'
mysql>show grants for 'tryAdmin1'@'localhost'; No privilege is set.
Using Server version 4.1.1-alpha-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
OS i686 GNU/Linux (RH9)
Used RPM to upgrade from 3.23 to 4.1.1
Should I send this problem as BUG? Any Suggestion/HELP!!!
Thanks in Advance.
with regards Udbhav Shah B.E (Computer Engg) Ahmedabad,Gujarat India
=====
Thinking is the Assets
Enterprise is the Way
Hard Work is the Solution
- Ignited Minds
__________________________________ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com
Refer to http://www.mysql.com/doc/en/Upgrade.html. There are quite a few tasks you need to perform to upgrade, like changing privilege tables. The above link gives the steps that need to be performed for upgrading to a later version
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
