Hey Anthony,
> I am using MySQL Workbench version 5.2.31.CE, on a
> Dell PowerEdge 4400 with 2GB RAM 50GB HD in RAID
> 5, and W2003 Server installed (my development
> server). MySQL Server version 5.5.8 is installed
> (I also installed MySQL ODBC COnnector 5.1.8 - not
> sure if it is needed). MySQL is installed on the
> C:\ drive of the local machine.
No, the connector is not needed for WB (but might later be for other applications). WB uses the C++ connector (which is compiled into a library which is shipped with it).
> I had to create users (in command line) prior to
> entering the New Server Instances wizard, or the
> wizard would fail at the Test DB Connection stage
> with the following error:
When installing the MySQL server you can use the config wizard to set up a proper root user account. This can be used to bootstrap everything else (further users, initial dbs etc.). This wizard is in the server application folder and can be re-run at any time.
> After that, I can only seem to set the hostname as
> an IP address and not by the subdomain name. If I
> try to use the subdomain name I get the following
> error:
You said name resolution is working for you, so it must be something else.
> Connecting to MySQL server mysqldb.mysite.com...
> Lost connection to MySQL server at 'reading
> initial communication packet', system error: 2
Try removing the bind-address setting in the config file of the server and restart it.
> If I specifiy the hostname as an IP address and
> use one of the users I created in command line, I
> get as far as the "Management and OS" screen
> before I hit the next problem. I would like to
> use Native Windows Remote Management to manage the
> database, so that I have the potential to use this
> to remotely administer the databse, but I can't
> find information on what information needs to be
> input here. Can anyone help with this?
Keep in mind native Windows remote management works only if the future target machine is also a Windows box. The "Management and OS" page allows to select what remote management you want (none at all, native Windows mgm or SSH based, which is mostly for non-Win systems unless you install an SSH server on your target box).
> When I create a new server instance, all the files
> relating to it seem to be on the C:\ drive. I can
> see that you can change the root folder for data,
> although I am not sure if changing this would make
> much difference? Should I have installed on the
> Z:\ drive in the first place seeing that I want to
> access the database as if it were situated on the
> virtual server?
The path you give for the instance is purely to find and edit the server configuration file. For Windows the default is where the server is installed (depending on the server version, might change in the future). You can set this to any accessible path where the ini file is located. For remote servers you would need a share on that machine which allows access to the file. Usually there is the admin share C$, which has access to the full C drive (similar for the other drives), provide you log in with a user that has admin rights. For further details read my blog posting (http://wb.mysql.com/?p=892).
> Is what I am trying to achieve possible? Am I
> going about it the right way?
Provided you solve that IP problem I see nothing that would prevent your test setup. The path for the config file is slightly tricky if you want the path to be the same for both, your local test setup and the final setup. You could map a drive but I'd rather use the local file now (direct path) and later change the server instance to use the remote path, once you deployed your setup.
Mike
Mike Lischke, MySQL Developer Tools
Oracle Corporation
MySQL Workbench on Github:
https://github.com/mysql/mysql-workbench
On Twitter:
https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to
http://bugs.mysql.com
MySQL documentation can be found here:
http://dev.mysql.com/doc/refman/8.0/en/