Running 'AWebServer Http Apache PHP Sql' ( MySql server )

Learning Objectives:

• Setup and running an MySQL (MariaDb Sql Server) local server using 'AWebServer Http Apache PHP Sql'.
• Setup and running a 'HiSQL' MySql client app. Then connect to MySQL server. Open MySQL server connection.
• Prepare an Android Smartphone from version 6.

<< Previous lesson Running 'AWebServer Http Apache PHP Sql' ( PHP web server )

Setup And Running An MySQL (MariaDb Sql Server) Local Server 

1. You must start the 'Apache' web server as explained in the previous lesson on the link above.
2. In the third tab (MariaDb Sql Server). Click 'Start' button on the 'Service' row.
   
   
   
3. After your 'MariaDb SQL Server' started. 
   

Setup And Running A 'HiSQL' MySql Client App

1. Open the HiSQL app.
   
   
   
2. Create a 'MySQL' connection.
   
   
   
3. Input 'Server Host/IP' and 'Port' based on 'Address' on step 3. Input 'Username' and 'Password' based on step 3. 
   
   
   
4. To Connect a 'MySQL' connection. Click the 3 dots and select 'Connect' menu item.
   
   
   
5. To Open a 'MySQL' connection. Click the connection IP on the connection row if needed. In this example, our IP is 192.168.0.2 on the connection row. 
   

   
   
6. After connection opened. 

   

   
   

   

next lesson  Create Database MySQL In Android SmartPhone >