Quote:
I have problems from version 5.5 to move the D: drive on the folder
containing the database.
The procedure I use is to move / date d: /
server / mysql / data / files and change datadir in my.ini. |
This isn't a very clear description of what you did.
Quote:
save any
attempt to access MySQL resolves the error 1045 - Access denied for user
root @ localhost (using password: YES I repeat that until I used the
version 5.1 this did not happen. Thanks to all who are willing to give
me an explanation. Ferradini |
One procedure to physically move the data is:
- Shut down the MySQL server daemon.
- Copy the data from the old location to the new location,
*carefully preserving ownership and permissions on all
the files and directories*
- Change the datadir parameter in my.ini
- Restart the MySQL server daemon.
If you didn't restart the server, it was probably looking for the
data (specifically the 'mysql' database which contains all the user
authorization) in the old place.
Also, if you're upgrading from 5.1 to 5.5 (which I did recently),
they recommend that you use mysqldump (under 5.1) to dump all the
data, then put up 5.5 and reload all of it. It's unclear whether
you did this previously or the procedure you're describing is also
an upgrade.