Rehat problems encountered during installation using MySQL

1. ERROR 1040 (HY000): Too Many connections

Analysis : the direct reason for generating too many connections is that the database provides all the connections that are fully occupied. How many connections the database can provide can be set under MY.CNF (Linux) or My.ini (Windows).

Currently server Max_connections 400, not recommended to add too much, because the machine above the remaining memory, increase will consume more memory. Too many causes the system to crash. Wait_timeout defaults to 8 hours,

Show Processlist found a lot of sleep, indicating that the parameter setting is too large. (Set to disconnect if the connection is not requested within 10 minutes)

Workaround: Modify the configuration file additions and require a restart:

[Mysqld]

Wait_timeout = 600

Interactive_timeout = 600

2. Missing libstdc++.so.6

Cause: The system is 64bit, and the library is 32bit.

1) Yum provides libstdc++.so.6

2) Yum Install libstdc++-4.4.11.e16.i686

3) Yum Update xxx.x86_64 (fill in XXX based on the information in the previous step)

4) Repeat 2)

3. Yum occurs when installing this system was not registered with the portal

Solve:

1) cd/etc/yum.repos.d/...

2) command line: wget Http://docs.linuxtone.org/soft/lemp/centos-Base.repo

3) MV Rhel-debuginfo.repo Rhel-debuginfo.repo.bak

4) MV Centos-base.repo Rhel-debuginfo.repo

Then yum install ... Can

4. ERROR 1130:host 192.168.x.x is not allowed to connect to this MySQL server.

FIX: Increase user, set permissions

1) insert into user (User,host) values (' root ', ' 192.168.x.x ');

2) Grant all privileges on * * to ' root ' @ ' 192.168.x.x ' identified by ' password ' with GRANT option;

3) flush privileges;

5. ERROR 1044 (4200): Access denied for user "@ ' localhost ' to database ' MySQL '

Cause: The user table in the MySQL database has an account with a blank username, that is, an anonymous account, which causes the login to be rooted, but

The actual is anonymous login, through the error message "@localhost can be seen.

FIX: 1) turn off MySQL service mysqld stop

2) Shielding rights Mysqld_safe--skip-grant-table &

3) mysql-u Root

Delete from user where user= ';

or update user set Password=password (' XXX ') where user= ' root '

4) flush privileges;

Rehat problems encountered during installation using MySQL