When the MySQL database is started, the following error occurs:120419 19:10:32 [ERROR]/usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host. frm' (errno: 13)120419 19:10:32 [ERROR] Fatal error: Can't open and lock privilege tables: Can't
MySQLStudy -- Mysql startup failure "mysql. host "system environment: Operating System: RedHatEL55DBSoft: Mysql5.6.4-m7 after mysql is installed through the source code package, an error occurs when mysqld is started: [root @ rh55mysql] #
After I deleted the original mysql4.0 file in s9, I installed a new mysql5.0 file. During the startup process, I reported an error and failed to start the file. I checked the old post in the group and did not provide a specific description.
After I
MySQL Study -- Mysql startup failure "mysql. host", -- mysqlmysql. hostMySQL Study-Mysql startup failure "mysql. host"
System Environment:
Operating System: RedHat EL55
DB Soft: Mysql 5.6.4-m7
After mysql is installed through the source code
After I delete the S9 public mysql4.0, I re-installed a new mysql5.0. During the startup process, an error is reported, indicating that the startup failed, I checked the old posts in the group and did not provide a specific explanation. I also asked
MySql Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts ' workaroundEnvironment:linux,mysql5.5.21Error: Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts
PHP links MySQL host 127.0.0.1 and localhost
PHP links MySQL host 127.0.0.1 and localhost
Use mysql-u root-p to enter the MySQL operation interface
You can directly use/usr/local/php5/bin/php/web/test. php to connect to the database.
Apache is
Records in the error log:
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql. host' doesn' t exist
I posted a post. I only saw it, but no one replied. I can only solve the problem by myself. Can I help myself... You don't have
MySQL cannot start or restart because the Linux host name and mysql host name have been changed.
MySQL cannot be restarted, shut down, started, or used. If you modify the host name, you can disable all mysql processes and start some mysql processes!
But for the first time I touched mysql, I did not understand it.Now, let's talk about the process of solving the problem:Follow the mysql installation steps:Shell> groupadd mysqlShell> useradd-g mysqlShell> gunzip | mysql-VERSION.tar.gz |
Definitions and usageThe Mysql_get_host_info () function gets a host about MySQL.This function returns the type of MySQL connection that is currently in use, or false fails.Grammar
Mysql_get_host_info ($connection)
Parameter
Environment:linux,mysql5.5.21Error: Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts 'Reason:Congestion caused by the same IP in a short period of time resulting in too many (exceeding the maximum value of
Environment: linux,mysql5.5.31 Error: Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts 'Reason:Congestion caused by the same IP in a short period of time resulting in too many (exceeding the maximum value of
Summary of differences between MySQL host 127.0.0.1 and localhost, mysqllocalhost
1. mysql-h 127.0.0.1 is connected using TCP/IP. mysql server considers the connection from 127.0.0.1 or "localhost. localdomain"
2. When mysql-h localhost is used,
Environment:linux,mysql5.5.21 Error: Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts ' Reason: Congestion caused by the same IP in a short period of time resulting in too many (exceeding the maximum value of
Environment:linux,mysql5.5.21Error: Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts 'Reason:Congestion caused by the same IP in a short period of time resulting in too many (exceeding the maximum value of
Error:MySql Host is blocked because of many connection errors, unblock with ' mysqladmin flush-hosts ' Workaround: Use MYSQLADMI N flush-hosts command to clean up the Hosts file (do not know in which directory mysqladmin can use the command to find:
Transferred from: http://www.cnblogs.com/susuyu/archive/2013/05/28/3104249.htmlEnvironment:linux,mysql5.5.21Error: Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts 'Reason:Congestion caused by the same IP in a
Environment:linux,mysql5.5.21Error: Host is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts 'Reason:Congestion caused by the same IP in a short period of time resulting in too many (exceeding the maximum value of
How to resolve:Shutting down the firewallService Iptables Stop1. Change the table method.It may be that your account is not allowed to log on remotely, only on localhost. Log on to the installed computer, log in to MySQL, change the "MySQL" Database
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.