Full Process of MySQL installation using fedora14

1. Download MySQL

In addition to the yum install MySQL mysql-Server Installation Method, I want to use the RPM package for installation this time. Go to http://www.mysql.com/downloads/and find that the website of mysqlhas a Community edition and a commercial edition. The latter part is the billing method. Generally, community is used. After entering, you will see the title "MySQL Community Server 5.6.10". Take a closer look at the version that requires glibcGlibc 2.5. Click the previous version in the upper-right corner and select the oldest version 5.0.96 and Linux-Generic. The version glibc requires is 2.3.

You can use LS-Al/lib/libc. so.6 or/lib/libc. so.6 to view the glibc version of the system. We can see the version is 2.13. Download the latest one:

Client Version:

Linux-generic (glibc 2.5) (x86, 32-bit), RPM package Client utilities		5.6.10	21.8 m	Download
MySQL-client-5.6.10-1.linux_glibc2.5.i386.rpm)	MD5:9a7b25d52cd1ebfa12812bd2e5fb0c58

Server version:

Linux-generic (glibc 2.5) (x86, 32-bit), RPM package MySQL Server		5.6.10	83.8 m	Download
MySQL-server-5.6.10-1.linux_glibc2.5.i386.rpm)	MD5:de984e59aa502e38e55cea77cbf898d0

Note that the devel version in the link is the installation package that needs to be downloaded when calling the database processing interface in C language or C ++.

Copy the file to/mnt/Yan/download and call rpm-IVH "XXXXXXX. RPM" for installation.

After the installation is complete, enter service MySQL start in the root directory and log on. What is the odd difference between the initial password and the initial password ?? Some people say it is null, that is, nothing is written. No matter MySQL or mysqladmin is used for logon, an error still occurs:

Mysqladmin: connect to server at 'localhost' failed
Error: 'Access denied for user' root' @ 'localhost' (using password: No )'

Some people also say that the modification/Etc/My. CNF file, but with RPM installation is not this file, refer to: http://blog.csdn.net/e3399/article/details/7569646

The solution is as follows:

1. Stop MySQL service first: Service mysqld stop

 

2. Enter the following command:

[Root @ Yan ~] # Mysqld_safe -- skip-grant-tables & mysql-uroot-P
[Note: this is a complete command and cannot be split from & into two !]

The result is:

[1] 3970
Enter Password: 130319 22:46:50 mysqld_safe logging to '/var/lib/MySQL/Yan. Guoqi. err '.
130319 22:46:50 mysqld_safe starting mysqld daemon with databases from/var/lib/MySQL

Welcome to the MySQL monitor. commands end with; or \ G.
Your MySQL connection ID is 1
Server version: 5.6.10 MySQL Community Server (GPL)

Copyright (c) 2000,201 3, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
Affiliates. Other names may be trademarks of their respective
Owners.

Type 'help; 'or' \ H' for help. type' \ C' to clear the current input statement.

3. Enter the following command:

Mysql> use MySQL;

4. mysql> Update user SET Password = PASSWORD ("yanguoqi") where user = "root ";
[Note: "" contains the password you want to set !!!!]

5. Enter:

Mysql> flush privileges;

6. log out and restart the database. Input:

Mysql> quit;
Bye
[Root @ Yan ~] # Service MySQL restart;

Finally, Verification:

Enter the following command:

[Root @ Yan ~] # Mysql-uroot-P

[Note that this-P must be added; otherwise, the logon fails .]
You will be prompted to enter the password to operate the database!

After everything is ready, you can use:

[Root @ Yan ~] # Netstat-Nat | grep 3306
TCP 0 0: 3306: * listen

To view port usage. The default port is port 3306. There are two methods for Linux to connect to MySQL: socket and TCP/IP.

Reference: http://blog.sina.com.cn/s/blog_8442befd01015zld.html