MySQL Startup error

Source: Internet
Author: User

The error prompts are as follows:

150815 20:24:40 mysqld_safe mysqld from PID File/var/run/mysqld/mysqld.pid ended
150815 20:26:07 Mysqld_safe starting mysqld daemon with databases From/var/lib/mysql
/usr/libexec/mysqld:table ' mysql.plugin ' doesn ' t exist
150815 20:26:07 [ERROR] Can ' t open the Mysql.plugin table. Please run Mysql_upgrade to create it.

Workaround:

mysql_install_db--user=mysql #进行数据库的初始化

The following is the use of this command:

1 mysql_install_db Description2 when the MySQL system library (MySQL system library) fails or needs a new MySQL instance, the MySQL database needs to be initialized. 3Commands to use:/usr/local/mysql/bin/mysql_install_db4#/usr/local/mysql/bin/mysql_install_db--help can be viewed in the following information5Usage:/usr/local/mysql/bin/mysql_install_db [OPTIONS]6--basedir=path The path to the MySQL installation directory.7--cross-bootstrap forInternalUse . Used when building the MySQL system8 tables on a different host than the target.9--datadir=path The path to the MySQL data directory.Ten--force causes mysql_install_db to run evenifDNS does not OneWork. In that Case, grant table entries that normally A Use hostnames would use IP addresses. ---ldata=path The path to the MySQL data directory. ---RPM forInternalUse. This option isused by RPM files the during the MySQL installation process. ---skip-name-resolve use IP addresses rather than hostnames when creating -Grant table entries. This option can be usefulif - your DNS does not work. +--srcdir=path forInternalUse . The directory under which -MYSQL_INSTALL_DB looks forSupport Files such as the +Error message file and the file forpopoulating the A Help tables. at--user=user_name the login username to use forrunning mysqld. Files -and directories created by Mysqld'll be owned by This -User. You must is root to use ThisOption. Bydefault -Mysqld runsusingyour current login name and files and -Directories that it creates would be owned by you.

MySQL Startup error

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.