Comware

Hi,

I am running PCM + version B.02.322.

I am attempting to connect to the database using MySQL tools to run my own queries against it.

I am unable to do so successfully. When I attempt to connect (on port 3908), it gives the following error:

Could not connect to the specified instance.

MySQL Error Number 1045
Access denied for user 'Administrator@<MY_COMPUTER_NAME>' (using password: YES)

It seems that this is possiable - I'm not sure what I'm doing wrong.

The version of the MySQL tools that I attempting to connect with is the MySQL Administrator version 1.2.12.

Any help would be appreciated.

Thanks</MY_COMPUTER_NAME>

which runing operating system pcm+
and which language operating system

PCM is running on W2K3 x64 english.

please check SQL database connection
use the mySQL.exe file to connect to the pcm database.

mysql.exe is found in the pcm server at:

\Program files\hewlett-packart\pnm\server\mysql\bin

once at the prompt you will need to type in the executable name that you want to run along with the executable variables.In this case the executable is the mysql.exe whit following variables.

port 3908
user [the pcm user with external database access privileges]
password[password of pcm user mentioned above]
netmgmt [name of the database]

I checked and made sure that the administrator account has the 'External DB Access' enabled.

I've run the following command from the server:

mysql --port=3908 --password=password --user=Administrator netmgmt

And it coughs up this error:

ERROR 1045 (28000): Access denied for user 'Administrator'@'localhost' (using password: YES)

I did this a while back with MySQL tools. My connection dialog shows my username but no password or connection schema. I believe on the server I had to create a basic account to enable this access but for the life of me I cannot recall what I did.