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:
and in even more detail here:
Unimin Corporation - Spruce Pine
"Yong Wang" <Yong-Wang@stripped> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1