Installing MySQL database

In this lesson we will cover the installation of wamp server on an windows PC, which will install a MySQL database engine as well, and we will focus on the MySQL database.

In order to download the wamp server go to http://www.wampserver.com/, click the download button as shown in the figure 1.


Figure 1: Download wamp server

In the download session click the appropriate version for your machine. On the window that pops up click the link marked with number one in order to download the Visual Studio 2012 VC 11 vcredist_x64/86.exe file if you don't have it and than after installing that file click the link marked with number two shown in the figure 2 to download the wamp server.


Figure 2: Wamp server download steps

After download process has finished install the wamp server normally like every other program and give permission to pass traffic through firewall.

After completing the installation of wamp server run it and wait for the wamp icon in the taskbar to become green as shown in the figure 3.


Figure 3: Wamp server running correctly

After the icon has turned green, click on it and the menu shown in the figure 4 will apear.


Figure 4: Wamp server menu

In the menu shown in the figure 4 click on phpMyAdmin element highlighted in the picture and you will se the login page as shown in the figure 5.


Figure 5: Login phpMyAdmin

The default username to login on phpMyAdmin is root and you can leave the password blank as it is. After clicking the GO button, you will get loged into the phpMyAdmin, as seen in the figure 6, where can create, delete databases, manage tables etc. actions which we will see in the upcoming lessons.


Figure 6: phpMyAdmin

(please report broken link in the comment)

Comments

Post a Comment

Popular posts from this blog

Free host and domain

Image
In order to be able to have a website online are needed a server which is used to host the website and a domain which is linked with the IP of the server where is hosted the website. In order to get a host and a domain the programmers must pay, but at 000webhost.com can be taken free subdomain and host. At 000webhost.com after sign up must be confirmed the email address entered during sign up. Figure 1 shows an example of filling the information during the sign up that we'll use in this lesson. Figure 1: Sign up at 000webhost.com The information that are used in figure 1 must be replaced as required. First is the email, after email is the password field and the third input field is the field where is entered the name of the website and bellow is updated the domain of the website which will be created. After the creation of the account the email address must be confirmed. After confirming the email address, the created website is displayed as seen in figure 2 bellow. Fig
Read more

C++ Beginner: Lesson 3 - Simple calculator

Image
After we got familiar with Qt Creator environment in the lesson 2 we will build a simple calculator in order to get familiar with some data types which come with Qt Creator framework like QString and other C++ primitive data types. First of all we need to create a new project as shown in the lesson 1 . During the creation, instead of mainwindow class we have used calculator class. After creating the project, in design view of qt creator we create the layout of our application. Initially we get a LineEdit element from the toolbox panel as shown in the figure 1. Figure 1: Add LineEdit on window After we add the line edit on window we fix the size according to our needs, in this case we fill the window horizontally by leaving some margin right and left. After we add the LineEdit element on window we need to add the buttons for the numbers and operations as well as shown in the figure 2. Figure 2: Add PushButton on window After we add the buttons as shown in the figure above we
Read more

C++ Beginner: Lesson 4 - Tic Tac Toe game

Image
In this lesson we will cover if condition which we saw in the previous lesson as well, and we will cover the switch control statement too. Other elements that we will cover in this lesson are one and two dimensional arrays and we will see the for loop as well. During this lesson we will develop the tic tac toe game. In order to do so, we need to create a new project as we have seen in lesson 1 , but in this case we will call the application TicTacToe and the class will be named TicTacToe as well as shown in the figure 1. Figure 1: TicTacToe game The first step to create the TicTacToe application is to prepare the layout of the window. From the toolbox panel we take the Grid Layout element and drag it into window and than select the window and press the Lay Out in a Grid button as shown in the figure 2. Figure 2: Grid layout After the setup of the layout we start dragging and dropping into the window 9 QPushButton elements as shown in the figure 3 bellow. Figure 3: Add butt
Read more