mysql_upgrade fails with "Access denied"

I'm trying to run mysql_upgrade but I get:

# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306'
'--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
(using password: NO) when trying to connect
FATAL ERROR: Upgrade failed

I've also tried specifying my root password with --password and also
specifying -u mysql but it still fails with error 1045. My
/etc/passwd file looks like there is no password for user mysql. What
else should I try?

- Grant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql_upgrade fails with "Access denied"

On 11/28/2010 2:02 PM, Grant wrote:
> I'm trying to run mysql_upgrade but I get:
>
> # mysql_upgrade
> Looking for 'mysql' as: mysql
> Looking for 'mysqlcheck' as: mysqlcheck
> Running 'mysqlcheck' with connection arguments: '--port=3306'
> '--socket=/var/run/mysqld/mysqld.sock'
> mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
> (using password: NO) when trying to connect
> FATAL ERROR: Upgrade failed
>
> I've also tried specifying my root password with --password and also
> specifying -u mysql but it still fails with error 1045. My
> /etc/passwd file looks like there is no password for user mysql. What
> else should I try?
Is this 5.5.7? You have to run the server with --skip-grant-tables, then
run mysql_upgrade.

PB
http://www.artfulsoftware.com

> - Grant
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql_upgrade fails with "Access denied"

>> I'm trying to run mysql_upgrade but I get:
>>
>> # mysql_upgrade
>> Looking for 'mysql' as: mysql
>> Looking for 'mysqlcheck' as: mysqlcheck
>> Running 'mysqlcheck' with connection arguments: '--port=3D3306'
>> '--socket=3D/var/run/mysqld/mysqld.sock'
>> mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
>> (using password: NO) when trying to connect
>> FATAL ERROR: Upgrade failed
>>
>> I've also tried specifying my root password with --password and also
>> specifying -u mysql but it still fails with error 1045. =A0My
>> /etc/passwd file looks like there is no password for user mysql. =A0What
>> else should I try?
>
> Is this 5.5.7? You have to run the server with --skip-grant-tables, then =
run
> mysql_upgrade.

I'm running mysql-5.1.51 which is the latest marked stable in Gentoo.
Does this still apply? I always use Gentoo's mysql initscript so I'm
trying to find the correct command to start mysqld wtih
--skip-grant-tables.

- Grant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: mysql_upgrade fails with "Access denied"

>I'm running mysql-5.1.51 which is the latest marked stable in Gentoo.
>Does this still apply?

No, just 5.5.7.

PB

-----

On 11/28/2010 2:28 PM, Grant wrote:
>>> I'm trying to run mysql_upgrade but I get:
>>>
>>> # mysql_upgrade
>>> Looking for 'mysql' as: mysql
>>> Looking for 'mysqlcheck' as: mysqlcheck
>>> Running 'mysqlcheck' with connection arguments: '--port=3306'
>>> '--socket=/var/run/mysqld/mysqld.sock'
>>> mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
>>> (using password: NO) when trying to connect
>>> FATAL ERROR: Upgrade failed
>>>
>>> I've also tried specifying my root password with --password and also
>>> specifying -u mysql but it still fails with error 1045. My
>>> /etc/passwd file looks like there is no password for user mysql. What
>>> else should I try?
>> Is this 5.5.7? You have to run the server with --skip-grant-tables, then run
>> mysql_upgrade.
> I'm running mysql-5.1.51 which is the latest marked stable in Gentoo.
> Does this still apply? I always use Gentoo's mysql initscript so I'm
> trying to find the correct command to start mysqld wtih
> --skip-grant-tables.
>
> - Grant
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql_upgrade fails with "Access denied"

>> I'm running mysql-5.1.51 which is the latest marked stable in Gentoo.
>> Does this still apply?
>
> No, just 5.5.7.

What else should I try to prevent the 1045 error?

- Grant


>>>> I'm trying to run mysql_upgrade but I get:
>>>>
>>>> # mysql_upgrade
>>>> Looking for 'mysql' as: mysql
>>>> Looking for 'mysqlcheck' as: mysqlcheck
>>>> Running 'mysqlcheck' with connection arguments: '--port=3D3306'
>>>> '--socket=3D/var/run/mysqld/mysqld.sock'
>>>> mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
>>>> (using password: NO) when trying to connect
>>>> FATAL ERROR: Upgrade failed
>>>>
>>>> I've also tried specifying my root password with --password and also
>>>> specifying -u mysql but it still fails with error 1045. =A0My
>>>> /etc/passwd file looks like there is no password for user mysql. =A0Wh=
at
>>>> else should I try?
>>>
>>> Is this 5.5.7? You have to run the server with --skip-grant-tables, the=
n
>>> run
>>> mysql_upgrade.
>>
>> I'm running mysql-5.1.51 which is the latest marked stable in Gentoo.
>> Does this still apply? =A0I always use Gentoo's mysql initscript so I'm
>> trying to find the correct command to start mysqld wtih
>> --skip-grant-tables.
>>
>> - Grant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: mysql_upgrade fails with "Access denied"

Den 28-11-2010 21:02, Grant skrev:
> I'm trying to run mysql_upgrade but I get:
>
> # mysql_upgrade
> Looking for 'mysql' as: mysql
> Looking for 'mysqlcheck' as: mysqlcheck
> Running 'mysqlcheck' with connection arguments: '--port=3306'
> '--socket=/var/run/mysqld/mysqld.sock'
> mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
> (using password: NO) when trying to connect
> FATAL ERROR: Upgrade failed
>
> I've also tried specifying my root password with --password and also
> specifying -u mysql but it still fails with error 1045. My
> /etc/passwd file looks like there is no password for user mysql. What
> else should I try?

You should use the password for the _MySQL_ root user, which is _not_
stored in /etc/passwd, but within MySQL.

/ Carsten

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql_upgrade fails with "Access denied"

>> I'm trying to run mysql_upgrade but I get:
>>
>> # mysql_upgrade
>> Looking for 'mysql' as: mysql
>> Looking for 'mysqlcheck' as: mysqlcheck
>> Running 'mysqlcheck' with connection arguments: '--port=3D3306'
>> '--socket=3D/var/run/mysqld/mysqld.sock'
>> mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'
>> (using password: NO) when trying to connect
>> FATAL ERROR: Upgrade failed
>>
>> I've also tried specifying my root password with --password and also
>> specifying -u mysql but it still fails with error 1045. =A0My
>> /etc/passwd file looks like there is no password for user mysql. =A0What
>> else should I try?
>
> You should use the password for the _MySQL_ root user, which is _not_ sto=
red
> in /etc/passwd, but within MySQL.
>
> / Carsten

Thanks everyone. I got mysqld to start with --skip-grant-tables by
adding skip-grant-tables to /etc/mysql/my.cnf and restarting mysql.
mysql_upgrade ran without a problem.

- Grant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg