No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

eSight V300R009C00 Single-Node System Software Installation Guide (SUSE Linux) 09

Rate and give feedback :
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
How Do I Solve the Problem of MySQL Database Login Failure?

How Do I Solve the Problem of MySQL Database Login Failure?

Symptom

Logging in to the MySQL database fails, and information similar to the following is displayed:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Possible Causes

The possible causes of the login failure vary based on the error codes:
  • ERROR 1044: The current user does not have the permission to access the MySQL database.
  • ERROR 1045: The user name or password is incorrect.
  • ERROR 2002: The MySQL connection file has been deleted.

Procedure

  1. log in to the Infrastructure Management server as user ossuser in SSH mode.
  2. Run the following command to switch to user dbuser:

    su - dbuser

    Password: Password of user dbuser

  3. Run the following command to stop MySQL processes.

    # killall -9 mysqld_safe mysqld

  4. Run the following command to start the MySQL database service:

    # cd /opt/data/mysql/

    # ./mysql start

    Starting MySQL.. SUCCESS! 

    If the similar information is displayed, the MySQL database service have started successfully. Otherwise, contact Huawei technical support engineers.

  5. Run the following command to log in to the database:

    cd /opt/data/mysql/bin

    ./mysql -usysuser -p

    Enter password: Password of MySQL user sysuser

    If the following message is displayed, you have logged in to the MySQL database successfully, If error messages are displayed, contact Huawei technical support.

    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.6.23-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial)
    
    Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql>>
    

Download
Updated: 2019-05-17

Document ID: EDOC1100011860

Views: 92397

Downloads: 138

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next