i'm a newbie in MySQL. i want to know if i want to update MYSQL, can i check that is it have any user at that time, provide me the solution. if i get there is the user how i block the traffic and wait for the user finish their transaction theni close down the server? provide me the solution on it. thank you...

regards,
albert

SHOW PROCESSLIST;

then

KILL ???

??? being the id value for the process

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.