Mysql

[kong1]

Labdien, gribēju pajautāt kā izslēgt mysql remote accsess? būtu ļoti pateicīgs ja kāds pateiktu!

[ZhaKS]

te Edited November 14, 2009 by ZhaKS

[kong1]

mazliet precizāk nevar? :/

[GEAR]

4.1 Disable remote access

The first change applies to the 3306/tcp port, on which MySQL listens by default. Because, according to the initial assumptions, the database will be used only by locally installed PHP applications, we can freely disable listening on that port. This will limit possibilities of attacking the MySQL database by direct TCP/IP connections from other hosts. Local communication will be still possible throw the mysql.sock socket. In order to disable listening on the mentioned port, the following parameter should be added to the [mysqld] section of /chroot/mysql/etc/my.cnf:

skip-networking

If, for some reason, remote access to the database is still required (e.g. to perform remote data backup), the SSH protocol can be used as follows:

backuphost$ ssh mysqlserver /usr/local/mysql/bin/mysqldump -A > backup

[kong1]

kur šadu vietu atrast ??

[mysqld] section of /chroot/mysql/etc/my.cnf:

Edited November 14, 2009 by kong1

[kRi]

Kur, kur...uz HDD. Kas par OS?

[GOMA smile]

Nespregā 4alīt ņem un atrodi win32

[kRi]

Es teicu, ka iekš Win ir? Autors tā arī nav minējis kas viņam par OS.