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
19
votes
2 answers

Mysql permission errors with 'load data'

I am running into a permission error when trying to load data from a flat file database dump into a new table. I know that the schema of the file and my table is the same and I tried tweaking the permissions. What else should I try? mysql> load data…
sutee
  • 11,322
  • 12
  • 46
  • 60
18
votes
4 answers

MySQL: can't access root account

I'm running MySQL 5.x on my local Windows box and, using MySQL administrator, I can't connect to the databases I created using the root account. The error I get is: MySQL Error number 1045 Access denied for user 'root'@'localhost' (using …
NogFather
17
votes
14 answers

Can't get access to PHPmyAdmin after setting a root password and using Instant Rails

Wanted to get started with Ruby on Rails so I installed instant rails and set up a mysql password. Problem is now I can't get access to phpmyadmin. From the rails control panel, when I go to configure >> database (via PhpMyadmin) it opens up…
Derek
  • 171
  • 1
  • 1
  • 3
16
votes
7 answers

How to reset mysql root password?

I have a little problem with my phpmyadmin, in fact I accidentally delete multiple user accounts. Since it is impossible to connect without the error: # 1045 - Access denied for user 'root' @ 'localhost' (using password: NO) I have search a little…
4m0ni4c
  • 169
  • 1
  • 1
  • 4
15
votes
4 answers

MySQL command line won't open?

I just installed the latest version of MySQL. Until Now I had it on Windows XP but I wanted to install this on another computer with Windows 7. Even after configuring everything correctly, the MySQL client won't show up in the Start Folder. So I…
Gaurav
  • 671
  • 3
  • 8
  • 21
14
votes
2 answers

Query output to a file gives access denied error

I am trying to capture the output of a SQL query in MySQL, to a text file using the following query. select count(predicate),subject from TableA group by subject into outfile '~/XYZ/output.txt'; I get the following error. ERROR 1045 (28000):…
Arnkrishn
  • 27,376
  • 39
  • 108
  • 127
9
votes
5 answers

Is there any way to catch MySQL and database errors in PHP?

Sometimes I am getting a database error like Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'test'@'101.190.193.83' (using password: YES) Could not connect: Access denied for user 'test'@'101.190.193.83' (using password:…
ASD
  • 4,399
  • 10
  • 33
  • 55
9
votes
2 answers

Cannot create PoolableConnectionFactory (Access denied for user ''@'localhost'

I have been trying to set up a DatabaseConnectionPool for a web app for the last couple of days with no success. I have read the relevant sections of the Tomcat docs and a great deal around the subject and think I'm doing everything right, but…
Joe
  • 4,562
  • 9
  • 55
  • 79
8
votes
5 answers

MySQL reinstalled, but root password still there and I forgot it

I forgot my root password in MySQL 5.1 on Windows 7 I uninstalled and deleted the MySQL directory in Program Files Then I installed 5.5, but get error 1045, saying: Access denied for user: 'root@localhost' I thought that uninstalling MySQL, and…
Tim
  • 89
  • 1
  • 1
  • 3
8
votes
3 answers

Proper permissions for "SHOW TABLE STATUS" in MySQL

I can insert, update, delete, etc. to a table in my MySQL database but I cannot show the table status. Does anyone know which privilege(s) is needed to do this? Here is my error message: Access denied for user 'admin459'@'localhost' to database…
H. Ferrence
  • 7,306
  • 31
  • 88
  • 155
8
votes
2 answers

How to change root password to an empty one?

How can I change the root password to an empty one in MySql? The following gives "Access denied for user 'root'@'localhost' (using password: YES)" error. I'm sure I've typed my password correct (it's only 123456) mysqladmin -u root -p'123456'…
dstr
  • 7,053
  • 9
  • 58
  • 100
7
votes
4 answers

Error #1045 Access Denied in PhpMyAdmin

Basically I changed the password of MySQL via CMD and after that when I tried to visit the phpmyadmin page it shows me Error #1045 Access Denied. I would like to how to fix this problem. Thanks in advance.
Shabir Gilkar
  • 323
  • 2
  • 7
  • 19
7
votes
10 answers

Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@'localhost' (using password: YES)

An application was handed to me by an old colleague to manage. However, whenever I try to run it, I keep getting this error. Please any help would do.
segdavids
  • 81
  • 1
  • 1
  • 7
6
votes
3 answers

underscore in php db variable causing problems

I store all of my login information for databases in files outside of the public tree in variables such as $hostname = '172.0.0.0'; $dbname = 'myname_mydbname'; $username = 'myname_user'; $pw = 'password'; That's pretty standard. The problem is…
david
  • 636
  • 1
  • 5
  • 10
6
votes
1 answer

MySQL permission denied from local but can connect remotely

I am trying to connect to my mysql database on a remote server (via ssh) through the command: mysql -u me -h mydomain.com -p But it fails with a ERROR 1045 (28000): Access denied for user.. error While mysql -u me -h localhost -p Works Now this…
zenna
  • 8,540
  • 10
  • 67
  • 100
1
2
3
…
11 12