The following article describes how to install MySQL (the best combination with PHP). We all know that before installing, setting, and applying related graphical management tools, first, we need to install the MySQL (the 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 (the best combination with PHP) server and related files ", insert the second disc, and select update.
You can also install MySQL 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 MySQL is installed, 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 (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 (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 MySQL (the best combination with PHP) and test. This indicates that the database server has correctly installed MySQL and started properly.