| Bug #68821 | MySQL Server 5.6 installs to odd directory: can't access existing schema | ||
|---|---|---|---|
| Submitted: | 31 Mar 2013 15:07 | Modified: | 29 Apr 2013 12:56 |
| Reporter: | Robert Peake | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S2 (Serious) |
| Version: | 5.6 | OS: | Windows (Window 7 64-bit) |
| Assigned to: | CPU Architecture: | Any | |
[1 Apr 2013 10:43]
MySQL Verification Team
See also: http://bugs.mysql.com/bug.php?id=68227
[1 Apr 2013 14:10]
MySQL Verification Team
Please check for duplicate with the bug pointed by Shane. Thanks.
[2 Apr 2013 18:20]
Robert Peake
Looks like the identical problem described in 68227. I should add that I tried moving the existing (5.5) installed program files to C:\Program files (x86)\MySQL, changing the existing my.ini to point to that directory and installing MySQL Server 5.6. The result was that the new program files still ended up in the Canon sub-directory. I am guessing that the installer obtains the program directory path from the existing Windows mysql55 service (or its registry entry). Please consider this a request for a program enhancement permitting the user to control where MySQL Server installs its files and perhaps some means to recover from an abortive installation.
[29 Apr 2013 12:56]
MySQL Verification Team
Duplicate of http://bugs.mysql.com/bug.php?id=68227
Description: Update from MySQL Server 5.5 caused MySQL Server 5.6 to be installed to C:\Program Files (x86)\Canon\Easy-WebPrint EX\ where my.ini contains the following: # Path to installation directory. All paths are usually resolved relative to this. basedir="C:\Program Files (x86)\Canon\Easy-WebPrint EX\" # Path to the database root datadir="G:\MySQL\data\" Previous data directory was C:\ProgramData\MySQL\MySQL Server 5.5. The error file (VIDEO.error, in my case) reflects that this path was picked up from the prior installation: 2013-03-31 09:38:09 4368 [Note] C:\Program Files (x86)\Canon\Easy-WebPrint EX\bin\mysqld: ready for connections. Version: '5.6.10' socket: '' port: 3306 MySQL Community Server (GPL) 2013-03-31 09:39:11 4368 [Note] C:\Program Files (x86)\Canon\Easy-WebPrint EX\bin\mysqld: Normal shutdown I can see the databases and tables from the MySQL prompt (using no password even though the root password was specified on installation. But I cannot access the data from MySQL Workbench ("Cannot connect to database server"). I have copied the schema to the new data directory to no avail. Is there a way to re-install MySQL manually selecting new directories? I have a duplicate database (MySQL 5.5) running on another machine, so this is not a critical problem, but I would like to resolve it. I can provide the error log, etc. if it would be helpful. How to repeat: I have no idea how this problem originated (sorry).