Experience in installing MySQL 4.0.21

Do you have a lot of trouble in the actual installation process of MySQL 4.0.21? I have also checked a lot of related articles on CU, but the results are not satisfactory. In order to reduce the cost, it is necessary to introduce the experience here, this will reduce the number of people in the future.

I wrote this article not only for beginners like me to complete MySQL (the best combination with PHP)-4.0.21 installation, in addition, I am able to cope with the installation of MySQL (the best combination with PHP) in the future based on the experience in this article.

Isn't it a bit arrogant? I don't think so, because I think the steps are not the most important, and the later experiences are the most important. In addition, the installation environment is supported by Linux AS 3 and gcc.

1. First, let's talk about the installation steps.

# Groupadd MySQL (the best combination with PHP)

# Useradd-g MySQL (the best combination with PHP)

# The combination of tar zxvf mysql(and PHP )-4.0.21.tar.gz/* generates a MySQL (best combination with PHP)-4.0.21 directory */

# Cd MySQL (best combination with PHP)-4.0.21

#./Configure -- prefix =/usr/local/MySQL (the best combination with PHP)

# Make

# Make install

# Cp support-files/my-medium.cnf/etc/my. cnf/* then I will ask if to overwrite the duplicate file, answer y */

# Cd/usr/local/MySQL (best combination with PHP)

# Bin/MySQL (the best combination with PHP) _ install_db -- user = MySQL (the best combination with PHP)/* use MySQL (the best combination with PHP) it is important that you create a system library with MySQL (the best combination of PHP and MySQL! */

# Chown-R root.

# Chown-R MySQL (the best combination with PHP) var

# Chgrp-R MySQL (the best combination with PHP ).

# Bin/MySQL (the best combination with PHP) d_safe -- user = MySQL (the best combination with PHP) &/* use MySQL (the best combination with PHP) if the user does not respond, congratulations! Successful! */

Ii. MySQL 4.0.21 installation experience

1. Although the excellent article of CU is good, the installation of MySQL (the best combination with PHP) is slightly different! The most reliable part is the INSTALL-SOURCE file in the decompressed MySQL (the best combination with PHP)-VERSION directory, the above installation steps are fixed according to the document, and the installation is successful. At the beginning, the system library cannot be successfully created because of the lazy reading of the Chinese characters of the CU, because those articles were installed in earlier versions of MySQL (the best combination with PHP.

2. Details

(1) This article is source code installation to reduce unnecessary troubles. For binary installation, you must first select the correct Binary Package for installation. For details, refer to the INSTALL-SOURCE file. This is also important. The steps are similar to those above, except for the three steps: configure, make, and make install.

(2) make takes about 15 minutes. Please wait. Wait: em24: em24:

(3) make install is much faster, so there will be no stopwatch in less than one minute. Please forgive me if the estimation is not weekly)

(4) You must use MySQL (the best combination with PHP) to create a system database! As I have already stressed above, I just didn't add "-- user = MySQL (the best combination with PHP)" at the beginning. The system database will return the following information:

# Bin/MySQL (the best combination with PHP) _ install_db -- user = MySQL (the best combination with PHP)

 
 

  
  
Preparing db table  
  
  
Preparing host table  
  
  
Preparing user table  
  
  
Preparing func table  
  
  
Preparing tables_priv table  
  
  
Preparing columns_priv table  
  
  
Installing all prepared tables 
 
 

040913 20:11:39/usr/local/MySQL (the best combination with PHP)/libexec/MySQL (the best combination with PHP) d: Shutdown Complete

(5) MySQL (the best combination of PHP and MySQL) is also used for running, and the command is the best combination of MySQL (and PHP) d_safe instead of the previous safe_MySQL (the best combination with PHP) d. This is also described in INSTALL-SOURCE. At this time, I am most afraid of "... "Ended" indicates that MySQL cannot be started normally (the best combination with PHP ). No response is best. Press enter to return # prompt.

(6) If it is normal, you can use:

# Vi/etc/rc. d/rc. local

Run the command to edit the startup script, and add "/usr/local/MySQL (the best combination with PHP)/bin/MySQL (the best combination with PHP) at the end) d_safe -- user = MySQL (the best combination with PHP) & "is installed.

(7) If you are not at ease, use "# netstat-nat" to check if port 3306 exists;

You can also use "# ps-ef | grep MySQL (the best combination with PHP) d" to return three rows with "MySQL (the best combination with PHP) the result of "d" can also be used for judgment.

(8) do not forget to change the password of MySQL (the best combination with PHP ).

Thank you for choosing em04 :)

The above content is an introduction to the installation experience of MySQL 4.0.21. I hope you will have some gains.