When I start BusCoX hosting on a VPS I’ll need to know this.

Tournas Dimitrios

MySQL is a powerful relational database system and probably the most used (especially on shared hosting) . It is also a pre-installed service on all web-development “bundled” local servers like :WAMP , XAMP , MAMP . MySQL’s mysqladmin is a command-line (terminal)  interface for administrators to perform server administration tasks .  It can be used to replace the root user default password with your own , check the server’s configuration and current status , create and drop databases , check if the MySQL database service is running , shutdown the MySQL database service and bring it up running again and more …. Let’s see 15 practical examples .

  • Changing the root password for Mysql :
    mysqladmin -u root -p   ‘newpassword’
  • Checking whether the MySQL server is running
    mysqladmin -u root -p ping
  • Exploring the status of the MySQL server
    mysqladmin -u root -p status
  • what version of MySQL is running
    mysqladmin…

View original post 480 more words

Advertisements

About samehramzylabib

See About on https://samehramzylabib.wordpress.com
This entry was posted in Configure My Systems, Database. Bookmark the permalink.

Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s