Could not select database: Unknown database 'zm

Forum for questions and support relating to the 1.25.x releases only.
Locked
User avatar
teraquad
Posts: 90
Joined: Fri Mar 09, 2012 2:03 pm
Location: New Bern, NC

Could not select database: Unknown database 'zm

Post by teraquad »

Hi,

I just installed Zoneminder and am having this error (Could not select database: Unknown database 'zm). Knowing nothing about mysql i am hopeing someone can guide me to the right conclusion. I am guessing the database needs to be set up and i am wondering what other first run problems i willl see with ver 1.25. Any help would be appriceated.

Thanks!
Fedora 23, ZM 1.28
N4ZPO (ham Radio)
8)
bb99
Posts: 943
Joined: Wed Apr 02, 2008 12:04 am

Re: Could not select database: Unknown database 'zm

Post by bb99 »

Try in a terminal:

Code: Select all

su

(enter root password)

mysql mysql < /usr/share/zoneminder/db/zm_create.sql

mysqladmin reload

mysql mysql

grant select,insert,update,delete on zm.* to 'zmuser'@localhost identified by 'zmpass';

\q

exit

exit 
User avatar
teraquad
Posts: 90
Joined: Fri Mar 09, 2012 2:03 pm
Location: New Bern, NC

Re: Could not select database: Unknown database 'zm

Post by teraquad »

Thank you very much, that is just what i needed. Now i am on my way!

Thanks!
Fedora 23, ZM 1.28
N4ZPO (ham Radio)
8)
bb99
Posts: 943
Joined: Wed Apr 02, 2008 12:04 am

Re: Could not select database: Unknown database 'zm

Post by bb99 »

Perfect!
Locked