List:General Discussion« Previous MessageNext Message »
From:Sharad Date:August 18 2008 10:58am
Subject: Re: MySQL Error Number 1045 Access denied
View as plain text  
Alternatively you can try this if the box is unix/linux :

sudo mysqld_safe --skip-grant-tables --user=root &
mysql -u root

Change your root password 

Restart mysql after this. 

Cheers

Sharad 


Andy Shellam wrote:

> Hi Andrew,
> 
> I think he means re-install MySQL and provide a root password (you
> said when you originally installed it that you didn't give it a
> password.)
> 
> After you've done this, try mysql from the command-line explicitly
> telling it to use the user "root":
> 
> mysql --user=root --password
> 
> The "--password" here tells mysql to prompt you for a password, or
> alternatively you can provide the password on the command-line too:
> 
> mysql --user=root --password=<password>
> 
> Once you can login via the command-line there's no reason why the
> Admin GUI shouldn't be able to login too.
> 
> Regards,
> 
> Andy
> 
> 
> Quoting AndrewMcHorney <andrewmchorney@stripped>:
> 
>> How does one done this?
>>
>> At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote:
>>> Hi Andrew
>>>
>>> As  per  your  Question , you can  test with the below solution :-
>>>
>>> Try   to  reconfigure  MySQL  by  providing  the  root  password and 
>>> then
>>> try  to run  the
>>>
>>> administer  GUI. This  should  solve the  problem.
>>>
>>> CHAVA
>>>
>>> On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
>>> <andrewmchorney@stripped>wrote:
>>>
>>>> Hello
>>>>
>>>> I am still getting the MySQL Error Number 1045 Access denied error
>>>> message when running the adminstrator gui. I attempted to start mysql
>>>> from the dos command line via "mysql" and I am getting the following.
>>>> ERROR 1045 (28000):
>>>> Access denied for user 'ODBC'@'localhost' (using password: NO). I am
>>>> logging in as root, locahost and no password because I did not enter
>>>> one when I installed the software. I will be changing that. For the
>>>> command line
>>>> I just entered mysql and a return. How can I fix this. I am off
>>>> for the week
>>>> and I would like to get this working so I can create a database or 2.
>>>>
>>>> Andrew
>>>>
>>>>
>>>> --
>>>> MySQL General Mailing List
>>>> For list archives: http://lists.mysql.com/mysql
>>>> To unsubscribe:
>>>> http://lists.mysql.com/mysql?unsub=1
>>>>
>>>>
>>>
>>>
>>> --
>>> Sreekanth CHAVA
>>>
>>> No virus found in this incoming message.
>>> Checked by AVG.
>>> Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date:
>>> 8/16/2008 5:12 PM
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>>
>>
> 


Thread
MySQL Error Number 1045 Access deniedAndrewMcHorney17 Aug
  • Re: MySQL Error Number 1045 Access deniedSreekanth CHAVA17 Aug
    • Re: MySQL Error Number 1045 Access deniedAndrewMcHorney18 Aug
      • Re: MySQL Error Number 1045 Access deniedAndy Shellam18 Aug
  • Re: MySQL Error Number 1045 Access deniedSharad18 Aug
Re: MySQL Error Number 1045 Access deniedAndy Shellam18 Aug
  • Re: MySQL Error Number 1045 Access deniedPaul Choi18 Aug