colingchong
asked on
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
[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
ASKER
Thanks, I have contacted my hosting provider to see if they will allow this
ASKER
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.c
The MySQL Host is sql5c11b.megasqlservers.co
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.c
The MySQL Host is sql5c11b.megasqlservers.co
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
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
ASKER
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
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock
Sorry, did not see you had a different MySQL host.
Try this:
mysql -u USERNAME -pPASSWORD -h sql5c11b.megasqlservers.co
again, replace all caps with your data.
HTH,
Dan
Try this:
mysql -u USERNAME -pPASSWORD -h sql5c11b.megasqlservers.co
again, replace all caps with your data.
HTH,
Dan
ASKER
Getting a Error
ERROR 1045: Access denied for user
ERROR 1045: Access denied for user
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Thanks for your help Dan, I am awarding you the points for the attention
Lord Bless
Colin Chong
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.