Hello everyone.

I have a RH9 server that is being used as a web server for several php/mysql apps. I recently had to setup the sendmail function in order for certain scripts to be able to send update notification emails via web based scripts as my php.ini is setup to use sendmail vs. smtp

The server has been running well for a while now but the hostname was the default localhost.localdomain in the hosts file and now I need it set to a valid fqdn in order for sendmail to work properly. This seems like no biggie but when I altered my /etc/hosts to give me a good hostname according to sendmail I noticed that my sites could not connect to their respective mysql databases as they were setup to connect as username@localhost and now my hostname is no longer localhost. So my question is ....how do I setup RH9 with a valid hostname so that sendmail can send properly without hosing up my mysql database connections?

It would seem like I would simply need to edit the db connection scripts to use mysqlusername@newhostname but I was hoping I could change the server's hostname to whatever and then set the mysqld to use server name of localhost even though the server's hostname is example.exampledomain.com

Any suggestions are appreciated.

Did you keep the entry: in your /etc/hosts? There must be such ab entry in order to be able to use localhost to connect to mysql.

Regards

yes, I kept the loopback as localhost and I set the static ip to the fqdn hostname, then I placed an entry for hostname to define the fqdn as the hostname. The issue is that I am connecting to the mysql db from another server on my lan and so it uses the static ip of the web server for the connection and the static ip of the webserver gets resolved to the fqdn by the hosts file and the db runs on localhost so the remote db user of whatever@localhost does not work.

Thanks for your reply

In that case you should grant privileges to the root@IP or root@FQDN in your mysql users table.