1

How can I make mysql recognize root user after install?

view story
linux-howto

http://serverfault.com – I just installed MySQL 5.5 and right after install I was asked to set root password by executing those two commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h linux-opxd password 'new-password' or /usr/bin/mysql_secure_installation I executed first command -- OK. I executed second command this time with error: error: 'Access denied for user 'root'@'localhost' (using password: NO)' I re-executed the first one (for checking) -- error as above. So, I executed mysql_secure_installation. Everything went fine and my password was recognized. So (HowTos)

taskli's picture
Submitted by taskli on 01/20/2013

Stories similar to How can I make mysql recognize root user after install?

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

I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.

So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.

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.

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 .

You do not put username and password in config.inc.php, this is only if you use $cfg['Servers'][$i]['auth_type'] = 'config';but this means that the user is directly logged in and only when you have created the user in mysql first. This method is not recommened. just comment out user and password and then create the user IN MYSQL.

As the title asks, what is wrong with this command?

mysql to mariadb upgrade 7 weeks 1 day 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

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