3

MySQL 5.5 on CentOS 6 -- mysql user 'root@localhost' cannot grant privs

view full story
linux-howto

http://serverfault.com – 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 . TO 'myUserName'@'localhost' IDENTIFIED WITH 'myUsersPass' WITH GRANT OPTION; Returns: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) There's got to be something sma (HowTos)

u85500's picture
Submitted by u85500 on 12/30/2011 – Made popular on 12/30/2011

Stories similar to MySQL 5.5 on CentOS 6 -- mysql user 'root@localhost' cannot grant privs

I've having some very weird issues with my MySQL (5.5) root user. I'm trying to allow an external host to access the root user, but it seems as though my root@localhost does not have "GRANT OPTION" to the local databases!

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 problems 39 weeks 6 days 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 am initializing a new DB but unable to connect to it -- it says root is not authorized. I was assuming creating a blank/new DB would allow root at localhost to connect.

mysql can't log in 42 weeks 6 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

Please help as I am pulling my hair out once again after trying for over 15 months off and on to get a tv tuner working under linux. I have just received my new tuner card which I thought was supposed to be easy to run, a HVR-950Q, no luck yet.

But first I am trying to use something called mysql (new to me), for mythtv and [I] keep getting

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.