1

mysql problems

view story
linux-howto

http://ubuntuforums.org – 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 get: Code: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) (Hardware)

dayu's picture
Submitted by dayu on 09/12/2012

Stories similar to mysql problems

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

mysql can't log in 39 weeks 2 days 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

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.

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.

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.

So I'm running crunchbang linux and installed mysql-server using the following terminal command:

sudo apt-get install mysql-server

Setup runs without problems, but when trying to access mysql I get "Error 1045 Access denied". The tutorial I used stated that during setup of mysql-server I'd be asked to set a password, but this step never happened.

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.