Useful XAMPP operations

Recently, I have learned PHP for my work and published some content here. I can only release android.

1. Improve Security

After XAMPP is installed, some default settings are insecure. For example:

1. XAMPP can be accessed by anyone, as long as your machine is connected to the Internet and others know your IP address.

2. Your MySQL Root User Password is blank. Outsiders can also use your MySQL through the network.

3. By default, the MySQL graphical management software phpMyAdmin does not have a password.

We can directly enter sudo/opt/lampp Security

Set the password as prompted.

Remember the password after setting, because there are several settings.

2. Common XAMPP commands

1. Run/opt/lampp start

/Opt/lampp stop

2. The command to switch to PhP4 is:

/Opt/lampp PhP4

The command to switch to PhP5 is:

/Opt/lampp PhP5

If you forget the PHP version you are using, run the following command:

/Opt/lampp phpstatus

3. Other startup parameters are as follows:

Restart restart XAMPP

Startapache only starts Apache

Startssl enables SSL support for Apache

Startmysql

Startftp start ProFTPD

Stopapache stops Apache.

Stopssl stops Apache SSL support

Stopmysql

Stopftp stop ProFTPD

3. Useful Tools for XAMPP Integration

1. phpMyAdmin

PhpMyAdmin is a very practical MySQL database management and operation tool written in PHP. You can use a web browser to create and delete databases, add, delete, and modify table structures and table data, you can also submit query statements in the form to return data results.

2. phpsqliteadmin

Since SQLite is small and efficient, and its perfect combination with PHP, It is favored by more and more people. XAMPP not only integrates the SQLite database, but also integrates phpsqliteadmin, a Web browser tool for managing it.

3. Webalizer

Webalizer is an efficient and free web server log analysis program. The analysis results are saved as HTML files, which can be easily viewed on the Web server. Many websites on the Internet use Webalizer for Web server log analysis.

Iv. data backup and recovery

1. Backup

As part of system security protection, timely and comprehensive backup is an essential task. The configuration files and logs of databases and various software often make the Administrator dizzy and will miss one accidentally. XAMPP makes this work very simple. You can enter the following command to complete it:

/Opt/lampp backup ****

The command is followed by the password of the root user of MySQL. After the command is executed, the following content is displayed:

Backing up databases...
Backing up configuration, log and htdocs files...
Calculating checksums...
Building final backup file...
Backup finished.
Take care of/opt/lampp/backup/xampp-backup-10-03-07.sh

2. Restore

To recover a previous backup, you only need to run the following command as the root user:

# Sh/opt/lampp/backup/xampp-backup-10-03-07.sh ****

The command is followed by the password of the root user of MySQL. The following information is displayed:

After recovery, you must restart XAMPP to make the recovered data available.