Linux under MySQL ERROR 1045:access denied for user: '[email protected]' (Using password:no)
This problem occurs every time MySQL is enabled and then I type the command # Mysql-penter password:welcome to the MySQL monitor. Commands Endwith; or \g.your MySQL connection ID is the Version:4.0.20-standard to Server Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the buffer.
Mysql> to use, but want to give MySQL backup is not possible,
type #mysqldump database>databak.sql to appear rror 1045:access denied for user: '[email protected]' (using Password:no) How can I then type MySQL to use, and can
MySQL for backup
Workaround: Log in to MySQL and execute the following statement: Set password for ' root ' @ ' localhost ' =password ("); flush privileges; and then re-login, up
to your request.
This article from "Blue Home" blog, declined reprint!
MySQL ERROR 1045,mysql cannot perform batch processing under Linux