Bug #3939 4.0.20 for windows overwrites mysql db

• Submitted: 31 May 2004 8:27
• Modified: 31 May 2004 13:40
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Server: Installing
• Severity: S3 (Non-critical)
• Version: 4.0.20
• OS: Windows (Windows)
• CPU Architecture: Any

[31 May 2004 8:27] [ name withheld ]

Description:
Install of 4.0.20a for windows overwrites old mysql database with privileges info.

How to repeat:
install 4.0.18 mysql servewr for windows in custom directory not c:\mysql and change user table in mysql (add, change user) and then install 4.0.20a version 
ir overwrites existing mysql db

[31 May 2004 13:40] MySQL Verification Team

I did an 4.0.18 fresh install on custom basedir and added an user:

C:\mysql-4\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.18-max-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on *.* to "miguel"@"localhost" identified by "as";
Query OK, 0 rows affected (0.18 sec)

mysql> show variables like "basedir";
+---------------+-------------+
| Variable_name | Value       |
+---------------+-------------+
| basedir       | c:\mysql-4\ |
+---------------+-------------+
1 row in set (0.00 sec)

Shutdown the client and server and installed 4.0.20 on the same custom
directory and the user added with 4.0.18 is there:

C:\mysql-4\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.20a-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show grants for "miguel"@"localhost"\G
*************************** 1. row ***************************
Grants for miguel@localhost: GRANT ALL PRIVILEGES ON *.* TO 'miguel'@'localhost' IDENTIFIED
BY PASSWORD '077ba74a491e2144'
1 row in set (0.01 sec)

mysql> show variables like "basedir";
+---------------+-------------+
| Variable_name | Value       |
+---------------+-------------+
| basedir       | c:\mysql-4\ |
+---------------+-------------+
1 row in set (0.03 sec)