Shawn Sharp wrote:
Dilipkumar,
Thanks much for the tip....it did the job!
Now we query mysql to see if the new mysql database is seen by mysql and it
still only sees test:
No, you can't see the mysql db, because you don't have permission to access it.
I expect you are still logged in as the anonymous user, who can only work with
the test db. You have some reading to do. You've run mysql_install_db, now you
need to secure the initial accounts:
<http://dev.mysql.com/doc/refman/4.1/en/default-privileges.html>.
Next you'll want to read up on how mysql's privilege system works:
<http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html>
Then you should read about creating and managing user accounts:
<http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html>
[EMAIL PROTECTED]:/usr/bin> mysqlshow
+-----------+
| Databases |
+-----------+
| test |
+-----------+
[EMAIL PROTECTED]:/usr/bin>
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
