[MySQL] modifying the root password and viewing the number of connections

Change Password:

 
Mysqladmin-u root-P password New Password
 

After entering this command, enter the original root password. 

 

 

View current connections:

View threads_connected Parameters

Mysql> show status like '% conn % ';

 

Or

Show processlist

 

 

In show statusConnections = 193687
It is not the current number of online connections.The total number of connections, including closed connections, since the server was started.
 

Modify the maximum number of connections:

Configuration has been added to my. CNF.

Max_connections = 1000