I am using the following version of LinuxES

Linux master 2.6.9-5.EL #1 Wed Jan 5 19:22:18 EST 2005 i686 i686 i386 GNU/Linux

I want to use MySQL server version: 4.0.16 becuase my product is using this MySQL version

But LinuxES comes with default MySQL-4.1.7 which I want to uninstall and install MySQL server version: 4.0.16 and the client version of MySQL client version: 4.0.16

Can any one help the following queries ASAP, step-by-step procedure

(1) How to install MySQL server version: 4.0.16
(2) How to start the mysql services
(3) I am presently using mysql-jdbc.jar JConeector-3.0.1 version
(4) I want to know its a MySQL problem or LinuxEL problem.

you really expect all that? you really need to learn to understand rpm files and such using standard documentation.

but basically installing 4.0.16 should just be a case of installing the relevant rpms's after removing the old ones. i wouldn't recommend you to install it from source at all.

as for 3) and 4).. they aren't even questions....

I have already done point (1) , but when I try to login to MySQL as

I have installed MySQL-server-4.0.16-0.i386.rpm and MySQL-client-4.0.16-0.i386.rpm
I am using the following command to login to mysql

# mysql -u root

I have got the error as

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I have seen the /var/log/messages file for the error and the error is as follows

Jul 25 17:40:11 master kernel: audit(1122293411.367:0): avc: denied { sys_resource } for pid=3606 exe=/usr/sbin/mysqld capability=24 scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=capability
Jul 25 17:40:15 master pam_timestamp_check: pam_timestamp: `/var/' permissions are lax
Jul 25 17:40:18 master kernel: audit(1122293418.623:0): avc: denied { sys_resource } for pid=3616 exe=/usr/sbin/mysqld capability=24 scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=capability
Jul 25 17:40:20 master pam_timestamp_check: pam_timestamp: `/var/' permissions are lax
Jul 25 17:40:55 master last message repeated 7 times
Jul 25 17:42:00 master last message repeated 13 times
Jul 25 17:43:05 master last message repeated 13 times
Jul 25 17:44:10 master last message repeated 13 times
Jul 25 17:45:15 master last message repeated 13 times
Jul 25 17:46:20 master last message repeated 13 times
Jul 25 17:47:25 master last message repeated 13 times
Jul 25 17:48:30 master last message repeated 13 times
Jul 25 17:49:35 master last message repeated 13 times

I am trying to start the mysql services as follows

# mysqld -u root start &

I am getting the following errror in /var/log/messages

Jul 26 11:47:16 master kernel: audit(1122358636.584:0): avc: denied { write } for pid=3631 exe=/usr/sbin/mysqld name=mysql dev=dm-0 ino=1294481 scontext=root:system_r:mysqld_t tcontext=rootbject_r:var_lib_t tclass=dir

that looks like SELinux there, which is now turned on by default on redhat (assuming you're on rhel4). You;d either want to turn SELinux off, or administer it to allow mysqld access. Couldn't tell you how to do this though.

Can any one help me ASAP.

I am using Linux active 2.6.9-5.EL #1 Wed Jan 5 19:22:18 EST 2005 i686 i686 i386 GNU/Linux
MySQL server version: 4.0.16-standard.

After some time may be after 24 hrs......I checked....

[root@active BACKUP]# mysqladmin processlist | wc
359 5346 31951

Server is becomming very very slow......Why this process are very large in number....how to controll this..

Hi

We are using Enterprise Linux Server with following configuration details......

Linux active 2.6.9-5.EL #1 Wed Jan 5 19:22:18 EST 2005 i686 i686 i386 GNU/Linux

We have installed MySQL server version 4.0.16

When we start our product services we are facisng this problem,
please help immediately as this is BLOCKER for us to move further

" Every mysql connection that is opened in Linux Enterprise Server is creating a new
mysqld process / thread. This was not observed while using the same application with
same mysql version on RH 8.0 "

How to control this, because of this tye system is very slow and not able to continue sometimes hanging
also.

Find the output of from Linux Enterprise server is as follows------- very big output

4 S root 2526 1 0 77 0 - 1238 wait Aug19 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/active.pid
4 S mysql 2555 2526 0 76 0 - 14155 select Aug19 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2559 2555 0 76 0 - 14155 - Aug19 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2560 2559 0 76 0 - 14155 rt_sig Aug19 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2561 2559 0 76 0 - 14155 rt_sig Aug19 ? 00:00:04 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2562 2559 0 75 0 - 14155 rt_sig Aug19 ? 00:06:46 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2563 2559 0 76 0 - 14155 rt_sig Aug19 ? 00:00:15 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2982 2559 0 76 0 - 14155 rt_sig Aug19 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2983 2559 0 76 0 - 14155 select Aug19 ? 00:00:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2984 2559 0 76 0 - 14155 select Aug19 ? 00:01:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 2985 2559 0 76 0 - 14155 rt_sig Aug19 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4837 2559 0 75 0 - 14155 414813 Aug29 ? 00:01:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4838 2559 0 76 0 - 14155 414813 Aug29 ? 00:01:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4839 2559 0 76 0 - 14155 384236 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4840 2559 0 76 0 - 14155 384235 Aug29 ? 00:01:03 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4841 2559 0 76 0 - 14155 333911 Aug29 ? 00:01:04 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4842 2559 0 76 0 - 14155 379960 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4843 2559 0 76 0 - 14155 413584 Aug29 ? 00:01:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4844 2559 0 76 0 - 14155 413584 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4845 2559 0 76 0 - 14155 407636 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4847 2559 0 76 0 - 14155 413745 Aug29 ? 00:01:04 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4848 2559 0 76 0 - 14155 411653 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4850 2559 0 76 0 - 14155 356337 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4851 2559 0 76 0 - 14155 414789 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4852 2559 0 76 0 - 14155 414789 Aug29 ? 00:01:03 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4853 2559 0 76 0 - 14155 360499 Aug29 ? 00:01:15 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4854 2559 0 76 0 - 14155 411792 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4855 2559 0 76 0 - 14155 411792 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4856 2559 0 75 0 - 14155 326934 Aug29 ? 00:01:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4944 2559 0 76 0 - 14155 365472 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4946 2559 0 76 0 - 14155 413937 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4947 2559 0 76 0 - 14155 406936 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4952 2559 0 76 0 - 14155 413951 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4953 2559 0 76 0 - 14155 413951 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4954 2559 0 76 0 - 14155 406935 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4955 2559 0 76 0 - 14155 341263 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4956 2559 0 76 0 - 14155 393973 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4957 2559 0 76 0 - 14155 384236 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4958 2559 0 76 0 - 14155 411653 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4959 2559 0 76 0 - 14155 326935 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4960 2559 0 76 0 - 14155 402776 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4961 2559 0 76 0 - 14155 402776 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4962 2559 0 76 0 - 14155 402776 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4963 2559 0 76 0 - 14155 402776 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 4964 2559 0 76 0 - 14155 328274 Aug29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 21004 2559 0 76 0 - 14155 410563 11:29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
1 S mysql 21005 2559 0 76 0 - 14155 413513 11:29 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/active.pid --skip-locking
0 S root 21279 21235 0 77 0 - 1316 pipe_w 11:49 pts/6 00:00:00 grep mysqld

The same above output from Redhat Linux 8.0 is as follows.........very very less output...........

000 S root 17416 1 0 78 0 - 1003 wait4 12:56 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/
100 S mysql 17439 17416 0 75 0 - 7498 schedu 12:56 ? 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/v
000 S krishna 17509 9994 0 76 0 - 820 pipe_w 12:57 pts/1 00:00:00 grep mysqld