我编译好mysql之后用mysqladmin 设置密码出现了如下的问题不知道什么原因: -bash-2.05b# ./mysqladmin -u mysql -p password Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'access denied for user: 'mysql@localhost' (Using password: YES)' -bash-2.05b# ./mysqladmin -u root -p password Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'access denied...
by 弹头 - MySQL - 2003-08-07 17:52:09 阅读(3752) 回复(6)
[root@it src]# mysql -u root -p < mail.sql Enter password: ERROR 1045: access denied for user: 'root@localhost' (Using password: YES) 这又是为什么呢? 我该怎么办啊?请高手提点一下。谢谢!
本帖最后由 cenalulu 于 2012-08-20 09:47 编辑 安装应用程序,连接MySQL时,提示access denied for user root@localhost (using password: YES)。 试了很多方法都没解决,后来的解决方法很奇怪,谁能解释下。 首先,应用程序和数据库同一台机器;数据库密码没问题;局域网其他机器上的数据库客户端访问数据库没问题;主机HOST设置没问题。 应用程序配置用127.0.0.1连接本机数据库,一直提示上面的错误。之后把地址设为本机I...
First, you will need to make sure whether the default user is 'admin' or 'root' or whatever. You will then need to reset the password.
Start the mysql server instance or daemon with the --skip-grant-tables option. (security setting) You can do it by adding th...
今天Red Hat Enterprise Linux 6.0上跑得mysql神不知鬼不觉地执行mysql -u root -p登录时,报出了错误:access denied for user 'root'@'localhost' (using password: YES),但服务器每有做任何的改动,昨天还跑得好好的,也不晓得什么原因。在网上查找了下原因,找到一篇文章提供了如下的解决方法:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
windows环境 我执行了 # mysql> grant all on rollerdb.* to scott@'%' identified by 'tiger'; # mysql> grant all on rollerdb.* to scott@localhost identified by 'tiger'; 后 mysql就无法访问了 用root scott 都无法访问 错误提示是 access denied for user 'root'@'localhost' (using password: yes) access denied for user 'scott'@'localhost' (using password: yes) 而且我想删除mysql 也删不掉 原来是安装版的 我...
我的系统是linux,最近新装好的mysql在进入mysql工具时,总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码: # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using pass...
我的系统是fedora8,用rpm包安装的mysql,在进入mysql时,总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码: # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (us...
windowsxp系统 mysql-5.0.11-beta-win32 提示:1045 access denied for user [email='root'@'localhost']'root'@'localhost'[/email] using password yes 前几天都好好的,昨天没弄,结果今天晚上过来提示上面的这个错误,重启mysql还是不可以 网上的方法看了几个但是不知道怎么弄 方法一: # /etc/init.d/mysql stop # mysqld_safe --user=mysql --skip-grant-tables --skip-networking & # mysql -u root mysql mysql>...
我的系统是ubuntu6.06,最近新装好的mysql在进入mysql工具时,总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码: # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using...