opsview ( not able to create database using mysql)

rajiv.patil82 · 08-12-2010, 03:06 AM

Hi All,
After the Opsview packages have been installed, it is necessary to configure Opsview and its databases.

but while running below command get an error,

#mysqladmin -u root password {password}
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using pa

please help. thanx in Advance

Wim Sturkenboom · 08-12-2010, 03:47 AM

I assume that the exact error is like

Code:

wim@btd-techweb01:~$ mysqladmin create somedb
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'wim@localhost' (Using password: NO)'

You're trying to set a password for the mysql root user. If that root user already has a password, you have to provide the existing password as well.

rajiv.patil82 · 08-12-2010, 04:42 AM

provide the same but still same error access denied for root@localhost

druuna · 08-12-2010, 04:51 AM

Hi,

You information is very scares.....

- Is this a fresh mysql install or is it already up and running with other databases?
- In order to use the mysqladmin command, mysql must be running, is that the case?

What do you mean by this: provide the same? Please post the command(s) you tried and the full error message.

Hope this helps.

rajiv.patil82 · 08-13-2010, 12:49 AM

i have remove mysql and reinstalled again now working fine. opsview has been installed properly. thanx a ton ...