This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE meudb; | |
SHOW DATABASES; | |
USE meudb; | |
CREATE TABLE simples (id INT AUTO_INCREMENT PRIMARY KEY, texto VARCHAR(200)); | |
INSERT INTO simples VALUES (NULL, 'Primeiro teste'); | |
SELECT * from simples; | |
INSERT INTO simples VALUES (NULL, 'Segundo teste'); | |
SELECT * from simples; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<link rel="import" href="../core-scaffold/core-scaffold.html"> | |
<link rel="import" href="../core-header-panel/core-header-panel.html"> | |
<link rel="import" href="../core-menu/core-menu.html"> | |
<link rel="import" href="../core-item/core-item.html"> | |
<link rel="import" href="../core-icon-button/core-icon-button.html"> | |
<link rel="import" href="../core-toolbar/core-toolbar.html"> | |
<link rel="import" href="../core-field/core-field.html"> | |
<link rel="import" href="../core-icon/core-icon.html"> | |
<link rel="import" href="../core-input/core-input.html"> | |
<link rel="import" href="../core-icons/core-icons.html"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[root@ol7-mysql56 packages]# yum -y localinstall MySQL-server-advanced* | |
Examinando MySQL-server-advanced-5.6.21-1.el7.x86_64.rpm: MySQL-server-advanced-5.6.21-1.el7.x86_64 | |
Marcando MySQL-server-advanced-5.6.21-1.el7.x86_64.rpm para ser instalado | |
Resolvendo dependências | |
--> Executando verificação da transação | |
---> O pacote MySQL-server-advanced.x86_64 0:5.6.21-1.el7 será instalado | |
--> Processando dependência: libaio.so.1(LIBAIO_0.1)(64bit) para o pacote: MySQL-server-advanced-5.6.21-1.el7.x86_64 | |
--> Processando dependência: libaio.so.1(LIBAIO_0.4)(64bit) para o pacote: MySQL-server-advanced-5.6.21-1.el7.x86_64 | |
--> Processando dependência: libaio.so.1()(64bit) para o pacote: MySQL-server-advanced-5.6.21-1.el7.x86_64 | |
--> Executando verificação da transação |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[root@ol7-mysql56 packages]# yum -y localinstall MySQL-client-advanced* | |
Examinando MySQL-client-advanced-5.6.21-1.el7.x86_64.rpm: MySQL-client-advanced-5.6.21-1.el7.x86_64 | |
Marcando MySQL-client-advanced-5.6.21-1.el7.x86_64.rpm para ser instalado | |
Resolvendo dependências | |
--> Executando verificação da transação | |
---> O pacote MySQL-client-advanced.x86_64 0:5.6.21-1.el7 será instalado | |
--> Resolução de dependências finalizada | |
Dependências resolvidas |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
## Criando 2 diretorios de dados para 2 instancias de teste | |
mysqld --no-defaults --user=mysql --initialize-insecure \ | |
--explicit_defaults_for_timestamp --datadir=/tmp/mysqldata1 \ | |
--log-error=/tmp/mysqldata1/mysqld1.log | |
mysqld --no-defaults --user=mysql --initialize-insecure \ | |
--explicit_defaults_for_timestamp --datadir=/tmp/mysqldata2 \ | |
--log-error=/tmp/mysqldata2/mysqld2.log | |
## Inicializando uma instancia mysql na porta 13001: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
#Bash script to install MySQL Utilities via RPM in Enterprise Linux 7.x | |
#Copy the MySQL Utilities and Connector Python RPMs into the $PACKAGES_DIR and run this script as root | |
#You can find the community binaries in http://dev.mysql.com/downloads and | |
#commercial binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com | |
#Modify these variables as you wish | |
PACKAGES_DIR=/home/vagrant/packages #This folder already contains RPMs |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
#Bash script to install MySQL Enterprise Backup 4.x via RPM in Enterprise Linux 7.x | |
#Copy the MEB RPM (meb-4*.rpm) into the $PACKAGES_DIR and run this script as root | |
#You can find the binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com | |
#Modify these variables as you wish | |
PACKAGES_DIR=/home/vagrant/packages | |
#Next lines install MySQL Enterprise Backup |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
#Bash script to install MySQL Enterprise Monitor Agent 3.x in Enterprise Linux 7.x | |
#Copy the MEM Agent executable binary (mysqlmonitoragent*.bin) into the $PACKAGES_DIR and run this script as root | |
#You can find the binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com | |
#Modify these variables as you wish | |
DIR_TO_INSTALL=/home/vagrant/mysql/enterprise/agent #/opt/mysql/enterprise/agent | |
PACKAGES_DIR=/home/vagrant/packages #This folder already contains the Executable Binaries | |
MEM_SERVICE_HOST=vmmysqltools |
OlderNewer