Use MySQL encryption functions to protect data

This article describes how to use the MySQL encryption function to protect sensitive website data, in practice, all of us sometimes need to protect sensitive website data. Today we are going to talk about how to protect it through the MySQL encryption function.

In general, you can use MySQL (the best combination with PHP) through command lines ). Many users have been using graphical user interface GUI in Windows to operate and manage databases, and may not be used to the command line method, many new users think that MySQL (the best combination with PHP) is not easy to master.

To facilitate the management of MySQL (the best combination of PHP and MySQL) databases, some graphical user management projects are already in progress, they are MySQL (the best combination with PHP) Control CenterMySQL (the best combination with PHP) CC), MySQL (the best combination with PHP) GUI and phpMyAdmin. In addition, you can use the OpenOffice provided by Red Hat to perform graphical Management of MySQL (the best combination with PHP.

Install MySQL (the best combination with PHP)

Before installing, setting, and applying graphical management tools, you must first install the MySQL (best combination with PHP) server. Run the following command to check whether MySQL is installed on the local machine (the best combination of MySQL and PHP ):

# Rpm-qa | grep MySQL (the best combination with PHP)

MySQL (best combination with PHP)-server-3.23.54a-11

MySQL (best combination with PHP)-3.23.54a-11

All examples in this article are implemented in Red Hat 9.0. In Red Hat 9.0, you can install MySQL directly through the "software package management" program (the best combination with PHP ). The specific method is to first select "SQL database server" on the "add or delete software package" interface, and select "MySQL (the best combination with PHP)" in the details) -server-MySQL encryption function (the best combination with PHP) server and Related Files ", insert the second disc, and select update.

You can also install it by running the rpm command directly from the CD. Because MySQL (the best combination with PHP) servers require support from the Perl language to run normally, install MySQL (the best combination with PHP) when using the next installation method) install the Perl language and related software packages.

After the installation is complete, run the following command to start the MySQL (best combination with PHP) server:

# Service MySQL (the best combination with PHP) d start

After the installation of MySQL (the best combination with PHP), a Super User root is predefined and the password is blank. Any user can use this user locally from the MySQL (best combination with PHP) server to connect to the MySQL (best combination with PHP) Database for operations. Obviously this is very insecure, so after MySQL encryption function (the best combination with PHP) is started, you should set the root password immediately. The setting method is as follows:

# MySQL (the best combination with PHP) admin password 'ylgu'

In this way, a new password: ylgui is set.

Is the MySQL (best combination with PHP) server running normally? You can view it by enabling the client program MySQL (the best combination with PHP. Use the above password:

# MySQL (best combination with PHP)-u root-pylgui

Welcome to the MySQL (the best combination with PHP) monitor. Commands end with; or \ g.

Your MySQL (best combination with PHP) connection id is 6 to server version: 3.23.54

Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.

Note that there is no space between parameter p and password. The screen displays the databases currently available:

MySQL (the best combination with PHP)> show databases; + ---------- + | Database | + ---------- + | MySQL (the best combination with PHP) | test | + ---------- + 2 rows in set (0.01 sec)

We can see that there are two databases in the MySQL (the best combination with PHP) database server, namely the MySQL encryption function (the best combination with PHP) and test. This indicates that the database server has been correctly installed and started properly.