If you are desperate, you can also start mysqld with --skip-grant-tables
option.
Then use mysql, update root password using the update statement that Jim
wrote about.
-Paul
On Mon, 2008-08-18 at 17:25 +0100, Andy Shellam wrote:
> FYI,
>
> I don't think this was sent to the list, forgive me if it was and I
> didn't see it.
>
> Andy
>
> --
>
> You probably don't have to reinstall it. If you never gave root a
> password, just login as Andy says below and, when prompted for the
> password, just press the ENTER key. Unless you gave root a password and
> forgot it, you should find yourself in the mysql program. Enter
> something like:
>
> update mysql.user set password = password('<new pwd>') where user = 'root';
> flush privileges;
>
> There are other ways to change a pwd, but I use that since it's easier
> for me to remember one way.
>
> Jim
>
> On Mon, Aug 18, 2008 at 3:07 AM, Andy Shellam
> <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>> 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 <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>>:
>
> 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
> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>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/[EMAIL PROTECTED]
>
>
>
>
> --
> 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/[EMAIL PROTECTED]
>
>
>
>
> --
> Andy Shellam
> Business Systems Architect
>
> Network Mail
> NetServe Support
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
> --
> Jim Lyons
> Web developer / Database administrator
> http://www.weblyons.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul Choi <[EMAIL PROTECTED]>
