Linux (centOS6) install MySQL 5.6.19 database steps, issues, and corresponding workarounds

Database version: Ver 14.14 distrib 5.6.19, for Linux (x86_64) using Editline Wrapper

Linux versions: Linux version 2.6.32-279.el6.x86_64 ([email protected]s.org) (gcc ve rsion 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Fri June 12:19:21 UTC 20 12

The RPM installation method used.

1, the official website download tar compress package, for Http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-5.6.19-1.linux_glibc2.5.x86_64.rpm-bundle.tar;

2, unzip the downloaded tar package, will get the following 7 files,

mysql-client-5.6.19-1.linux_glibc2.5.x86_64.rpm
mysql-devel-5.6.19-1.linux_glibc2.5.x86_64.rpm
mysql-embedded-5.6.19-1.linux_glibc2.5.x86_64.rpm
mysql-server-5.6.19-1.linux_glibc2.5.x86_64.rpm
mysql-shared-5.6.19-1.linux_glibc2.5.x86_64.rpm
mysql-shared-compat-5.6.19-1.linux_glibc2.5.x86_64.rpm
mysql-test-5.6.19-1.linux_glibc2.5.x86_64.rpm

Just install it all. The command is as follows:

RPM-IVH mysql-server-5.6.19-1.linux_glibc2.5.x86_64.rpm mysql-client-5.6.19-1.linux_glibc2.5.x86_64.rpm mysql-devel-5.6.19-1.linux_glibc2.5.x86_64.rpm mysql-embedded-5.6.19-1.linux_glibc2.5.x86_64.rpm mysql-shared-compat-5.6.19-1.linux_glibc2.5.x86_64.rpm mysql-shared-5.6.19-1.linux_glibc2.5.x86_64.rpm

3, installation completed with the service MySQL Status View is successful operation. Don't know why now 5.6. Version 19 why not mysqld? Remember the service mysqld status you used to see the status of MySQL in the past.

4, log in the database to modify the configuration file, such as [email protected]% table modification. Use mysqladmin-root password "Youpassword" unexpectedly invalid cannot go in to set up, here provides two kinds of solution:

A, through the installation of log files can be seen during the installation of MySQL randomly generated a string of passwords: You can find the. mysql_secret file in the root directory, open the following:

# The random password set for the root user at Wed June 17:17:26 (local time): Aiiyqbqkif0v43et get a random password, you can log in, this is the fastest 。

B, through mysqladmin--skip-grand-tables & mysql-uroot-p Enter the password set Password=password ("Youpassword");

5, found a problem, the first time to log on is not able to operate the database he will prompt to change the password. This should be due to the latest MySQL to generate a random password reason it.

6, RPM mode after installation etc is not a new configuration file generated in the USR directory (this is the new version of the change or RPM installation method of the difference?). ）

7. Setting database table name is case sensitive. The newly installed MySQL database will default to uppercase the table name of the program action? Encountered several times, directly modify the My.cnf file: At the end of the add: Lower-case-table-names = 1 (de-capitalization sensitive). And then restart the database service, OK. Command: Service MySQL restart

8, do not know what problems we have encountered?