2 messages in com.mysql.lists.win32RE: Install problem Version 5
FromSent OnAttachments
Stephen Salbod28 Dec 2005 10:36 
LE Backup28 Dec 2005 15:43 
Subject:RE: Install problem Version 5
From:LE Backup (lucr@shaw.ca)
Date:12/28/2005 03:43:10 PM
List:com.mysql.lists.win32

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 <username) -p (if password set if not do not add '- p') then that DATABASE NAME. If it is not local to you then the database name is followed by '@<IP address>'

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