Stack Overflow
Stack Overflow

Questions tagged [mysql-error-1045]

ERROR 1045 (28000): Access denied for user '%s'@'%s' (using password: %s)

Example:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
182 questions
410
votes
17 answers

brew install mysql on macOS

I'm trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52. Everything goes well and I am also successful with the mysql_install_db. However when I try to connect to the server…
nikola
  • 5,286
  • 3
  • 22
  • 19
247
votes
2 answers

How to remove MySQL root password

I want to remove the password for user root in localhost. How can I do that? By mistake I have set the password of root user. That's why phpmyadmin is giving an error: #1045 - Access denied for user 'root'@'localhost' (using password: NO)
nectar
  • 9,525
  • 36
  • 78
  • 100
204
votes
19 answers

Access denied for user 'root@localhost' (using password:NO)

I'm trying to run WordPress in my Windows desktop and it needs MySQL. I install everything with Web Platform Installer which is provided by Microsoft. I never set a root password for MySQL and in the final step of installing WordPress, it asks for a…
Nasser Hadjloo
  • 12,312
  • 15
  • 69
  • 100
190
votes
14 answers

Access denied for user 'root'@'localhost' while attempting to grant privileges. How do I grant privileges?

I've looked at a number of similar questions and so I'm demonstrating that I've checked the basics. Though of course, that doesn't mean I haven't missed something totally obvious. :-) My question is: why am I denied access on a user with the…
Steven Scotten
  • 2,086
  • 2
  • 13
  • 10
128
votes
12 answers

access denied for load data infile in MySQL

I use MySQL queries all the time in PHP, but when I try LOAD DATA INFILE I get the following error #1045 - Access denied for user 'user'@'localhost' (using password: YES) Does anyone know what this means?
Brian
  • 26,662
  • 52
  • 135
  • 170
126
votes
19 answers

MySQL: Access denied for user 'test'@'localhost' (using password: YES) except root user

I am facing problem with mysql non root/admin user, I am following the below steps for creating user and its privileges, correct me if i am doing wrong, i am installing mysql on RHEL 5.7 64bit, packages are mentioned below, once i done the rpm…
user3061726
  • 1,261
  • 2
  • 9
  • 3
119
votes
10 answers

How can I restore the MySQL root user’s full privileges?

I accidentally removed some of the privileges from my MySQL root user, including the ability to alter tables. Is there some way I can restore this user to its original state (with all privileges)? UPDATE mysql.user SET Grant_priv = 'Y', Super_priv =…
Steven
  • 24,410
  • 42
  • 108
  • 130
94
votes
6 answers

MYSQL into outfile "access denied" - but my user has "ALL" access.. and the folder is CHMOD 777

Any ideas? SELECT * INTO OUTFILE '/home/myacnt/docs/mysqlCSVtest.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '*' LINES TERMINATED BY '\n' FROM tbl_property WHERE managerGroupID = {$managerGroupID} Error: Access denied for user…
Shackrock
  • 4,601
  • 10
  • 48
  • 74
88
votes
14 answers

Cannot log in with created user in mysql

Using this command GRANT ALL PRIVILEGES ON *.* to 'brian'@'%' identified by 'password'; I try to login with: mysql -u brian -ppassword The error is: ERROR 1045 (28000): Access denied for user 'brian'@'localhost' (using password: YES) I am doing…
Brian G
  • 53,704
  • 58
  • 125
  • 140
79
votes
32 answers

mysqldump Error 1045 Access denied despite correct passwords etc

This is a tricky one, I have the following output: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect When attempting to export my database with mysqldump on Windows XP. The username…
DdlyHeadshot
  • 791
  • 1
  • 5
  • 4
52
votes
7 answers

MySQL - ERROR 1045 - Access denied

In some way I have managed to get this error when I try to access into MySQL via the command line: [root@localhost ~]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I have tried…
Abs
  • 56,052
  • 101
  • 275
  • 409
49
votes
20 answers

MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO)

I installed xampp,but when I tried to run it I got an error as thus: Error MySQL said: Documentation 1045 - Access denied for user 'root'@'localhost' (using password: NO) Connection for controluser as defined in your configuration failed. phpMyAdmin…
Saya Antisosial
  • 491
  • 1
  • 4
  • 4
40
votes
6 answers

how to 'load data infile' on amazon RDS?

not sure if this is a question better suited for serverfault but I've been messing with amazon RDS lately and was having trouble getting 'file' privileges to my web host mysql user. I'd assume that a simple: grant file on *.* to 'webuser@'%'; would…
eyberg
  • 3,160
  • 5
  • 27
  • 43
29
votes
12 answers

Django : mysql : 1045, "Access denied for user

I have the whole setup working for months on my local computer. I'm installing on a remote site now. Created a fresh mysql DB, and created a new user ("someuser") and gave it complete grants, like so - GRANT ALL PRIVILEGES ON . TO…
PlanetUnknown
  • 3,956
  • 4
  • 49
  • 67
23
votes
5 answers

mysqlimport: Error: 1045, Access denied

Does anyone know why I get this error when running mysqlimport? mysqlimport -u someone -pwhatever --columns=a,b,c,d,e bar /var/tmp/baz.sql mysqlimport: Error: 1045, Access denied for user 'someone'@'%' (using password: YES), when using table:…
Mike Conigliaro
  • 1,144
  • 1
  • 13
  • 28
1
2 3
…
12 13