sslug-teknik team mailing list archive

sikker backup af mysql db

To: sslug-teknik@xxxxxxxx
From: Atte André Jensen <atte@xxxxxxxxxxxxxx>
Date: Fri, 27 Feb 2009 10:56:11 +0100
Delivered-to: mailing list sslug-teknik@xxxxxxxx
Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAAXNSR0IArs4c6QAAABhQTFRF ExQSMzUyTE5LamxpiIqHq62p0NLP6uzoQWtXFgAAAgJJREFUOMtlk9114yAQhdkODEnOPgvZKQDs FBAgDVjDNmBGFVhqP3dAMvZZHufjcucPxczzWg/TFGMM3ls5iucOEI++g9IAc3lV8L2C5T9QlicQ EHe7ojlswHcwdxBF0eI1qx0gXe/Hbh6rhgvRJC91DxKwEFXB+cmDHmWHV1AQn+Hs23GD1g0s4ly8 9V4sLOLa7OkuHEmbMQWJm6c6Fl6z8/ZCQe7rXjnALTh7KddBH9T2VANLCW784YD7qmpUnZOUDZDv 37hthk3BDUSf5uI2hw7QjsRr2Yp4AZTn9easfqTbAFqY1/WGSFOMDawNLFeEhqo4Kd7SworMS7D7 +XwCfr4Ht4OfDTBP4QKwOdiRd1Am/7WWYIcGjh0EH/PNb9b2UwD9kwH6RHR7VPHF6vug/gJMF0rS dNNAZvUW/UlAphSd081kZFZHO6Z5LcREAIOpaZ0EnNG8hXNBu5yHt6nerE5J9orpKn/DWWOkvUdi 9UGEPeEpyaLIgshbGK/6iGg3CieUUgHctcJ5j3gKrUJ3J5kGBMNBwNuU5jqPKU1eCGYocaUF4C1k G6tC60MDMVZQ96QB1cB7zHVNADCnh0BpE8SkIDHfJDvQ45nR9oyJ4Avs1gKMz/IQyU/uFnVRLwAl BVvBoQM9ZtQR4TB0gfojbThnrKh7KmID2iQI8L+7tfoFfr8bM7YNgScAAAAASUVORK5CYII=
Mailing-list: contact sslug-teknik-help@xxxxxxxx; run by ezmlm
Newsgroups: sslug.teknik
Organization: SSLUG
User-agent: Thunderbird 2.0.0.19 (X11/20090105)

Hej

Jeg har et script som vha mysqldunp tager backup af min mysqldatabase.Problemet er at der pt står root's password i klar tekst i dette script.

Hvad vil være en god løsning på dette problem? Kan man fx lave en brugeri mysql som kun kan dumpe (eller måske snarere "læse") databaser?


--
Atte