mysql on XP Pro problems

[mbtimmons]

I am currently trying to setup Cacti on an XP Pro box. I have succeeded on a W2K Pro box, but now need one for a different network. I am using mysql-4.0.12-win (because it worked on the W2K box), but have two problems. With mysql-4.0.12, when I first installed it, I ran the "winmysqladmin.exe" and it asked for a user and password. At that time, I entered 'root' and 'abc123'. The "Traffic Light" in the systray shows that MySQL is running.

From the installation guide, I enter:
C:\>mysqladmin -u root password 'abc123'

C:\>mysqladmin --user=root --password reload
Enter password: ****** /Here I entered abc123
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@127.0.0.1' (Using password: YES)'

C:\>mysqladmin --user=root --password reload
Enter password: /Here I left it blank

C:\>

From this point on, I have to leave to root users password blank to execute any commands. This is a minor issue, but any ideas as to why?

Now, the big problem. When I try to create the MySQL username and password for Cacti, it fails. I've created the database, and imported the default data, but creation of the user fails thusly;

mysql> grant all on cacti.* to cactiuser@localhost identified by 'cacti';
ERROR 1044: Access denied for user: '@127.0.0.1' to database 'cacti'
mysql>

I have a Windows user account called 'cactiuser', with a windows password of 'cacti'.

[mbtimmons]

I'm not sure why this occurred, but I found a fix at:

http://dev.mysql.com/doc/refman/5.0/en/ ... enied.html

Once I used the SET PASSWORD command
Set the password like this:

mysql> SET PASSWORD FOR 'abe'@'host_name' = PASSWORD('eagle');

I then quit and relogged in, maybe needlessly. Then, when I ran the command to create the cactiuser, MySQL accepted it.

[BSOD2600]

I suggest you read the guide in my signature for setting up cact.

[mbtimmons]

I did. I also read the FAQ section at the end. It did not address the problem that I encountered.

However, my cacti system is functioning now on both Win2K and Win XP Pro.