Chapter 12 . Security 311 Cross-In Chapter 13 (Web host 4 life)
Chapter 12 . Security 311 Cross-In Chapter 13 backup and recovery of MySQL databases is covered in detail. Reference Since the upgrade process is quite customized (depending on your installation), exhaustive coverage is neither possible nor desirable here. Often the solution is as simple as recompiling or overwriting an existing MySQL installation. Run the server as a non-privileged user In Linux/Unix, you can set the user account that runs the MySQL server process, mysqld. (This is as opposed to running the server process as the rootsuperuser on the system.) Figure 12-4 shows a process listing from Linux, with the server running as a non-privileged regular user called mysql. Figure 12-4: Running the MySQL server as a non-privileged user can prevent unauthorized access in the event of an exploit performed on the server. By running the server as a normal user in Linux/Unix, the server only has the same privileges as that user. In other words, if the server is exploited the attacker cannot gain further access or perform other privileged processes on the server. To enable MySQL to run as another user on the system, follow these steps: 1. Add the user, and if desired a group, to the server. This is normally accomplished via the useraddand groupadd commands. 2. Make sure the user has access to the data and server files for MySQL. This step is accomplished with a combination of chown and chmodin Linux. 3. Add the –user=username option to the mysqld command line, or add the line user = username to the my.cnf file under the [mysqld] section.
Looking for affordable and reliable webhost to host and run your business application? Then look no more and go to servlet web hosting services.