ok after a lot of fiddling about I finally manged to get MySQL v4.1.9 working on a new server I am going to be moving all my old MySQL version (4.0) databases to.
I wanted to update the root password as I felt the old one was insecure and that works fine. The problem I have now is how to move 50+ databases along with the associated username and passwords from one server to another.
At the moment I have the mysql server IP set in phpMyAdmin on my ne server to my old server, its very slow as there happens to be 6,000 miles seperating the servers
So my question is what is the best way to move the databaes from one server to another at the same time retaining all the usernames and passwords?
My users have all been infomed that the MySQL IP address will be changing and if they have it hardocded into their apps, to change it once the move is complete..