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)
179 questions
370
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
  • 4,836
  • 3
  • 20
  • 18
211
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
  • 8,567
  • 34
  • 76
  • 100
175
votes
13 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
  • 1,929
  • 2
  • 12
  • 10
147
votes
17 answers

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

I'm new to MySQL, 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…
Nasser Hadjloo
  • 11,264
  • 15
  • 66
  • 97
113
votes
11 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
  • 24,052
  • 51
  • 126
  • 164
113
votes
8 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
  • 21,552
  • 40
  • 100
  • 126
105
votes
14 answers

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,051
  • 2
  • 8
  • 3
79
votes
12 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
  • 49,145
  • 57
  • 120
  • 139
78
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,251
  • 10
  • 43
  • 72
64
votes
28 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
  • 641
  • 1
  • 5
  • 4
49
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
  • 51,038
  • 92
  • 260
  • 394
42
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
  • 421
  • 1
  • 4
  • 4
35
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
  • 2,960
  • 5
  • 24
  • 41
26
votes
10 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,639
  • 4
  • 44
  • 63
21
votes
4 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
  • 970
  • 1
  • 9
  • 22
1
2 3
…
11 12