MySQL installed on the CentOS6.3

Source: Internet
Author: User

Method 1: Install using the RPM packageDownload mysql-shared-5.6.20-1.el6.x86_64 (installed in order to resolve file conflicts, but the file conflict issue is still not resolved during my installation) mysql-shared-compat-5.6.20-1.el6.x86_64 ( For compatibility installation) Mysql-server-5.6.20-1.el6.x86_64mysql-client-5.6.20-1.el6.x86_64 installation sequence, such as loading order, The problems encountered are as follows 1: File conflict issues encountered file conflicts during installation of Msql-server, and finally the installation completed successfully through Yum Remove mysql-libs-5.1.61-4.el6.x86_64 (the system exists conflict file).

Issue 2: Unable to add hidden permissions to files when adding MySQL users and user groups for hidden permissions to view files using the lsattr command, use the chattr command to cancel some hidden permissions. http://hellosa.blog.51cto.com/2698675/554253 Problem 3: Start the service after successful installation, always prompt this error the server quit without updating PID file (/var/lib /MYSQL/*.PID) finally looked at the online a lot of solutions, the end has not been able to solve, and finally did not give up the use of the method Method 2: Direct Yum installationYum install mysql-server mysql mysql-devel start: sudo service mysqld start error: Can ' t find Messagefile '/usr/share/mysql/englis H/errmsg.sys '
Cause: Less mysql-libs-5.1.61-4.el6.x86_64 bag
Install package: sudo yum install mysql-libs-5.1.61-4.el6.x86_64 start again: sudo service mysqld start or start failed: MySQL Daemon failed to start.
Starting mysqld: [FAILED]
View MySQL logs: sudo more/var/log/mysqld.log
Error message: Can ' t open the Mysql.plugin table. Please run Mysql_upgrade to create it. Workaround: sudo mysql_install_db--user=mysql--datadir=/var/lib/mysql
Restarting and encountering a problem: 140903 22:50:59 [ERROR] Can ' t ' start server:bind on TCP/IP port:address already in use
140903 22:50:59 [ERROR] Do you already has another MYSQLD server running on port:3306? So I follow the prompts to see if there is a MySQL process running: PS aux |        grep ' mysql* ' turns out to be true, was I installed before running up: root 16651 0.0 0.0 150112 2092? S 06:30 0:00 sudo/usr/libexec/mysqld--skip-grant
MySQL 16652 0.0 0.3 378688 27392? Sl 06:30 0:19/usr/libexec/mysqld--skip-grant So I killed the two processes: sudo kill 16651 sudo kill 16652 to start the service again, and finally succeeded!

MySQL installed on the CentOS6.3

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.