MySQL DB access ?

[filobeddo]

Hi,

Being and age-old tinkerer I decided today was the day to take a look at our Scrutinizer database to see what weird and wonderful reports I could I could come up with.

I read around this forum a while and found that people do this also. I followed the advice to install MySQL Workbench but ran into a problem when I tried to make a connection.

I am aware that I need to connect from the box Scrutinizer is install on. It's a Win2008R2 install which I am RDP'd to.

To keep it simple, for the sake of this post, I opened a CMD windows as administrator and ran this:

Code: Select all

C:\Program Files (x86)\Scrutinizer\mysql\bin>mysql.exe -u root

I get the following error message:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

In MySQL WorkBench the error is more 'did you try this, this ... etc'.

Googling around on the error I thought it might be that I needed to do:

Code: Select all

mysql.exe -h 127.0.0.1 -u root

Someone noted that localhost and 127.0.0.1 are not the same from the sql authentication point of view.
No joy, same error.

I understood that there is no password for the root account. Is this correct?

A couple of point re our Scrutinizer installation which may or may not be pertinent:

My server has several IP addresses. I have two on separate NICs for my iSCSI storage and I have a secondary address on my primary NIC which the flows are collected. I should'nt have thought this would make any difference but who knows ?

The MySQL database was moved to another drive (my iSCSI LUN). I followed the instructions from Plixer on how to do this.

Any ideas are appreciated.

[tomp]

Hi filobeddo

If the root password isn't *blank* be default, it was set during installation. If you can't recall what it was set to, you can change the root password.

Open a command prompt on the Scrutinizer server, navigate to [HOMEDIR]\Scrutinizer\bin and run:

scrut_util.exe -reset_mysql_password

After changing the root password run:

scrut_util.exe -update_plixerini_mysqlroot

This will update the plixer.ini file with an encrypted version of the root password.

Let me know if that doesn't get you in.

- Tom

[filobeddo]

That did it, thanks!

I must have set one in the installation dialogue. Doh!