1

mysql can't log in

view story
linux-howto

http://ubuntuforums.org – Code: $ mysql -p -u root Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Not sure what I'm doing wrong. My google-fu may be too week: http://dev.mysql.com/doc/refman/5.1/...ss-denied.html (Hardware)

colm's picture
Submitted by colm on 08/22/2012

Stories similar to mysql can't log in

MySQL remote connect failing 2 years 20 weeks ago

Setup a new database on a machine I didn't setup. I can from the local machine issue a;

mysql -u root -p <enter>, submit the password and I'm in.

I read through http://dev.mysql.com/doc/refman/5.1/...ss-denied.html

and not sure on the issue.

mysql problems 36 weeks 19 hours ago

All I want to do is run mysql and test very basic things out, but mysql is fighting me every step of the way...

I dont think ive ever changed any settings since ive installed it, I just want to run mysql and look around etc

Code: joe@joe-U46:/etc/init.d$ mysql ERROR 1045 (28000): Access denied for user 'joe'@'localhost' (using password: NO) I try:

Code: mysql -u root -p mysql I

Hello all,

I have installed mysql using instructions from: https://help.ubuntu.com/community/ApacheMySQLPHP

Quote:

Note: If you have already set a password for the mysql root, you will need to use: mysql -u root -p(Did you forget the mysql-root password?

I encounter the error below no matter what mysql command I enter in my shell on my bluehost connected server.

ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES)

The simplest command I have tried that nets this error is

mysql -u myuser -pMypass ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES)

I am 100% sure the user and p

This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and .

I know the password is correct as I can log in with root@localhost to the mysql server and can also create users. However, when I try to grant privileges to the newly created user I get the dreaded "Access denied for user root@localhost (using password: YES)" error message.

GRANT ALL PRIVILEGES ON .

Mysql server is installed on my quest OS Centos6 (192.168.1.50) and using port 3306. I'm trying to connect from my Windows OS (192.168.1.2).

I'm getting error #1045 Access denied for user 'root'@'192.168.1.2' (using password: YES) So, as far as I understand this error is telling me that I have no rights to access mysql using user root from 192.168.1.2 host.

I receive the following error when trying to connect to mySql through phpmyadin:

MySQL said:

1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection.

Hi all, I have a basic question on MySQL:

http://de.php.net/manual/en/ref.pdo-mysql.php "Use --with-pdo-mysql[=DIR] to install the PDO MySQL extension, where the optional [=DIR] is the MySQL base install directory."

Which file should be used for that command?

edit: think it's mysql, but I'm getting "Access denied for user 'root'@'localhost' (using password: YES)".

So, I tried installing LAMP but messed up on the MySQL bit.

Here is the tutorial I used:

http://www.howtoforge.com/ubuntu_lamp_for_newbies

Here is what Step 3 says:

Step 3. This is where things may start to get tricky. Begin by typing the following into Terminal: mysql -u root

That's exactly where it gets tricky.