Jump to content
  • InstallDatabases.sh - dont accept password with special symbols


    amaroc
    • Main Category: Unset
      Sub-Category: Unset
      Version: 21.11

    Hello guys, sorry i dont find a better place to post it. So i spend 5 hours to find this problem, and maybe it will be helpfull for another users.

     

    So my system is FreeBSD10.3, mysql56. I tried run InstallDatabases.sh and import all DB but get error like this on every strings output:

    Importing file World/Setup/FullDB/locales_page_text.sql
    ERROR 1045 (28000): Access denied for user 'mangos'@'localhost' (using password: YES)
     

     

    I ve tried use root, i tried delete root and other anonymous users, add /etc/hosts etc.. so my head is broken now ;) And i look in file and see that script use 

    mysql_config_editor

    printf "What is your MySQL password ?\t [], "
    mysql_config_editor set --login-path=local --host=${svr} --port=${port} --user=${user} --password --skip-warn
    if [ "${DUMP}" = "YES" ]; then
            printf "Enter it again \t[]: "
            read pass
    fi
     

    then i tried google same problem with this tool, and found that http://stackoverflow.com/questions/19372095/mysql-config-editor-login-path-local-not-working

     

    Use double quotes around the password when mysql_config_editor prompts you. Then special characters (e.g. #) will be recognized as part of the password upon login.

    So i think problem in .SH script, there 2 wayes or add quotes, or give user remind, that if he get ERROR 1045 (28000) maybe his password have # $*%^&!@# special symbols like that. So he cannot auth. After i change password, all works fine, and all data has imported.

     

    Sorry for bad english guys.


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use