Install problem Version 5

--Boundary_(ID_znzqL2d22xlAV2GU9m5s7A)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT


Warning! Warning!
I'm a newbie looking to develop a web application. Since I have no working
experience with MySQL I thought I'd install on my XP and work through a
tutorial. I'm having problems with security settings of the installation:
I'm unable to run the MySQL Server Instance Config Wizard successfully. I
keep getting a red x for 'Apply security settings'.

MySQL does work when I use the following command: mysql -u localhost .


My problem is identical to Warren date 11/8/2005:

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 received 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
Prepare configuration is green checked
Write configuration file is green 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"

Here are the steps I took to OPEN 3306 port:

START -> My Network Places
-> View network connects
-> Change Window Firewall settings
(Select Exceptions Tab)
-> Add Port..
TYPE in boxes:
-NAME: MySQL Port
-Port #: 3306
TCP button selected.
-> Change Scope
-Any Computer.. selected (I'M NOT SURE ABOUT THIS DEFAULT OPTION.)
I end everything with OKs.



Any suggestions would be greatly appreciated.



Thank you.






--Boundary_(ID_znzqL2d22xlAV2GU9m5s7A)--

RE: Install problem Version 5

Responses inline:

> Warning! Warning!
> I'm a newbie looking to develop a web application. Since I
> have no working experience with MySQL I thought I'd install
> on my XP and work through a tutorial. I'm having problems
> with security settings of the installation:
> I'm unable to run the MySQL Server Instance Config Wizard
> successfully. I keep getting a red x for 'Apply security settings'.
>
> MySQL does work when I use the following command: mysql -u
> localhost .
>

This is incorrect. Mysql -u add '- p') then that DATABASE NAME. If it is not local to you then the
database name is followed by '@'


>
> My problem is identical to Warren date 11/8/2005:
>
> 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 received error as follows
>
> Error Nr. 1045
> Access denied for user 'root@localhost' (using password NO)

This tells you the root user has no password so 'mysql -u root
' should do the trick.


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

Make sure 3306 is open on your mysql server.


> Also on the MySQL Sever Instance Configuration Wizard window
> Prepare configuration is green checked Write configuration
> file is green 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"
>
> Here are the steps I took to OPEN 3306 port:
>
> START -> My Network Places
> -> View network connects
> -> Change Window Firewall settings
> (Select Exceptions Tab)
> -> Add Port..
> TYPE in boxes:
> -NAME: MySQL Port
> -Port #: 3306
> TCP button selected.
> -> Change Scope
> -Any Computer.. selected (I'M NOT SURE ABOUT THIS
> DEFAULT OPTION.)
> I end everything with OKs.

I would simply disable windows firewall (ICF). At least as long as needed
to verify this works. You can also start mysql using named pipes instead of
TCP ports by starting the service with the option --enable-named-pipes (on
mysqld or equiv. not the mysql.exe) to avoid using TCP/IP if you like (or to
test).


> Any suggestions would be greatly appreciated.
>

HTH...

> Thank you.

Your welcome.




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