有许多类似的问题,但没有一个问题对我有帮助。
我在Windows上使用MySQL的根/根凭据已经有一段时间了,但是最近我无法登录
> mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)
> mysql -uroot
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
> m
*重要:I知道有很多关于如何解决这个问题的文章和主题,但是这些文章和主题都不适合我,因为登录DB很好。
ssh service mysql status返回运行,但是:
Oct 10 12:48:04 vim735ac.flexlyserver.net mysqld[2846372]: 2022-10-10 12:48:04 1334 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
Oct 10 12:48:07 vim735ac.flexlyserver.net
一些程序试图不断地访问我的MySql数据库。
我可以在常规日志中看到:
130424 0:43:59 112 Connect Access denied for user 'lucas'@'localhost' (using password: NO)
112 Connect lucas@localhost as on
130424 0:44:01 113 Connect Access denied for user 'lucas'@'localhost' (using passwo
我想知道为什么你要“抑制”PHP错误。我显然看到了错误产生的额外警告行的不同之处,但是抑制它好吗?
Access denied for user 'user'@'localhost' (using password: YES)
vs
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'user'@'localhost' (using password: YES) in (deleted) on line 8
Acces
安装在Ubuntu 16.04 LTE Xampp (lampp)上都很好,它可以工作:
# ~ $ Sudo / opt / lampp / lampp status
Version: XAMPP for Linux 5.6.20-0
Apache is running.
MySQL is running.
ProFTPD is running.
但是当我想进入有mysql的终端时:
#:~$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p
我无法在我的机器上运行MySQL。如果我没记错的话,我没有为MySQL设置密码。
我执行了以下一系列操作,包括1)以用户身份运行,2)以SuperUser身份运行,3)不使用密码运行,4)以用户密码运行。
如你所见,我让他们所有人都失败了。为甚麽呢?
abc@ubuntu:~$ mysql
ERROR 1045 (28000): Access denied for user 'abc'@'localhost' (using password: NO)
abc@ubuntu:~$ sudo su
[sudo] password for abc:
root@ubu
我无法通过命令行连接到mysql:
$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
$ mysql
ERROR 1045 (28000): Access denied for user 'alex'@'localhost' (using password: NO)
我怎么才能修复它呢?
我在MySQL中使用密码创建了一个新用户。
mysql> GRANT ALL PRIVILEGES ON simple_cms_development.*
-> TO 'simple_cms'@'localhost'
-> IDENTIFIED BY 'xxxxxxx';
Query OK, 0 rows affected (0.04 sec)
我检查它是不是创建的:
mysql> SHOW GRANTS FOR 'simple_cms'@'localhost';
+----
Warning: mysql_connect(): Access denied for user 'msuparam_17'@'localhost' (using password: YES) in /home/msuparam/public_html/17database/Formfeed/Formreg.php on line 11
Could not connect: Access denied for user 'msuparam_17'@'localhost' (using password: YES)
我正在尝试设置卡迈利奥与MySQL插件。我按如下方式设置配置:
## your SIP domain
SIP_DOMAIN=example.org
DBENGINE=MYSQL
## database host
DBHOST=localhost
## database host
DBPORT=3306
当我运行kamdbctl create时,我得到以下结果:
INFO: test server charset
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 10
我第一次在Ubuntu上使用MySQL。我之前创建了数据库vq,它实际上是空的(我不介意删除所有内容;我仍然有创建它的SQL文件)。
现在,我再次尝试访问数据库:
james@ubuntu~$ mysql vq
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'vq'
james@ubuntu~$ mysql -u root -p vq
Enter password:
ERROR 1045 (28000): Access denied for user
我刚刚第一次使用CentOS在yum机器上安装了Mysql。安装没有错误。然后我遵循了这些步骤:
$ sudo /sbin/service mysqld start --skip-grant-tables --skip-networking
$ sudo /usr/bin/mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
您好,我尝试使用错误的密码连接到mysql。我终于到了那里,但现在当我试图访问我的主页www.hari.se时,我只是得到了关注;
Warning: mysql_connect(): Access denied for user 'hari.se'@'csea04.cliche.se' (using password: YES) in /home/virtual/hari.se/public_html/PHP/db.php on line 2
Warning: mysql_select_db(): Access denied for user 'ro
我成功地在OpenWRT上安装了OpenWRT,没有任何错误--参见下面,但是我在登录时遇到了问题--它告诉我访问被拒绝了。但是根据我在互联网上发现的一切,默认的用户名是root,没有密码,所以我必须是一个特例。
请看下面:
root@OpenWrt:~# mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql
我试着访问MySQL,但是我不能,我在mysql配置中写了跳过授权表,然后重启它,但是它仍然不能工作。
$ mysql -u root -p
ENTER PASSWORD: *****
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
我也尝试连接phpmyadmin,但我不能
Cannot log in to the MySQL server
和
mysqli_real_connect(): (HY000/1045): Access den
我已经试了很多想摆脱这一切。但我该怎么解决呢?
sudo mysql_secure_installation
输出:
Securing the MySQL server deployment.
Enter password for user root:
Error: Access denied for user 'root'@'localhost' (using password: YES)
sudo mysql -u root -p
同样的结果。不能重置密码。
当试图进入mysql时,给出以下错误:
sudo mysql
ERROR 1045 (28000
我对这种联系有问题。我也为这个用户做了“授予所有”
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'kristian'@'localhost' (using password: YES) in connection.php on line 8
Failed to connect to MySQL: Access denied for user 'kristian'@'localhost' (using password: YES)
我已经编写了下面的perl脚本来连接mysql工作台数据库,但是它给出了错误access denied for user 'root'@'localhost' (using password yes)。
运行代码后出错:
C:\Users\1053130\Desktop>perl mysql.pl
DBI connect('database=dvd_collection','root',...) failed: Access denied for user 'root'@'localhost'
我意外地在MySQL数据库中做了一些事情,并破坏了MySQL。
:~# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
尝试了
我试过这个:
SET GLOBAL EVENT_SCHEDULER = ON
MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation
这是我第二次尝试:
GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password'
MySQL said: Documentation
#1045 - Access denied for user '*********&
我只能通过命令访问成功:
mysql -u root -p
另一个命令如下:
mysql
或
mysql -u root
具有相同的错误,如:
Access denied for user 'root'@'localhost' (using password: NO)
我尝试设置root用户新密码:
use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
quit;
但只有命令mys
我随机收到服务器错误,因为Laravel正在尝试连接到生产数据库,尽管我设置了一个.env文件,并且大部分时间它都连接到正确的数据库。
下面是我收到的错误:
[2018-02-17 08:05:54] production.ERROR: SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) (SQL: select * from information_schema.tables where table_schema = forge and t
(对不起,我的英语不好)
这是我的控制台日志:
anton@anton-X451CA:~$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
anton@anton-X451CA:~$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
我加了这一行
#mysql password
alias mysql='mysql -umilenko -p*myrealpass*** -hlocalhost'
不管怎样,它不起作用
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'milenko'@'localhost' (using password: YES)
也是
mysql -u roo
"Warning: mysqli::__construct() [mysqli.construct]:
(HY000/1045):Access denied for user 'root'@'localhost' (using
password: YES) in /users/hassib/www/markme/index.php on line 248
Access denied for user 'root'@'localhost' (using password: YES)
我放代码的服务器是hassib.bp
我在我的Ubuntu12.04盒中安装了lamp服务器,当我试图访问MySQL时,我得到了这个bug ERROR 1045(28000),我尝试了许多在互联网上可用的解决方案,但什么都没有。这些都是我尝试访问的bash脚本:
root@sampath-codyowl:~# mysql -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
root@sampath-codyowl:~# mysql -u root
我刚刚通过MySQL包安装程序安装了MySQL。安装后,此消息:
2015-11-19T21:16:59.224430Z 1 [Note] A temporary password is generated for root@localhost: qXkd%pqb)6z3
If you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual.
然后,我尝试使用Sequel登录到127.0.0.1 / root / #<;Ay。
在Centos 7+ DirectAdmin中,当我想作为管理员从所有用户进行备份时,我遇到了一个问题。
错误信息:
Error while backing up database admin_USER1
Error while backing up database admin_USER1: The sql file is 0 bytes in size: /home/admin/admin_backups/admin/backup/admin_USER1.sql
mysqldump error output: mysqldump: Got error: 1045: "Access