MySQL for the Internet of Things
Chapter 5 ■ MySQL priMer Begin by choosing either the Windows Installer 32- or 64-bit installation package that matches your Win ...
Chapter 5 ■ MySQL priMer The license shown is the GPLv2 license for the community edition. Once you have read the license^5 and ...
Chapter 5 ■ MySQL priMer The next panel will show all the packages available for installation. If you do not want to install one ...
Chapter 5 ■ MySQL priMer The panel will update with the progress of each installation, as shown in Figure 5-7. Figure 5-6. Prepa ...
Chapter 5 ■ MySQL priMer Different symbols will appear next to each package as the installation proceeds. In some cases, the ins ...
Chapter 5 ■ MySQL priMer The configuration process will be different for each product. For example, to configure MySQL server, t ...
Chapter 5 ■ MySQL priMer The next panel is the accounts and roles panel, as shown in Figure 5-10. This panel allows you to set u ...
Chapter 5 ■ MySQL priMer The next panel allows you to control how MySQL is started on the Windows machine. Figure 5-11 shows the ...
Chapter 5 ■ MySQL priMer If you checked the advanced settings in the first configuration panel, you will see the advanced option ...
Chapter 5 ■ MySQL priMer The next panel shown in Figure 5-13 displays the progress of the configuration. Figure 5-12. Advanced O ...
Chapter 5 ■ MySQL priMer If you chose to start MySQL as a Windows service, you will see a second set of statements listed, as sh ...
Chapter 5 ■ MySQL priMer One of the things I like most about the Windows Installer besides being a one-stop installation mechani ...
Chapter 5 ■ MySQL priMer ■Note i will show you how to install MySQL on the raspberry pi and similar boards in Chapter 6. What IS ...
Chapter 5 ■ MySQL priMer What does this mean to you? It means you have the choice of different mechanisms for storing data. You ...
Chapter 5 ■ MySQL priMer 3. row Engine: CSV Support: YES Comment: CSV storage engine Transactions: NO XA: NO Savepoints: NO 4 ...
Chapter 5 ■ MySQL priMer As of version 5.6, MySQL uses the InnoDB storage engine by default. Previous versions used MyISAM as th ...
Chapter 5 ■ MySQL priMer drwx------ 6 _mysql wheel 204 Oct 17 15:16 bvm -rw-rw---- 1 _mysql wheel 5242880 Feb 6 15:00 ib_logfile ...
Chapter 5 ■ MySQL priMer As you can see, this is a simple way to configure a system. This example sets the TCP port, base direct ...
Chapter 5 ■ MySQL priMer another consideration is connectivity. as with the raspberry pi, if you connect a database to your netw ...
Chapter 5 ■ MySQL priMer Creating Databases and Tables The most basic commands you will need to learn and master are the CREATE ...
«
4
5
6
7
8
9
10
11
12
13
»
Free download pdf