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

Dwight Scull
Dwight Scull
3,283 Points
Posted by Dwight Scull
Dwight Scull
3,283 Points

Creating any other accounts (admin or user1, etc) doesn't import the existing database on localhost

In the video Andrew uses an external ip address and then asks us to follow along. If I am using the localhost host to setup my admin or user 1 connections in MYSQL Workbench none of the schemas automatically come over to the new connection and because we are limiting permissions to SELECT only it isn't possible to repopulate those databases.

Am I supposed to reset the connection to use root - import the database again and then reset the connection to use the limited account?

Lonnie Parker
Lonnie Parker
5,964 Points
Lonnie Parker
Lonnie Parker
5,964 Points

I found this solution from on the forums, hope it helps: https://teamtreehouse.com/forum/creating-new-users

1 Answer

Andrew Goninon
Andrew Goninon
14,925 Points
Andrew Goninon
Andrew Goninon
14,925 Points

Thanks Lonnie!