If you do not use the GRANT, REVOKE, and DROP USER statements to create and destroy user accounts, you must manually FLUSH PRIVILEGES. It's all documented in the manual:
http://dev.mysql.com/doc/mysql/en/GRANT.html and in even more detail here: http://dev.mysql.com/doc/mysql/en/User_Account_Management.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Yong Wang" <[EMAIL PROTECTED]> wrote on 08/24/2004 03:15:39 PM: > Hi, all: > I use root login to create a new databse in the existing server. > Then I use the existing user name in the mysql user table as user name, > add the database and username .. info into mysql db table. Then > mysqladmin to load the table. When I login the database using the > existing user name, I > only can see previously existing database without seeing the new added > database. What is the problem ? > Thanks a lot. > > Yong > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
