PowerDNS (with SolusVM ) mysql

Some examples for solusvm mysql db

Solusvm DB name looks like some ID.

mysql

show databases;
use <solusvmDBname_likeID> ;

show tables;

show all servers with IP like specified:

 select vserverid, mainipaddress, hostname from vservers  where mainipaddress like '185.31%'; 

change some record example:

UPDATE vservers SET mainipaddress = '10.10.10.143' WHERE ctid=5342;