UBB.Developers Forums UBB.threads 7 Development How Do I? change mysql connection from localhost to IP address

I am on a new install of os x server panther, my server, mysql, php are all working. I am confused on how to change the mysql server to a IP address also I think the socket needs to be added or changed. This is all new to me and I have read too much info that I know this should be far easier than I am making it. Any help with my setup, getting me going would be a great start.
Thanks Helper
running: xserve with OS X 10.3(panther server)

why do you want to change it to an IP?

Basically their is no problem doing it but you will need to GRANT PERMISSIONS for the user and password combo you are using for the IP just like the localhost.

The problem I have is mysql is only connecting via localhost and not my server address. This info I read on apples dev. site read:

Configuring and Compiling MySQL
I plan to install mysql in /usr/local/mysql. I also plan to locate the mysql UNIX socket under the /usr/local/mysql/ directory as /usr/local/mysql/run/mysql_socket so that it will be publicly available, but associated with the MySQL installation. Note that in a standard installation, the socket file would be placed in /tmp.

It seems I only have the socket in /tmp so it would'nt connect via my www.domain.com.

I am trying to install a shopping cart named supracart on my server but it will not let me make the connection. I can connect to mysql via localhost but not my domain name. I have all permission set full on for everything and every user and every Db. This program does not let you use localhost for the db server. I installed this cart on one of my outside hosted accounts with no problems. So my set up of mysql on my server is not config correct to allow outside use of the server. Again this is a new setup for me and most info I have read is all about setup of mysl for develoment and not production.
Thanks for your time.

Well if you use the ip that would allow use. However as I stated you need to allow use of the user and password via IP to the database.

See there are four types of priviledges

user % Yes ALL PRIVILEGES Yes Edit
user xx.xx.xxx.xx Yes ALL PRIVILEGES Yes Edit
usr localhost Yes ALL PRIVILEGES Yes Edit
usr somedomain.com Yes ALL PRIVILEGES Yes Edit

If you have PHPMyAdmin you should see what priviledges are on the database.