Michael, group; Thanks much for the directions....I followed them and solved my problem!!!
Now I've got this issue and I'm not sure what syntax to use to get this script to run: [EMAIL PROTECTED]:~/ZoneMinder-1.22.0/db> vi zm_create.sql.in [EMAIL PROTECTED]:~/ZoneMinder-1.22.0/db> mysql mysql < zm_create.sql.in ERROR 1045 (28000): Access denied for user 'frank'@'localhost' (using password: NO) It wants to default to the OS user who is logged in and that user is NOT in the mysql database and does not need to be. I tried to insert the -u root but got a syntax error . Any ideas? On 3/26/06, Michael Stassen <[EMAIL PROTECTED]> wrote: > > 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 > -- Frank DeLaTorre 408.390.0415
