Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Securing and Maintaining a MySQL Database Setting up Multiple Users

Vittorio Somaschini
Vittorio Somaschini
33,371 Points
Posted by Vittorio Somaschini
Vittorio Somaschini
33,371 Points

Playing with databases, doing it with a remote database

I am trying to do it as Andrew did in the video:

I have an host with mysql databases and a user that I can use and I am now able to connect to the database as for example I can see the list of my remote databases in the schemas section of mysql Workbench.

I now only need to replicate the threehouse_movies_db on to my remote database but here comes the troubles.

When trying to run the script provided (the same I used when "playing" locally) I get the 1044 error Access denied for user '******@IPADDRESS' to database treehouse_movies_db.

user name ( I do not want to disclose) is fine and IPADDRESS is ok as I also have it authorized through my provider's cpanel. I also gave this user FULL priviledges.

Why does it say that access is denied?

It is the first time I am using a database like this (remotely). Do I need to do some extra things? Like for example via ftp..

I have thought about it and presumed I do not, but I am still a bit unsure.

Ty for your help

Vittorio

3 Answers

Petros Sordinas
Petros Sordinas
16,181 Points
Petros Sordinas
Petros Sordinas
16,181 Points

Hi Vittorio,

You mentioned that you have defined the user in your provider's cpanel. If you are on a sharing hosting plan, I don't think that you can create databases remotely. You'll have to ask your provider to verify this.

Have you tried creating the database via your cpanel (and authorizing the user for it)? Once created, you could delete the CREATE DATABASE (OR CREATE SCHEMA) line and then I think the script should run.

Vittorio Somaschini
Vittorio Somaschini
33,371 Points
Vittorio Somaschini
Vittorio Somaschini
33,371 Points

Hello Petros.

Yes I have done all that you suggest, including creating the database and then running the script that includes the database deletion.

Cpanel has a whole section dedicated to remote mysql so I think that has to work. I will contact my host anyway just to make sure.

ty

David Richied
David Richied
18,057 Points
David Richied
David Richied
18,057 Points

Same thing happened to me. I found a website here http://www.inmotionhosting.com/support/website/database-troubleshooting/mysql-1044-access-denied-error-message that said cPanel only allows users to create databases within cPanel. They cannot create them outside via Workbench.

Elena Paraschiv
Elena Paraschiv
9,938 Points
Elena Paraschiv
Elena Paraschiv
9,938 Points

I followed the steps exacly as in the post, adding the IPadress, username and password from the email I got from the host provider and then in Port I added 3306. But I get the error that 'The aythenthication plugin '. Imgur I dont know how to go about it. I thinking it might be something I have to fix in the Cpannel from the hostprovider. What do you guys think?