i am building a small project. And stuck in error "message from server "too many connections"." returned by mysql server when i tried to run my application. But it is connecting fine when I tried to connect fro my client to mysql server using following command :-
and passing an appropriate password. how to get rid of this "error "too many connections".
What that usually means is that you are obtaining a Connection every time you do something with the database - which is OK (when done right). But you are not closing them when you are done with them.
There are only a finite amount of network resources available for Connections, so it is important to close them when you are done with them.
This sort of leakage can also occur if you get a database error and don't close the connection in the database error handling code.
I should mention that simply letting go of Connections and expecting garbage collection to deal with them isn't good enough. For one thing, garbage collection doesn't run often enough. For another, there's no guarantee that the garbage collector will know about the internal resources that have to be closed at the OS level.
"privilege" comes from the Latin words for "private" and "law" (legal) and dates to feudal times. To "claim privilege" meant that you were above the laws that applied to the common people.