解决Mysql登陆出现ERROR
解决Mysql登陆出现ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: YES)
Code:
Code:
# mysqladmin -uroot password "youpassword" #设置root帐户的密码 # mysql -uroot -p # 输入你设置的密码 mysql>use mysql; mysql>delete from user where password=""; #删除用于本机匿名连接的空密码帐号 mysql>flush privileges; mysql>quit 然后再以root登录 mysql> SET PASSWORD FOR root=PASSWORD('new_password'); |