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
>>
>>
>>
>
