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
3
votes
1 answer

Mysql Master Master Replication

Server1: xxx.xxx.xxx.xxx server-id=1 binlog-do-db=sample master-host = xxx.xxx.xxx.xxx master-user = someuser master-password = somepassword master-connect-retry = 60 relay-log = /var/lib/mysql/slave-relay.log relay-log-index =…
user160108
  • 922
  • 3
  • 8
  • 35
3
votes
4 answers

Connecting to MySQL on a different server

I have two servers (virtual machines - I can remotely connect to these) - server 1, and server 2. On server 1 I keep my webpages, and on server 2, I keep the databases. I am currently trying to connect to a database on server 2 from server 1. Here…
109221793
  • 15,397
  • 37
  • 100
  • 157
3
votes
2 answers

Heroku db:push Sequel::DatabaseConnectionError -> Mysql::Error: Access denied for user 'reg'@'localhost ' (using password: NO)

I have a problem using the heroku db:push command to transfer a MySQL database to heroku. I've tried using the same command for another app with a sqlite3 database and everything went fine. C:\Users\reg\Team-Omni>heroku db:push Loaded Taps…
redge
  • 31
  • 3
3
votes
2 answers

capistrano deploy: Access denied for user 'root'@'localhost' (using password: YES) (Mysql::Error)

I tried to deploy ror application on production server then got this error: Access denied for user 'root'@'localhost' (using password: YES) (Mysql::Error) but when i ran command: rake db:migrate RAILS_ENV=production it passed. I also connect to…
ohana
  • 71
  • 1
  • 4
3
votes
3 answers

Beginner MYSQL Error - Access Denied

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N O) I've tried EVERYTHING, I've read through pages of answers and no-one seems to know the right one. When i try to log into my DB i just get the above error, I havent…
WANNABE
  • 283
  • 1
  • 2
  • 11
3
votes
3 answers

Problem starting up mySQL

I just downloaded PHP and I tried running mySQL with the command: C:\Program Files\EasyPHP-5.3.2i\mySQL\bin\mysql.exe And I got the error: ERROR 1045 (28000): Acess denied for user 'ODBC'@localhost' (using password: YES) I found a solution online…
ptabatt
  • 63
  • 5
3
votes
2 answers

Grant privileges on MariaDB

I'm trying to grant privileges for user on MariaDB 10, but I've got an error 1045 [root@lw343 ~]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 42 Server version:…
Ivanoff
  • 83
  • 2
  • 8
2
votes
2 answers

MySQL GRANT to User@'host' not behaving as expected

EDIT: I reinstalled MySQL and this fixed itself. No idea what the issue was. I ran the following commands in MySQL from the command line: 1. REVOKE ALL PRIVILEGES ON MyDB.* FROM user@'%'; 2. DROP USER user@'%"; 3. GRANT INSERT,SELECT,DELETE,UPDATE…
Ignacio
  • 4,400
  • 1
  • 13
  • 10
2
votes
2 answers

MySQL Running SQL Script error - [WinError 32] The process cannot access the file because it is being used by another process:

I am getting an error while running a SQL script to load data. Error is pasted below: Preparing... [WinError 32] The process cannot access the file because it is being used by another process:…
Pratik Sinha
  • 21
  • 5
2
votes
3 answers

PhpMyAdmin password

I get the error #1045 - Access denied for user 'root'@'localhost' (using password: NO) after I accidentaly changed the password in phpmyadmin for root and 127.0.0.1 . the problem is i cannot change common.lib.php. I want to revert these changes in…
ka_lin
  • 8,596
  • 5
  • 31
  • 50
2
votes
2 answers

mysql password not working

Possible Duplicate: How to reset mysql root password ? I executed the query UPDATE mysql.users set password= PASSWORD('123456') WHERE users='root' and host='localhost'; flush priviledges; and after this mysql is not running. phpmyadmin and…
Jaimin
  • 791
  • 2
  • 11
  • 27
2
votes
2 answers

phpMyAdmin Access denied

phpMyAdmin give this error. MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: YES) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and…
chrithccmc
  • 997
  • 4
  • 12
  • 17
2
votes
1 answer

MySql ERROR 1045 (00000): Access denied - different MySQL versions

I need to get an old MySQL Client (4.1) to connect to an even older MySQL Server (3.23). The goal is to do a Java/JDBC connect to the old Linux/MySQL 3.23 database, in order to update text information for a Lucene search (which will also run on…
paulsm4
  • 99,714
  • 15
  • 125
  • 160
2
votes
2 answers

Connecting to MySQL from a VB6 application

I am trying to connect to a local MySQL database from a VB6 application. Having read the answer given in this question, Connecting VB to MySQL I have set up my connection thus... Private database_connection As ADODB.Connection Set…
Brian Hooper
  • 20,414
  • 23
  • 82
  • 132
2
votes
3 answers

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

I use Scrapy and wnat to insert the Data in my database. in my database.py i have def __init__(self, host='', user='', password='', database=''): self.__host = 'localhost' self.__user = 'root' self.__password = 'mypass' …
parik
  • 1,924
  • 10
  • 36
  • 62
1 2 3
…
11 12