Skip to main content
Help Center
The GoDaddy Community will undergo maintenance starting on Tuesday, August 3rd at 3pm PST / 6pm EST. Learn more
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
colby
New

Can you access mysql via terminal on Deluxe Linux Hosting packages?

 I would like to access mysql via ssh terminal on a deluxe hosting package. Is this possible or do I need the 'ultimate' package or a vps or dedicated server?

4 REPLIES 4
charminglygeeky
Employee

Hi @colby

This can be achieved with your cPanel hosting account. Check out this article: https://www.godaddy.com/help/importing-mysql-databases-via-ssh-7588

KayJay - GoDaddy | Community Moderator
24/7 support available at x.co/247support

can I create databases this way? When I do the create command I just get 

ERROR 1044 (42000): Access denied for user

No you can't. Databases on shared hosting platforms need to be created from within your godaddy hosting management page

You don't need to use SSH!

If your database is set up to allow remote access then you can use

mysql -h yourdatabasehostname -u yourdatabasename -p yourdatabasename

from the command line on your own pc. You will be prompted for your password.

You can find the details (host, dbname etc) in your database management section on godaddy.

If you are using cpanel on economy hosting then you need to use your cpanel credentials

mysql -h yourdomain -u yourcpanelname -p yourdatabasename

you'll also need to add your IP to to the allowed list using remotesql in cpanel