Knowledgebase: Hosting FAQ > General
Accessing MySQL from shell (SSH)
Posted by - NA -, Last modified by Jen Ferraz on 11 April 2011 12:48 PM

This requires an SSH-enabled hosting account.  Contact Support to modify your account to include this if necessary.  phpMyAdmin access is already available to all accounts.

 



To access MySQL from your shell access, run the following command, substituting username for your MySQL user:

mysql -u username -p -h 127.0.0.1

To load a file into MySQL, such as a table dump, use the following:

mysql -u username -p -h 127.0.0.1 < file.sql

(414 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Help Desk Software by Kayako support.miva.com/supportsuite/index.php?