How to setup Database for CakePHP 4 Application?

Hi guys, In the last article we have seen the strategy for CakePHP application development, till now in the series of articles we have seen the different aspects of CakePHP application development, Its installation, basic configuration, setting up database server, MVC design pattern, the strength of ORM and RDF (Rapid Development Framework) Bake console Utility, which is a plug-in of CakePHP. 

If you have not seen previous articles visit the home page of Deep Space. 

As discussed in the last article the best approach of starting the application in CakePHP is Database First. So we need database, before we start developing application. For the purpose of learning, I have downloaded a classic database from MySQL Tutorial. You can download the sample database form this website. The downloaded file will be in a zip file format. 

Now open the phpMyAdmin application in your web browser using (localhost/phpmyadmin) address. Once the phpMyAdmin interface opened, click on the import button and chose your downloaded database zip file. This zip file contains the MySQL script. After executing the script you can verify by clicking on the database name in the left pan. 

Important: If you want to change the name of your database, open the script file and change the database name in script file. In my case I have changed it to “myshop”. 

After clicking on the table name under the database, you can see the table has seeded data as well for application development. 

The last step is to create a database user, who will connect the database from the application and grant the privileges to user for secure database access. If you have no idea about this check my article How to Interact with MySQL?

OK, we have setup our sample database for application development today, in the next article we will move to application side and see how to connect to this database and more. Stay tuned with us and like, share, follow and subscribe whatever option you have to be updated with our new articles.