How to sort out common MySQL problems on CU

The following article describes how to sort out some common MySQL questions and answers on the CU. If you are interested in the actual operations, you can click here to view the following articles. In general, you can use MySQL (the best combination with PHP) through command lines ). Many users

The following article describes how to sort out some common MySQL questions and answers on the CU. If you are interested in the actual operations, you can click here to view the following articles. In general, you can use MySQL (the best combination with PHP) through command lines ). Many users

The following article describes how to sort out some common MySQL questions and answers on the CU. If you are interested in the actual operations, you can click here to view the following articles.

In general, you can use MySQL (the best combination with PHP) through command lines ). Many users have been using graphical user interfaces (guis) to operate and manage databases in Windows, 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 Center (MySQL (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 (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.

Sort out MySQL frequently asked questions and answers on the CU: After the installation is complete, run the following command to start the MySQL (the 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 (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 MySQL (the best combination with PHP) and test. This indicates that the database server has been correctly installed and started. The above content describes the MySQL FAQs and solutions on the CU, I hope it will help you in this regard.