Navicat will not backup MySQL database on Telus Server

Hello, I have a Joomla website located on Telus's Shared Hosting and when I try to back up the MySQL database with Navicat I receive this message.

[Err] [Dtf] 1227 - Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation

My question is what should I be asking of Telus technical support to allow me to do this and is it something that they would be unwilling to grant me?

I can backup using the supplied phpMyAdmin in the control panel but I would prefer to be able to use Navicat.

Many Thanks for any insight

Colin Chong
colingchongAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan CraciunIT ConsultantCommented:
phpMyAdmin usually uses "internal" (localhost, 127.0.0.1) connection to MySQL databases.
To be able to access directly your database from the internet your host would have to open a port in the firewall to allow those connections, which will provide security risks.

You can provide them with static IP's from where those connections will be allowed, but depending on your host they might refuse.
0
colingchongAuthor Commented:
Thanks, I have contacted my hosting provider to see if they will allow this
0
colingchongAuthor Commented:
In Navicat I am accessing through SSH so I do have secure access to the database. When I look at the permissions that I have through the MySQL Manager control panel I only have Create Drop and Use.

How would I connect to the MySQL database and go about granting the necessary permissions through a PuTTY SSH connection?

The SSH Host is shell1c11.megawebservers.com
The MySQL Host is sql5c11b.megasqlservers.com
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Dan CraciunIT ConsultantCommented:
If you have SSH access, connect using putty, and then in the console use:

mysql -u USERNAME -pPASSWORD DATABASENAME

(change all caps to actual parameters).

the prompt should change to mysql>

Then you can run MySQL commands and change user rights.

for ex:
mysql> grant SELECT, INSERT, UPDATE, DELETE ON `DATABASENAME`.* TO 'USERNAME'@'%';
mysql> FLUSH PRIVILEGES;

HTH,
Dan
0
colingchongAuthor Commented:
Looks like I am locked out of connecting this way using the command throws this error

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
0
Dan CraciunIT ConsultantCommented:
Sorry, did not see you had a different MySQL host.
Try this:
mysql -u USERNAME -pPASSWORD -h sql5c11b.megasqlservers.com DATABASENAME

again, replace all caps with your data.

HTH,
Dan
0
colingchongAuthor Commented:
Getting a Error

ERROR 1045: Access denied for user
0
Dan CraciunIT ConsultantCommented:
Then contact your host, send them the command you're using to try to connect and ask them to give you permissions.

HTH,
Dan
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
colingchongAuthor Commented:
I am in the process of doing this, every provider seems to be different in what they will allow and this seems to be one of the more restrictive.

Thanks for your help Dan, I am awarding you the points for the attention

Lord Bless

Colin Chong
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.