Mysql password syntax error near unexpected token

use mysql - e instead: #! / bin/ bash mysql. server start mysql - u root - e " SET PASSWORD FOR = PASSWORD( ' admin' ) ; ". share| your code, try enclosing password inside single quote. Alternatively, as per the documentation of mysql, following should work - SET PASSWORD FOR ' jeffrey' @ ' localhost' = PASSWORD( ' cleartext password' ) ; e double quotes as much as you can. conf should be like host= " localhost" user= " user" password= " GhR6R3# h] dSq+ C74) Jz9CDF6a7^ & L[ 4= " db_ name= " database". And than your command: mysqldump - - lock- your code, try enclosing password inside single quote. Alternatively, as per the documentation of mysql, following should work - SET PASSWORD FOR ' jeffrey' @ ' localhost' = PASSWORD( ' cleartext password' ) ; your code, try enclosing password inside single quote. Alternatively, as per the documentation of mysql, following should work - SET PASSWORD FOR ' jeffrey' @ ' localhost' = PASSWORD( ' cleartext password' ) ; FLUSH. bash: syntax error near unexpected token ` ( '. Any ideas what I' m doing wrong?

  • Error code ssl error unsupported version
  • Runtime error 6068
  • Caused by java io ioexception broken pipe jira
  • Error 87 parameter is incorrect windows update
  • Err ssl protocol error centos


  • Video:Unexpected password near

    Password unexpected error

    You have to execute this command in the database ( not from the command line). For example, if you are using MySQL, you have to login to the database first: $ mysql - u root - p. then enter the password. You' ll see a welcome. scp $ BACKUP_ DIR/ $ AKT_ DATUM. sh: line 11: syntax error near unexpected token ` newline'. This error is because you have an unexpected line break. share| ' s best to avoid putting passwords in plain text on your command line anyway. Instead, you can put them in the user' s MySQL config file: $ cat > ~ /. cnf [ client] user = root password = [ ( pwdwithbrackets) ] ^ D $ e double quotes as much as you can. And than your command: mysqldump - - lock- tables.