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
6
votes
3 answers

mysql client connection hostname question

Have a question that I can't seem to find an answer for. I am trying to connect to a remote database. I type in the following to my Ubuntu shell: mysql -u test -h mysql.domain.com -p mysql asks for my password and then outputs the…
TCCV
  • 2,986
  • 4
  • 23
  • 30
6
votes
2 answers

MySQL Error 1045, "Access denied for user 'user'@'localhost' (using password: YES)"

This question seem to be asked a lot however I cannot find a definitive answer. I am making some webapp tests using MySQL, and at the beginning I used the 'root' user (with a non-empty password). My root user is working fine from the apps (tested…
Carlos Eugenio Thompson Pinzón
  • 2,416
  • 4
  • 16
  • 20
5
votes
7 answers

access is denied for user 'root'@localhost mysql error 1045

I am new to PHP. I get the following error when executing my application: In phpMyadmin the code is like this $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] =…
Gnanendra
  • 63
  • 1
  • 3
  • 7
5
votes
2 answers

How to allow user to login to MySQL?

As a root mysql user, I executed the following: grant all on mydb.* to john identified by 'john1'; Then from shell, I tried to login via mysql -h localhost -u john -pjohn1; But when I do this, I get the error ERROR 1045 (28000): Access denied for…
John
  • 28,573
  • 67
  • 217
  • 373
4
votes
2 answers

FILE privilege to MySQL session/user

When someone is registerd in my MySQL database, this function must work: mysql_query("SELECT mail FROM users INTO OUTFILE 'test.txt'"); But I get the error Access denied for user 'registerdb'@'%' (using password:…
Francis Michels
  • 517
  • 3
  • 6
  • 14
4
votes
3 answers

Mysql_real_escape_string() A link to the server could not be established

I get this error when I try to use mysql_real_escape_string(). Access denied for user 'ODBC'@'localhost' (using password: NO) I don't understand why I must be connected to the database to check if the values are OK to insert to MySQL.
ganjan
  • 6,443
  • 22
  • 74
  • 126
4
votes
1 answer

Grant database user folder access

I'm trying to create a csv export of data from mysql using the following query: SELECT * INTO OUTFILE '/tmp/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM getfreepellets WHERE 1 And I…
hookedonwinter
  • 11,741
  • 17
  • 55
  • 73
4
votes
2 answers

Rails Development- MySQL Connection Problems

I'm new in Rails. I tried a lot to solve my problem with the answers given in this site, but failed. 1.My configurations Window 7 64bit ruby 1.9.3p484 rails 4.0.2 mysql server 5.0.91-community-nt (32bit) mysql gem I set a password for root in…
deadbug
  • 414
  • 4
  • 16
4
votes
4 answers

Getting "Access denied for user 'root'@'localhost' (using password: NO)" in production mode and no errors getting logged

I deployed my Rails app and am getting 500 Errors on all pages. My production.log isn't showing anything (which is a problem), but I did a 'script/console production' and tried to run a simple query (User.find :first) and it throws this: Access…
Shpigford
  • 22,682
  • 52
  • 149
  • 235
3
votes
1 answer

MySQL access denied 1045 error

I'm getting a very strange error, I've created a user 'testuser' with the following credentials: CREATE USER 'testuser'@'%' IDENTIFIED BY '123456'; GRANT ALL PRIVILEGES ON *.* TO 'testuser'@'%'; FLUSH PRIVILEGES; I have also modified my…
Chris
  • 5,566
  • 9
  • 42
  • 57
3
votes
1 answer

Requiring SSL for the database connection for MediaWiki/Apache/PHP/MySQL with OpenSSL

For a school project, I have installed MediaWiki on my local machine, and am required to have any database connection to the local MySQL database use SSL. I am unsure of how to connect all the dots. Here's what I have done so far: I have…
David Hodgson
  • 9,544
  • 17
  • 53
  • 77
3
votes
5 answers

MySql Python connect

I'm trying to connect python with MySQL, but I get this error: OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)") I'm trying to solve it for 6 hours and I fail. Can any one please help me ?
Joja Ingy
  • 699
  • 1
  • 7
  • 8
3
votes
1 answer

brew install mysql on snow leopard not quite working

I installed mysql via brew, looks like the install went ok. Mysql will not let me set root password, even if I get tricky. Appears as though tables are missing altogether. Detailed output below. jb:~ jb$ brew install mysql ==> Downloading…
John Breedlove
  • 385
  • 1
  • 3
  • 13
3
votes
0 answers

AWS RDS Super Privileges

We have AWS RDS instance. We would like to track database user login details like the last login. For this, we have written a stored procedure and we would like to call that procedure on the event init_connect. But we are not able to set the…
user166918
  • 31
  • 1
  • 3
3
votes
1 answer

How to access remote mysql host on Ubuntu inside VMware?

I'm running Ubuntu 10.10 inside VMware fusion on Mac OSX Snow Leopard. Inside ubuntu, I'm attempting to use command-line mysql to connect to a database hosted on a separate web server. For some reason, mysql misinterprets the remote hostname as a…
Nick Grossman
  • 31
  • 1
  • 2
1 2
3
…
11 12