Change mysql "datadir"

[Funkeroxp]

I like change the default directory "C:../xampp/mysql/data" and move to "D:/mysql/data"
I have changed the configuration file "My.cnf" in C:/WINDOWS and copy this file in "../xampp/mysql/bin" too but xampp report error.
I copy the directory "C:../xampp/mysql/data" to "D:/mysql/data" but it the same error
Can you help me?

[Wiedmann]

but xampp report error.
..
but it the same error

Cool... Should we guess which error messsage you have?

[Funkeroxp]

PhpAdmin:

"#

Error: 2003 (CR_CONN_HOST_ERROR)

Message: Can't connect to MySQL server on '%s' (%d)"


When I move "C:..mysql/data" to "D:...mysql/data".

[Wiedmann]

Well, this is a PHP error message...

You have no error message during the start of MySQL with "mysql_start.bat"?

[Funkeroxp]

I have the XAMPP Control Panel. when I push the botton to start MySql and light green say "Running" but a few moment, then light green off.

If I choose datadir mysql default "C:...\xampp\mysql\data" , I havent got any problem.

The problem is when I choose datadir mysql in the unit "D:\mysql"

[Funkeroxp]

I try with another distributions how "easyphp" and "Wamp" and the error is the same.

Example:

Code: Select all

[wampmysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306


#Path to installation directory. All paths are usually resolved relative to this.
basedir=c:/wamp/mysql

#log file
log-error=c:/wamp/logs/mysql_error.log

#Path to the database root
datadir=d:/mysql/data

but the database not connected

[Funkeroxp]

Sorry this code is the "my.ini"
Have I change another thing?
Thanks