Problem with database on install

[rlefeve]

I have been struggling with this for a little over a week now.
After I go thru the perl ./zmconfig.pl and answer all questions successfully, I go on to section 5 in the in the zoneminder readme.
I fail right at the first step "mysql mysql < db/zmschema.sql".
My error is "ERROR 1044 (42000) : Access denied for user ' '@'localhost' to database 'mysql'

I am new to databases so I am guessing that my problem is my command syntax and I do not know any better than to use the commands in the readme verbatim.

Any and all help would make my day (or week)

[rlefeve]

I forgot to add that I am using the ZM-1.21.4 package.

[rlefeve]

I think i have found the problem, I am lacking a mysql databse.
The mysql database, from what I understand has the users and passwords in it.
I am going to re-install the mysql package and see if that will work.

[jameswilson]

it would appear you have no user name in your sysntax, but i have never built it this way i always use, cordel's and ross's rpm's

Sorry
James

[cordel]

You should be able to follow the readme verbatim. The problem your having is that you are not logged in as root I suspect.

Try entering like this
mysql -u root -p mysql < db/zmschema.sql

The password unless you added one will be blank.

Regards,
Corey

[rlefeve]

The reason I thought the mysql database was not there was when typing the command "show databases;" the only database that would show up was test. I did this as admin

Anyhow I did enter the command you suggested as root with the password I set and my error has changed to "ERROR 1050 (42S01) at line 13: Table 'Config' already exists.

[cordel]

Then you may just need to load the database.
This is done with:
perl zmconfig.pl -noi

Regards,

[rlefeve]

Now I have it to the point where I should be able to start it up and go with it but when I do I get an error.
I enter "zmpkg.pl start'
and I get
'No such file or directory at /usr/local/bin/zmpkg.pl line 164'

[rlefeve]

Ok I got it started.