How to Connect an iOS App to a MySQL Database (Step by Step) - Part 1

In this video series, I'll show you how to connect an iPhone app to MySQL. We'll go through it step by step starting from the beginning.

You'll learn how to:
- Sign up for web hosting
- Create a new MySQL database
- Set up a MySQL database user
- Set access permission for that user
- Create a PHP web service to access the data
- Create an iOS app with a tableview, multiple screens and a map
- Access the PHP web service via the app to download the data from your MySQL database.

Get a customized roadmap for your app and start building it in 7 days:

_________________
FREE RESOURCES (download links)

This is a video version of the tutorial here:


_________________
FUNDAMENTALS COURSE


_________________
CONNECT WITH ME

For more tutorials on how to build iPhone apps, make sure you join and visit my site where you'll find a community of like minded learners! Learning something new is always more fun with other people!

_________________
FOLLOW ME

Twitter ► @CodeWithChris
Instagram ► @CodeWithChris

_________________
ABOUT ME

Hi I’m Chris! I’m dedicated to teaching fundamentals about how to make an app. This is important if you’re trying to land an iOS job, be a freelancer, increase or start a business with an app idea. On the site, you'll find a ton of free resources and tutorials to aid you on your journey to learn iOS development. Many people have successfully picked up Swift 4, Xcode 9 and app building from my course and materials!

Here's just a sample of the success stories my students have sent in:

Intro & Outro music

[aliakkawi]

Hello sir, thanks for the interesting tutorials, are you gonna also cover how to transfer data from app to MySql, delete and update data? Thanks a lot.

[paulchristopher]

Do you have any plans on updating this to be compliant with Swift 5? Your tutorial is the best I've seen with how to do this

[GaboDev]

just what i need...Thanks a lot for this tutorials Chris !

[trippthree]

Thanks for this! Would love to see an update when you have time. 😁

[azertyupz]

Thank you! Ive been looking for a tutorial like this for 2 weeks and here comes ur video!

[TylerWasick]

Hi Chris! Thanks for the great tutorials! Do you have any videos going over connecting SwiftUI apps to cloud databases?

[mohamadkhanafer]

Great video ! Is there a way to write data to the database ? As in take data from the app, upload it onto the database so that we could eventually see the data on the wordpress site ?

[azizas]

Thank you for the video,
I was wondering if you can share the tech stack you used for your blog?

[JoseFigueroa-zgsg]

Hi Chris, your work is definitely professionally excellent. Did you ever do a video about how to use swift 4 with an SSH port forwarding to a MySQL db?

[siliconinfo]

Really Excellent Post. Ive been looking for a tutorial like this. Very easy to understand. Thanks for this video very helpful.

[DanielDuhon]

Why would you not use a MySQL database? It’s one of the most robust ones for data-driven applications.

[rgl]

an other reason why MySQL is preferred: when writing internal apps in a corporate environment, there are restrictions where you can store the data. In these cases if you start storing corporate data on an external database (such as Firebase) you will most likely get "lectured" by the IT department.

[danielwatson]

Would love a SwiftUI version of this, with Wordpress database would be 🔥🔥

[GulamALI-niot]

Hello sir .. I have read this series tutorial on your website I want to ask that how can we update data in MySql using swift..

[enriqueatala]

Hello, thanks for the tutorial, I have run it with Xcode 10.0 and it gives me errors when opening it, for which version of Xcode, Swift and Mac OS X is this design?

[payares]

Hello. Is this tutorial about LOCAL databases? I need to create the database in the iphone, not in a remote server. Thank you!!

[tomjansen]

Interesting! Do you think MySql is the cheapest option as well?

[didierp-a]

Hi Chris,

I am quite confused and stuck so I am trying to get it sorted.

I want to develop an IOS App and I want to choose the best Database. I heard about Firebase, MySQL (that I know), CoreData, Realm.

I want to do the following in my App:

1. Different types of users can connect to the app via email only. Roles: Admin, Author, Reader.

2. Admin can see everything, can create / modify / delete users.

3. Author cannot create users so the users link on the menu will be hide. and the screen to add users will be also hide. They will be only able to add new feeds in the home screen.

4. Reader connect to the App and see only the feeds create by Author so no access to create new feed in the menu and not able to create users. Only 2 screens to access Login and View the feeds.

In terms of performance and management which DB will be the best to setup and be good in terms of performance?

If you have any comments / feedback please let me know.

Have a nice day.

[latlov]

You say at the beginning you recommend to use other databases for mobile development, instead of mysql. But then what do you recommend if we want to develop an application both for web and mobile? Just imagine like facebook, yahoo mail, google mail, etc. You can access those services both in desktop (web browser) or download a mobile app in iOS and Android.

[ottocodes]

Hello! I want to make an ios app that reads barcodes can I connect the ean database in the same way? 🙂