How to remotely administer MySQL

Discussion in 'Databases' started by ianmc, Feb 16, 2012.

  1. I've got the old PHPBB working lovely, had a bit of a problem with spammers so I set the option for the administrator (that'll be me then) to approve new registrants and that has solved it but since nasty spammer person posted 138 messages about how to lengthen certain parts of the body the database size has shot up to 5mb ... at this rate I'll use up my 200mb quota in no time so I was thinking of administerizing the MySQL database to see if I can prune that size down again.

    Using MySQL Workbench however I haven't figured out how to enable remote administration, it wants either a Native Windows Management connection or an SSH connection.

    Anyone got any tips on how to do that?

    Also, when I do get remote administration working does anyone know which bits I should be administratifying to keep the MySQL database size nice'n trim and if so will the same techniques work on my beer belly?

    Thanks in advance :D

    ian
     

Share This Page