CENTOS6 in the installation of MySQL error problem solving method

Source: Internet
Author: User

[Root@cch rpm]# RPM-IVH mysql-server-5.5.29-1.rhel5.x86_64.rpm

error:failed dependencies:
libaio.so.1 () (64bit) is needed by mysql-server-5.5.29-1.rhel5.x86_64
Libaio.so.1 (libaio_0.1) (64bit) is needed by mysql-server-5.5.29-1.rhel5.x86_64
Libaio.so.1 (libaio_0.4) (64bit) is needed by mysql-server-5.5.29-1.rhel5.x86_64

You need to use the Yum command to quickly install the dependency pack Libaio and run the following command:

Yum Install Libaio

Appearance: Configure:error:No Curses/termcap Library found
Workaround:

#./configure--prefix=/usr/local/mysql

For. #./configure--with-named-curses-libs=/usr/lib/libncursesw.so.5

Appear:

.. /depcomp:line 571:exec:g++: Not Found
make[1]: * * * [MY_NEW.O] Error 127
MAKE[1]: Leaving directory '/home/justme/software/mysql-5.1.30/mysys '
Make: * * * * [all-recursive] Error 1

Solve:

Download installation gcc-c++-4.1.2-33.i386.rpm (yum Intall gcc-c++)

Install or re mysql-5.1.30 when mysql_install_db appears fatal error:could not find mysqld error resolution,

Because there was a my.cnf under the/etc/mysql/.

Workaround:

Mv/etc/my.cnf/etc/my.cnf.bak

CP SUPPORT-FILES/MY-MEDIUM.CNF/ETC/CNF

If you receive the following error message:

ERROR 2002 (HY000): Can ' t connect to the local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)

Description MySQL service has not started, enter service MySQL start start MySQL service

Service MySQL Start

Failed to start after MySQL5.5
after I installed MySQL5.5 through RPM, I tried to use the service MySQL start command to start MySQL and get the error message:
The server quit Withoud updating PID file.
Further view the Localhost.localdomain.err file and find the error log as follows:
/usr/sbin/mysqld:table ' mysql.plugin ' doesn ' t exist
And
Can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist

And I entered the database directory, you can see the MySQL directory under the plugin and host data table files.

Can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist

No automatic initialization, first in the MySQL installation directory to execute the mysql_install_db

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.