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

Patrick Koch
Patrick Koch
40,498 Points
Posted by Patrick Koch
Patrick Koch
40,498 Points

Cant connect from workbench to Remote Server

I tried to connect to server with the workbench entered Hostname, Username, and Password, (everything checked twice, and its working with FTP.....), by clicking on test connection, prompt tells me that my IP address is not allowed to the MySql-Server. I tried with permission, GRANT ALL ON fooDatabase. * TO fooUser@'1. 2.3.4' IDENTIFIED BY 'my_password'; .... but it didn't worked # 1044 - Access denied for user 'fooUser'@'localhost' to database 'fooUser' thanks, Patrick

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

Yes, I just recently found out that cPanel only allows you to create databases within cPanel. I was going crazy to figure out why Workbench wouldn't allow me to edit a database on my website.

2 Answers

Patrick Koch
Patrick Koch
40,498 Points
Patrick Koch
Patrick Koch
40,498 Points

I just got an answer from my server hosting company they wrote me that it is not possible with my accounts to make external connections to the server. so problem solved

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

So then you always have to create databases using the CPannel? Isn't it possible to do it on MySQL (Xampp) and then connect it to the website? I am sorry if my question is not clear enough. I jam just starting to learn mysql and I dont understand well enough how it works. I just want to know if it is better to use MySQL xampp or workbench or the cpannel that the hostprovider offers WHEN I want to add databases on a website I am making

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

As far as I know, cPanel is the only way to add a database to a host that uses cPanel, but you can create a database with Xampp or MySQL locally, export it to a SQL file, and import it into a database that you already created in cPanel.