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

General Discussion

Posted by Joseph Hall
Joseph Hall
10,865 Points

How do I use MySQL workbench, and database functionality in a php website.

Hi! I have been following along with Andrew's videos and they are great! Will connecting to a MySQL database using PHP be covered in these videos? If not, how do I connect using the MySQL workbench instead of something like PHP MyAmin?

Thanks, Joseph

3 Answers

Andrew Chalkley
STAFF
Andrew Chalkley
Treehouse Guest Teacher
Andrew Chalkley
Andrew Chalkley
Treehouse Guest Teacher

Hi Joseph,

I'm glad you're liking it so far.

Many web hosts have PHPMyAdmin pre-installed and you can run the SQL statements in a similar way as you would in the WorkBench – they are both clients and fullfil the same job in the client-server model.

We're not talking specifically about any other programming language other than SQL in the current planned syllabus Database Foundations Syllabus but Foundations courses can be expanded to include new stages in the future.

I do know Randy, our PHP teacher, in an upcoming PHP stage, will talk about connecting to a MySQL database in PHP. Stay around with me to learn the SQL syntax and then apply that knowledge in that stage when he walks you through connecting to a MySQL Server.

If you're trying to connect to a remote server we'll talk about that later on. (But if you can't wait that long take a look in the Server Administration and add a new instance. You'll need to look at your web host's documentation or welcome email on getting credentials and settings to populate the configuration screens).

Regards, Andrew

Joseph Hall
Joseph Hall
10,865 Points
Joseph Hall
Joseph Hall
10,865 Points

Ok Thanks Andrew!

James Barnett
James Barnett
39,199 Points
James Barnett
James Barnett
39,199 Points

Here's a useful article on connecting to a remote MySQL database with MySQL Workbench