zm_database_init ERROR

alexolait · Post by **alexolait** » Tue Sep 08, 2009 3:14 pm

Hello

I try to update zone minder from 1.24.1 to 1.24.2 but when i launch zm_database_init i have this error:

Giving all priviliges to zm_admin on database zm
ERROR 1045 (28000) access denied for user root@loalhost using password:YES

Have you got any idea about this error ?

Thanks for your help

NokSuKao · Post by **NokSuKao** » Thu Sep 10, 2009 11:49 am

Hi,

set the root password in /root/.my.cnf. Then it should work. So it solved the problem.

greetz

NokSuKao

alexolait · Post by **alexolait** » Fri Sep 11, 2009 5:15 pm

i have tried to put the password in the .my.cnf and to delete it but i have the same problem
This solution was posted in another forum topic.

I don't understand ....

If you have any other idea

monex · Post by **monex** » Fri Sep 11, 2009 8:02 pm

Hi,

you should delete /root/.my.cnf as suggested and the password should not be empty. You can try to connect to mysql by entering "mysql -u root -p". If this failed you've not configured your mysql correct.

Hope this helps

alexolait · Post by **alexolait** » Sat Sep 12, 2009 2:25 pm

i have a password for mysql. (for root and zm_admin
i have no probem to enter in mysql with root user and zm_user and my password

always the same problem...

monex · Post by **monex** » Sun Sep 13, 2009 8:06 am

Hi,

that's curious, can you check if the password for user root equals the password in the .my.cnf in /root/.my.cnf. and that user root is the user, for example the .my.cnf should look like:

Code: Select all

[client]
user=root
password=<secret>

you can verify the correctness of the .my.cnf by typing mysql as root which should log you in to mysql as user root without password.

Btw. you are running zm_database_init as user root aren't you? As far as I remember it is not possible to run it as normal user but just to make sure that this isn't the cause of failure.

Hope this helps

alexolait · Post by **alexolait** » Sun Sep 13, 2009 8:57 am

hello,

i'm logged in root
when i try to connect to mysql with root user and my password , it works
mysql -u root -p ...... no problem

I have edited .my.cnf and put the password after password=*******

i try to connect with the command mysql -u root and i have the access denied message and zm_init_database doesn't works

really i don't understand....

monex · Post by **monex** » Sun Sep 13, 2009 10:44 am

Hi,

that's really curious now

The zm_database_init script relays on the .my.cnf configuration because it is only a wrapper script which calls the mysql command. The script should work when you can just enter "mysql" without any options (no user or password specified) and you get the mysql command prompt.

So far the theory

One thing which is also possible is that you've mistakenly entered the system root password and not the mysql root password to .my.cnf file. That would result in the described error.

You can also have a look at /etc/my.cnf which contains the global mysql configuration. You can check if it differs form original configuration by running rpm -q mysql --verify which should give no changes (empty result) when nothing was changed.

You see I'm currently running out of ideas what could cause this error

Hope this helps