The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Special Forums > Web Programming, Web 2.0 and Mashups
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 04-27-2009
muay_tb muay_tb is offline
Registered User
  
 

Join Date: Mar 2008
Posts: 31
Strange Mysql issue

Hi all,

I recently changed the name of my hostname from 'abc123' to 'abc456' (as an example).

I then added a user in my mysql database with the new host and removed references to the old users and hostname.

The strange thing is though, a process using the database still uses the old hostname!!

which then forced me to add the old names back into the database....

can anyone explain to me why this is the case and how i can ensure that all processes use the new hostname i.e. 'myuser'@'abc456' and NOT 'myuser'@'abc123'