Strange Mysql issue

muay_tb · #1 (**permalink**) 04-27-2009

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'

Neo · #2 (**permalink**) 04-27-2009

The problems is, more-than-likely, that you forgot to change the hostname in the configuration file of your application(s). For example, if MySQL was called by Apache and the Apache config file was using the old hostname, then you would have a problem such as you described.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
strange issue with ALOM in t51...	upengan78	SUN Solaris	13	02-23-2009 11:42 AM
strange aunthentication issue with email	mcraul	UNIX for Advanced & Expert Users	0	07-15-2008 11:32 AM
Strange issue	AndrewSH	UNIX for Dummies Questions & Answers	1	01-29-2008 05:33 PM
root Password ... strange issue	badrali	Security	6	06-28-2007 09:41 AM
Strange Number comparison issue	shihabvk	UNIX for Advanced & Expert Users	9	04-10-2007 12:19 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by