Today I had a pointless chat with the online help folks of a hosting company. I wanted to find out why my connection to a MySQL database using MySQL Administrator wasn’t working. As you can see I would’ve been better off just trying to figure it out on my own.
——–
***Waiting for an agent to respond***
*** Chat Session Opened ***
You are chatting with Support_Person.
Support_Person: Hello, Dan . You have successfully connected to your technical services operator. Please wait one moment while I verify and review your information.
Dan: Hello…
Support_Person: Hello, in order to make a backup, please use connection below:
Support_Person: mysqldump -h hostmane -u usermane -ppassword databasename > mZe.sql
Dan: uhhh, what?
Support_Person: It is connection string that creates backup of database
Support_Person: But I suggest you to use special software MyqlYOG
Support_Person: It is easy client that allows you to make backups and restore databases from that backups
Dan: so I can’t use MySQL Administrator?
Support_Person: Generally, you can use any tool, but unfortunately, we do not provide support for third party software, like MySQL Administrator
Dan: well it has always worked in the past and now it says that was an error connecting. so, is there any other way to make a back-up other than a dump?
Support_Person: No. it is the only way
Dan: I’ve tried to use phpmyadmin and then restore the file and it says that there is an error in the file
Support_Person: What is the size of your file?
Dan: about 5 and a half mb
Support_Person: That’s why you’ve got that error, phpmyadmin allows you to upload files less then 2Mb
Support_Person: So I suggest you to use MyqlYOG, it does not have size limitation
Dan: yeah but it costs money for the full version
Dan: ok here is the error I see when I try using MySQL Administrator: Access denied; you need the SHOW DATABASES privilege for this operation
Dan: can you give me those privileges?
Support_Person: No, unfortunately this option is protected on our system due to security reasons
Dan: so basically I cannot make a backup or restore my database…
Dan: this is unaccetpable
Support_Person: You can, but via another tools, it seems your MySQL Administrator tool are not able to make a backup without this option
Dan: but this tool costs money…when in the past the free tool from MySql has always worked
Dan: why now are you forcing me to pay for something that was working in the past?
Support_Person: It seems the size of your backups were less then 2 Mb
Dan: wrong
Dan: I need this to happen today
Dan: can I talk with your manager?
Dan: can we allow the privlege for just a few minutes so I can do a backup?
Support_Person: Unfortunately, it is not possible
Dan: thats not an option
Dan: you’re telling me that something you offered before was possible and now it has changed
Dan: I need this to happen
Support_Person: I apologize, it is a sql command that is protected on our server
Dan: its a simple SHOW DATABASES setting
Dan: can you ask your manager for me?
Support_Person: Unfortunately, it is not simple settings, we are using shared hosting structure, so this command will allow you to have access to all databases of all our clients
Support_Person: Unfortunately, it is not possible
Dan: well then the way you have it set up with usernames isn’t correctly configured
Dan: if you had it setup by usernames…I should be able to see all of my databases
Dan: and not everyone else’s
Support_Person: I apologize, but unfortunately, we can not enable this command for your domain due to security reasons
Dan: unacceptable
Dan: please consider changing your Mysql security structure as it is incorrectly configured
Support_Person: Dan, I apologize, but our structure can not be changed by your request
Dan: please be advised that it is flawed
Support_Person: Ok, Dan, we will take your opinion into our consideration
Dan: thanks
Support_Person: Is there anything else you would like me to help you with today?
Dan: nope…just have a nice day!
——————
The good times are over.
Related Posts:
Posted in: Tech, The Good Times are Over | Comments Off