13

[ubuntu] MySQL giving Error 28000, Access Denied ...(using password: YES)

view full story
linux-howto

http://ubuntuforums.org – 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? See MysqlPasswordReset.) But when I follow this up using terminal: Code: glenn@acer:~$ mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) glenn@acer:~$ Why is it giving me that error when I have already set the passw (Hardware)

linuxfan's picture
Submitted by linuxfan on 05/23/2012 – Made popular on 05/23/2012

Stories similar to [ubuntu] MySQL giving Error 28000, Access Denied ...(using password: YES)

mysql problems 40 weeks 4 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

mysql can't log in 43 weeks 3 hours ago

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

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 remote connect failing 2 years 24 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 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.

mysql to mariadb upgrade 10 weeks 5 days ago

I wouldn't set a password for mysql that wasn't my root or main user password, but I still get this no matter what I try# mysql_upgrade -p Enter password: Phase 1/3: Fixing table and database names mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect FATAL ERROR: Upgrade failedI tried resetting the passwo

Hi All I am trying to install mysql on my 11.10 acer. I read the man page on installing mysql: https://help.ubuntu.com/community/ApacheMySQLPHP and so I entered:

Code: glenn@acer:~$ sudo apt-get install mysql-client-core-5.1 mysql-cluster-client-5.1 [sudo] password for glenn: which generated the following output:

Code: Reading package lists...

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.