Page 1 of 1

Few questions about MySql server login

Posted: Wed Nov 21, 2007 4:28 pm
by tanvirtonu
I [s]m[/s] am a newbie in MySql. I want to know some basic questions about MySql server login

1. Can several user log in to MySql server using the same account(same user name and password).

2. Does MySql create a different thread/connection for different user logging

3. If each user log in to MySql server using the same account (e.g- user=root), will each one be treated differently with different COnnection.

4. What is new Instance connection? Is a new instance of connection created for each user logging.

5. I made a java application where several users can connect to MySql server using the same account(user=root) and modify the database. Now when each user is using the database, DO I HAVE TO CARE ABOUT DATABASE LOCKING ISSUES? or MySql database do it for me? IF not so, how to do it?

[s]PLS[/s] please HELP ME KNOW THESE ANSWERS.
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:11. Please use proper, complete spelling when posting in the forums. AOL Speak, leet speak and other abbreviated wording can confuse those that are trying to help you (or those that you are trying to help). Please keep in mind that there are many people from many countries that use our forums to read, post and learn. They do not always speak English as well as some of us, nor do they know these aberrant abbreviations. Therefore, use as few abbreviations as possible, especially when using such simple words.

Some examples of what not to do are ne1, any1 (anyone); u (you); ur (your or you're); 2 (to too); prolly (probably); afaik (as far as I know); etc.

Posted: Wed Nov 21, 2007 4:44 pm
by feyd
I'm pretty sure most of the answers you seek are in the MySQL manual.