List the more useful commands supported by mysqladmin in mysql

List the more useful commands supported by mysqladmin in mysql

Online by JSC0d3
September 2, 2014 | | 4162 recognitions

MySQL — List the more useful commands supported by mysqladmin

Mysqladmin useful commands

Command

  • status (Returns information on server state)
  • password ( Changes a user password )
  • shutdown ( Shuts down the MySQL server )
  • reload ( Reloads the MySQL grant tables )
  • refresh ( Resets all caches and log )
  • variables ( Returns values of all server variables )
  • version ( Returns the server version )
  • processlist ( Returns a list of all processes active on the server )
  • kill ( Kills an active server process )
  • ping ( Tests if the server is alive )

If you don’t like command-line administration, there are two graphical alternatives to the mysqladmin tool: phpMyAdmin, a browser-based interface to MySQL administration, and MySQL Administrator, a visual tool for user administration, database backup and restore, log analysis, and server fine-tuning

JSC0d3's Logo
About JSC0d3

JSC0d3 is an entrepreneur, online marketer, and an employee of an IT company. When not building websites, creating content, or helping customers improve their online business, spend time with their wife and two beautiful children. Although he still feels new in WordPress, he enjoys sharing what he has learned with all of you! If you want to get in touch with him, you can do this through this website.

On the same idea

Posted by | September 2, 2014

The security of the system is further enhanced through the use of a one-way encryption scheme for user passwords
...

Posted by | August 28, 2014

A backup regimen, in particular, is critical to ensuring that the data stored in an organization's databases does not get corrupted or lost in the...

Previous PostBackNext Post

Leave here an impression