`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , Run the following query in the console CREATE TABLE `firstDB`.`users` ( Let’s create a users table in the newly created Database. The newly created empty database would be visible in the left sidebar. Open the phpMyAdmin by visiting Now select the Databases Tab that’s present in the top left of the headers row. Now open the url You’ll end up with a screen like this: Setting Up MySQL Database Create a new folder here lets say test_android and copy paste the test.php that was created before. if you’re using a MAC then goto Applications->Xampp->htdocs. Note: Knowing PHP is not mandatory for this tutorial. ?> means closing tag like closing bracket in Java.?php starts opening tag for any PHP script.Create a new test.php file and add the following lines into it. Now test phpMyAdmin in the localhost and you’ll end up with a screen similar to this. The servers should be running properly as seen in the image below. Go To the Manage Servers tab in the XAMPP application and click restart all. Seems like the MySQL server isn’t properly running. Also, you can check phpMyAdmin by opening Let’s see what it shows! OOPS! You might end up with a screen like this. You can test your server by opening The following screen should appear. Launch the XAMPP app after installation and you will be greeted with below screen.

XAMPP(or WAMP) is a one-click installer software that creates an environment for developing a PHP, MySQL web application (that we’ll be connecting with our android application). I am working on Mac OS X and XAMPP can be used to set up a local Apache web server and MySQL database quickly. The first step is to create the backend web server. We will use PHP script to connect to the MySQL database. We will develop android login and registration application. In this tutorial, we’ll set up a local web server and MySQL database. You will find registration and login operation in all the apps where we want user information. Android Login and Registration are very common scenarios.

Mysql database android studio tutorial