In this section you'll learn how to set up MySQL.
First, you will have to download MySQL for Windows. Go to the link below:
https://dev.mysql.com/downloads/installer/
Click the “Download” button for the second listing. On the new page, click the “No thanks, just start my download.” link.
Open the downloaded file and follow the installation process as showed below.
After installation you will be asked to configure the products. First we will configure MySQL Server. Follow the installation process as showed below.
Please remember the password you have inserted in step number 4.
Now we will configure MySQL Router. Follow the installation process as showed below.
Now we will configure Samples and Examples. Follow the installation process as showed below.
On step 2 insert the password you have specified when configuring MySQL Server.
Now we will finish the installation. MySQL Workbench will start automatically. Now click on the “Local instance MySQL80” box. Type your password (the one you have specified while configuring your MySQL Server) and click the “OK” button.
Click on the “rectangle” icon at the top to resize the window.
Now we will create a new database. In order to do it, click the “add database” icon located at the top. In the name field type the name of the database. Click the “Apply” button. A new window should pop up.
On this new window click the “Apply” button. Click the “Finish” button. Inside an “Output” window you should see a message that the action was executed successfully.
Now let’s go back to the bluNFC. Insert correct database information and click the “Test the connection” button. You should see a green “Valid” text appearing near the button. Now click on the “Save” button.
For a database name insert the name you have set up during the process of setting up a database in MySQL Workbench.
For a password insert the password you have specified when configuring MySQL Server.
For other information insert:
Host: localhost
Port: 3306
Username: root
Use these login details:
Login: admin
Password: adminpass123
In order to change your email or password (as a user you can only change password), first close the “What do You want to do?” window. Now go to the top menu, select “Settings” and “Change account details”.
A new window should pop up. On this window insert your login information and click the “Authorization” button. Now insert your new email and/or password and click the “Save” button. You should receive a message that the account details were saved.
It is important to set an email for your account as it is required to have an ability to register new users.
-
If you would like to register a new user as an admin (or create an account as a user), first go to “Settings” and “Logout” at the top menu. A new window should pop up.
-
On this new window click the “Register” link. Now fill up the information. Click the “Register” button. You should receive a message that the account was created successfully.
-
Now you should receive an email with account information and validation code (or an admin will receive it if you are a user).
As an admin you should send an email to your user with the validation code. As a user you should expect such a validation code from the admin to finish the registration.
You have 2 weeks to complete the registration process. After this time your account will be permanently deleted and you will have to create a new one.
If you forgot the password, click the “Forgot your account details?” link on the login window. A new window should pop up.
On this new window insert your email and click the “Confirm” button.
You should receive a message to check your mailbox. Check your email and look for email with title “bluNFC Reset password”. Inside you should see your reset key. Copy it.
Now click the “I received the key” link and paste your code.
Click the “Confirm” button.
You will be able to change your email and password (or just password if you are the user). Set the new password and click the “Save” button. You should receive a message that the account details were saved.
You have 24 hours to reset the password. After that your code will expire.