** URGENT ** Mysql processes problem

[kid_c]

Major problem!

I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is

• quad-xeon (500mhz each cpu)
• 3 gig RAM
• Linux Redhat 7.3

When I start up mysql, processes looking like the following begin to pile up until it kills the server:

| 106 | unauthenticated user | 192.168.1.59:1925 | NULL | Connect | NULL | login | NULL
|
| 115 | unauthenticated user | 192.168.1.53:2041 | NULL | Connect | NULL | login | NULL
|
| 118 | unauthenticated user | 192.168.1.56:4172 | NULL | Connect | NULL | login | NULL
|
| 119 | unauthenticated user | 192.168.1.56:4173 | NULL | Connect | NULL | login | NULL
|

I need to fix this immediately as my site cannot run !

Thanks in advance. I've seen this exact same situation happen to others (posted on other boards), however never saw any solutions ;/

[access9]

Did you follow these steps from the INSTALL-BINARY file included with the distribution?

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_install_db
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &

-a9

[kid_c]

Yes I have, I can try reinstalling again though just to be certain.

However, I believe the problem is something else illustrated by this example.

Originally, my DB server was 192.168.1.71 and it worked fine. We wanted to replace it with a more powerful machine however (192.168.1.79)

When my scripts/code (php pages) were changed to connect to .79 instead of .71, that's where my processes problem came in.

I decided to go back to the original DB server (.71), so I halted the new machine and added it's IP (.79) to the original machine (which now has the two IPs)

Same problem. In my code, I changed it back to .71 and problem was gone!

This seems very strange behaviour ot me, as I can't believe it works fine with one IP but not another when they are on the same machine.

Hope my explanation isn't too confusing !

[access9]

When my scripts/code (php pages) were changed to connect to .79 instead of .71, that's where my processes problem came in.

Ok, that makes things clearer. Did you add the username to the new machine? I.e. newuser@192.168.1.79? It may be trying to conect to .79 as user@192.168.1.71.

[kid_c]

Well in the mysql.user table I am allowing the host 192.168.1.%.....so that shouldn't be a problem.