<p>I would like to change the database files location of MySQL administrator to another drive of my computer.  (I run Windows XP SP2 and MySQL Administrator 1.2.8.)</p>

<p>--Under the startup variable --> General Parameters --> I changed <code>Data directory:</code> from  <code>C:/Program Files/MySQL/MySQL Server 5.0/data</code> to <code>D:/.....</code>, but after I stopped the service and restarted it, the following error appeared: </p>

<pre><code>Could not re-connect to the MySQL Server.
Server could not be started.

Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
</code></pre>

<p>Has anyone else had this problem? </p>

Normally it works like this:
shut down MySQL
change the
```
[mysqld]
```
and
```
[mysqld_safe]
```
```
datadir
```
variable in the MySQL configuration
change the
```
basedir
```
variable in the same section.
move the location over
restart MySQL
If that doesn't work I have no idea.  On linux you can try to move the socket to a new location too, but that shouldn't affect windows.  Alternatively you can use a symbolic link on *nix what most people do I guess.