Switches, Hubs, and Modems
cancel
Showing results for 
Search instead for 
Did you mean: 

Accessing PCM+ DB using MySQL Tools

Michael Freymond
Occasional Visitor

Accessing PCM+ DB using MySQL Tools

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@' (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
5 REPLIES
cenk sasmaztin
Honored Contributor

Re: Accessing PCM+ DB using MySQL Tools

which runing operating system pcm+
and which language operating system
cenk

Michael Freymond
Occasional Visitor

Re: Accessing PCM+ DB using MySQL Tools

PCM is running on W2K3 x64 english.
cenk sasmaztin
Honored Contributor

Re: Accessing PCM+ DB using MySQL Tools

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]


cenk

Michael Freymond
Occasional Visitor

Re: Accessing PCM+ DB using MySQL Tools

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)

Jason Scott
Regular Advisor

Re: Accessing PCM+ DB using MySQL Tools

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.