I'm swapping my websites from one server (Debian) to another (RHEL), more powerful, server. I can't afford much downtime, and the site uses MySQL for VIP member signups. I installed MySQL 5 on the new RHEL server and moved over all of the data from the old server (mysqldump > file > mysql). I'm trying to swap the websites on the old server to use the database on the new server (different location) before I move the site over so both the new server and old server have websites running on the same data.
I've configured the users on the new MySQL. I set the user to allow connections from anybody (%) and granted it limited access to the needed databases. I flushed the privileges and connected from my local machine to the server via MySQL Administrator as well as MySQL Query Browser without a hitch.
I then popped into the old server and tried to connect to the new server via " $: mysql -h newserver.com -u username -pPASSWD databasename" and I got an Error 1045. I also connected from my CentOS server that is at the same location as the new RHEL server via command line without a problem.
Exact error message is "ERROR 1045 (28000): Access denied for user 'user'@'example.com' (using password: YES)". The username and host are masked. The odd thing is that it is displaying "@example.com" when that is actually the host of the new server, and example.net is the host of the old server.
Old Server: Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
New Server: Ver 14.12 Distrib 5.0.45, for pc-linux-gnu (i686) using readline 5.0
Tested From: Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3
What's going on?