Cannot monitor mysql server

Hi,

Yesterday I added MySQL to my machine and want to monitor with Zenoss. I've added the username, port and password as required. I've also got access to the database from the zenoss server of which I've already verified, and it works. However, Zenoss still doesn't show me any statistics in the graphs. All values are still -nan.

I've ran zencommand -v10 -d 192.168.1.10

which is my machine.

events: [{'component': 'MySQL',
'device': '192.168.1.10',
'eventClass': '/App/MySQL',
'eventKey': 'Timeout',
'severity': 0,
'summary': 'Datasource MySQL/mysql command timed out'},
{'component': 'MySQL',
'device': '192.168.1.10',
'eventClass': '/App/MySQL',
'eventKey': 'mysql',
'message': 'STATUS OK',
'performanceData': [],
'severity': 0,
'summary': 'STATUS OK'}]
values: []})]

as you can see here, performanceData is blank. How, whilst the summary says Datasource timed out, this in my opinion is wrong, because Apache monitoring works - example:

events: [{'component': 'apache',
'device': '192.168.1.10',
'eventClass': '/App/Apache',
'eventKey': 'Timeout',
'severity': 0,
'summary': 'Datasource Apache/apache command timed out'},
{'component': 'apache',
'device': '192.168.1.10',
'eventClass': '/App/Apache',
'eventKey': 'apache',
'message': 'STATUS OK',
'performanceData': ['slotDNSLookup=0 totalAccesses=347 slotReadingRequest=0 totalKBytes=4022 busyServers=1 slotKeepAlive=0 slotGracefullyFinishing=0 bytesPerReq=11869 cpuLoad=.00228628 bytesPerSec=61.5431 slotLogging=0 slotSendingReply=1 slotStartingUp=0 reqPerSec=.00518522 slotWaiting=9 slotOpen=140 idleServers=9'],
'severity': 0,
'summary': 'STATUS OK'}]
values: [(({}, 'bytesPerReq'), 11869.0),
(({}, 'cpuLoad'), 0.00228628),
(({}, 'slotDNSLookup'), 0.0),
(({}, 'slotKeepAlive'), 0.0),
(({}, 'slotLogging'), 0.0),
(({}, 'slotOpen'), 140.0),
(({}, 'slotReadingRequest'), 0.0),
(({}, 'slotSendingReply'), 1.0),
(({}, 'slotWaiting'), 9.0),
(({}, 'totalAccesses'), 347.0),
(({}, 'totalKBytes'), 4022.0)]})

so, as you can see, Apache works, but why isn't MySQL getting the data I'm using the root user of MySQL, so there shouldn't be any problem.