max_connections and max_user_connections

2006-09-30 Thread Jangita @ FSA
hi all in the mysql.user table, what is the difference between max_connections and mac_user_connections? or to put it simply, if i want each user except root to only be able to have only one connection to the server at any one time, which field should i set to 1? -- PO Box 26453 00504

Re: Best MySQL configuation

2006-09-26 Thread Jangita @ FSA
Is it dedicated to mysql only? what operating system does it run? Sayed Hadi Rastgou Haghi wrote: Dear All, What is the best configuration for a server with 2 XEON dual core CPU and 4GB Ram and 200GB RAID 5 hard? -- PO Box 26453 00504 Nairobi, Kenya. TEL: +254722996532 [EMAIL PROTECTED] --

debian installation

2006-09-21 Thread Jangita @ FSA
hello all i installed debian linux netinst which installed well; and proceeded to install mysql with the command below apt-get install mysql-server that also went well, i proceeded to configure etc etc when i logged in from a client i noticed that the mysql server version is 4! is there a

Re: debian installation

2006-09-21 Thread Jangita @ FSA
looking to upgrade mysql, then do the apt-get -t unstable mysql-server. If you are familiar with Debian, I apologize for being so... Beginner. Nick -Original Message- From: Jangita @ FSA [mailto:[EMAIL PROTECTED] Sent: Thursday, September 21, 2006 8:16 AM To: mysql@lists.mysql.com