Fw: Install MySQL 5.0 Error

I see no error here, only a warning saying that you cannot login into MySQL
specifing a passsword.
As the default instalation doesn't has password, login shoud be done without
password, ex:

"mysql -u root"

You even cannot have records in the user table that has the user field with
blank spaces, check that,
To get in just shutdown the server and fire it up with
"mysqld-nt --skip-grant-tables"
and then check this situation.

Jorge



----- Original Message -----
From: "Warren"
To:
Sent: Tuesday, November 08, 2005 5:49 PM
Subject: Install MySQL 5.0 Error


>
> I have Windows XP Pro version on my PC and am trying to install MySQL 5.0
> on
> it.
> My problem is that it will not start.
>
> I recieve error as follows
>
> Error Nr. 1045
> Access denied for user 'root@localhost' (using password NO)
>
> If a personal firewall is running on your machine, please make sure you
> have
> opened the TCP port 3306 for
> connections. Otherwise no client application can connect to the server.
> After you have opened the port please
> press (Retry) to apply the security settings.
>
> Also on the MySQL Sever Instance Configuration Wizard window
> Perpare configuration is green checked
> Write configuration file is gree checked
> Start service is green checked
> Apply security settings is red Xed
>
> The security settings could not be applied.
> Error Number 1045
> Access denied for user "root@localhost' (using password: NO)
>
> could you please point me in the correct direction to get this up and
> running
>
> Thanks
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=mysql.jorge@decimal.pt
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Fw: Install MySQL 5.0 Error

On 11/8/05, Jorge Bastos wrote:
> I see no error here, only a warning saying that you cannot login into MyS=
QL
> specifing a passsword.

You missed the fact that this error comes from the MySQL Configuration
Wizard, and that the user has probably no experience using MySQL, so,
I tried tips that could make the wizard work.

> As the default instalation doesn't has password, login shoud be done with=
out
> password, ex:
>
> "mysql -u root"

The problem isn't getting a mysql console logged, but getting the
wizard to end the configuration of security settings by it logging and
issuing commands that will configure it...

> You even cannot have records in the user table that has the user field wi=
th
> blank spaces, check that,
> To get in just shutdown the server and fire it up with
> "mysqld-nt --skip-grant-tables"
> and then check this situation.
>
> Jorge
>

The configuration wizard will restart the server, try to login and
configure it, so, starting mysql with --skip-grant-tables won't help
much as MySQL will likely be shutdown before the wizard try to login.

Well, since you have an installation running (the service starts ok),
you could (but then forget about the configuration wizard and prepare
to RTM about it) reset the root password, read:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions .html

You can set the root password to nothing and use the configuration
wizard, but I sincerely advice you to use the no-install package and
read the manual.

Good luck,

> ----- Original Message -----
> From: "Warren"
> To:
> Sent: Tuesday, November 08, 2005 5:49 PM
> Subject: Install MySQL 5.0 Error
>
>
> >
> > I have Windows XP Pro version on my PC and am trying to install MySQL 5=
..0
> > on
> > it.
> > My problem is that it will not start.
> >
> > I recieve error as follows
> >
> > Error Nr. 1045
> > Access denied for user 'root@localhost' (using password NO)
> >
> > If a personal firewall is running on your machine, please make sure you
> > have
> > opened the TCP port 3306 for
> > connections. Otherwise no client application can connect to the server.
> > After you have opened the port please
> > press (Retry) to apply the security settings.
> >
> > Also on the MySQL Sever Instance Configuration Wizard window
> > Perpare configuration is green checked
> > Write configuration file is gree checked
> > Start service is green checked
> > Apply security settings is red Xed
> >
> > The security settings could not be applied.
> > Error Number 1045
> > Access denied for user "root@localhost' (using password: NO)
> >
> > could you please point me in the correct direction to get this up and
> > running
> >
> > Thanks
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> > http://lists.mysql.com/win32?unsub=3Dmysql.jorge@decimal.pt
> >
> >
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org