Instalação MySQL em Ambiente Oracle Enterprise Linux(OEL)
Posted by Emerson on 20:54 with 16 comments
Olá pessoal!
Iremos agora instalar o MySQL no linux a partir dos pacotes RPM.Nessa VM optei pelo OEL pois já faz parte do mesmo pacote de software da Oracle.
1 - Instalar o Oracle Enterprise Linux
Não irei entrar em detalhes nesse tópico.Mais informações no site da oracle abaixo.
https://edelivery.oracle.com/
2- Baixar os fontes do MySQL no endereço abaixo:
ftp://mysql.cce.usp.br/mysql/Downloads/MySQL-5.6/
3 - Descompactar os fontes e copiar para /usr/local/mysql
[root@oralinux u01]# tar -xvf MySQL-5.6.2_m5-1.linux2.6.i386.tar
MySQL-client-5.6.2_m5-1.linux2.6.i386.rpm
MySQL-devel-5.6.2_m5-1.linux2.6.i386.rpm
MySQL-embedded-5.6.2_m5-1.linux2.6.i386.rpm
MySQL-server-5.6.2_m5-1.linux2.6.i386.rpm
MySQL-shared-5.6.2_m5-1.linux2.6.i386.rpm
MySQL-test-5.6.2_m5-1.linux2.6.i386.rpm
[root@oralinux u01]#
4 - Instalar os pacotes
[root@oralinux u01]# rpm -i MySQL-devel-5.6.2_m5-1.linux2.6.i386.rpm
[root@oralinux u01]# rpm -i MySQL-client-5.6.2_m5-1.linux2.6.i386.rpm
[root@oralinux u01]# rpm -i MySQL-shared-5.6.2_m5-1.linux2.6.i386.rpm
[root@oralinux u01]# rpm -i MySQL-server-5.6.2_m5-1.linux2.6.i386.rpm
[root@oralinux u01]# rpm -i MySQL-embedded-5.6.2_m5-1.linux2.6.i386.rpm
[root@oralinux u01]# rpm -i MySQL-test-5.6.2_m5-1.linux2.6.i386.rpm
[root@oralinux u01]# rpm -i MySQL-server-5.6.2_m5-1.linux2.6.i386.rpm
[root@oralinux u01]# rpm -i MySQL-server-5.6.2_m5-1.linux2.6.i386.rpm
110908 14:44:04 [Note] Binlog end
110908 14:44:04 [Note] Shutting down plugin 'partition'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_METRICS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_CMPMEM'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_CMP_RESET'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_CMP'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_LOCKS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_TRX'
110908 14:44:04 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
110908 14:44:04 [Note] Shutting down plugin 'ARCHIVE'
110908 14:44:04 [Note] Shutting down plugin 'BLACKHOLE'
110908 14:44:04 [Note] Shutting down plugin 'MyISAM'
110908 14:44:04 [Note] Shutting down plugin 'MRG_MYISAM'
110908 14:44:04 [Note] Shutting down plugin 'MEMORY'
110908 14:44:04 [Note] Shutting down plugin 'CSV'
110908 14:44:04 [Note] Shutting down plugin 'mysql_old_password'
110908 14:44:04 [Note] Shutting down plugin 'mysql_native_password'
110908 14:44:04 [Note] Shutting down plugin 'binlog'
110908 14:44:04 [Note] Binlog end
110908 14:44:04 [Note] Shutting down plugin 'partition'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_METRICS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_CMPMEM'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_CMP_RESET'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_CMP'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_LOCKS'
110908 14:44:04 [Note] Shutting down plugin 'INNODB_TRX'
110908 14:44:04 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
110908 14:44:04 [Note] Shutting down plugin 'ARCHIVE'
110908 14:44:04 [Note] Shutting down plugin 'BLACKHOLE'
110908 14:44:04 [Note] Shutting down plugin 'MyISAM'
110908 14:44:04 [Note] Shutting down plugin 'MRG_MYISAM'
110908 14:44:04 [Note] Shutting down plugin 'MEMORY'
110908 14:44:04 [Note] Shutting down plugin 'CSV'
110908 14:44:04 [Note] Shutting down plugin 'mysql_old_password'
110908 14:44:04 [Note] Shutting down plugin 'mysql_native_password'
110908 14:44:04 [Note] Shutting down plugin 'binlog'
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h oralinux password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
5 - Inicializar o MySQL
[root@oralinux u01]# /etc/init.d/mysql start
Starting MySQL. [ OK ]
As opções do server em linha de comando são
{start|stop|restart|reload|force-reload|status}
6 - Acessando o MySQL
[root@oralinux u01]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.2-m5 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show database;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql>
Pronto!Espero que goste, próximo post iremos falar sobre o MySQL Enterprise Backup.
Até lá..
Categories: MySQL
Boa Emerson!
ResponderExcluirEsta mandando bem, Oracle, Postgresql, e agora Mysql.
Parabéns pelo artigo!
Att,
Sakamoto
MyTraceLog - Registro de um DBA
http://mytracelog.blogspot.com
Valeu Sakamoto..
ResponderExcluirEstamos no mesmo barco..hehehe
Att,
Emerson
Emerson,
ResponderExcluirlegal, apesar de ser 'simples' muita gente ainda tem dificuldades, parabéns!
abraços
capin
É verdade Capin.
ResponderExcluirObrigado..!!!
Vendo seu poste deu saudades do Mysql ... qto tempo ... : )
ResponderExcluirParabéns Emerson
Valeu Flávio por visitar meu blog.
ResponderExcluirMy brothеr гecommended I might like
ResponderExcluirthiѕ website. He waѕ entiгеly right.
This post truly madе my day. You can not imagine simρly
how much time I hаd spent fοг thіs іnformation!
Thanκs!
my homepage - sfgate.com
Үοu neеd to take paгt in a contеst for оne of thе highest quality blogѕ οn the net.
ResponderExcluirI am going to reсommenԁ this web site!
Look at my webpage - V2 Cigs Review
This design is spеctaculaг! You certaіnly know how
ResponderExcluirto keeρ а геadeг еnteгtained.
Between your wit аnd your νideоs, I waѕ almost mоvеd
to start my own blog (wеll, almost...HaHа!
) Great job. I reallу lоved ωhat you haԁ to say, anԁ more
than that, how you presenteԁ it. Tοo сoοl!
Here is my blog post :: Kinds Of V2 Cigs Coupon Discount Codes Available
Veгy goоԁ info. Lucky me I fоund your websitе by acсidеnt (stumbleupon).
ResponderExcluirI haѵе boοκ-mагkeԁ it foг
later!
my blog: www.sfgate.com
Thanks for the gooԁ writeup. It if truth be told was once a entertainment account it.
ResponderExcluirGlance complex to mогe added agreeable frоm уou!
Hоwever, hoω can we keeρ in touch?
Αlѕo viѕit mу ωeb blοg :
: v2 cigs Review
Nо longeг workіng? You absolutelу must
ResponderExcluircreаte a freе асcount first
one which just аpρly virtuallу аny discount
codeѕ. Not neсessarily creatе уour accounts *whіlе*
you are looking іntο. Τhat won't work.
My homepage :: green smoke promo code
The state of the art flex belt, attempt it you will not regret it.
ResponderExcluirMy homepage Www.cauchunho.vn
Thanks brothers.
ResponderExcluirΙ alωays used to study article in neωs ρapers but now as I am a
ResponderExcluiruser of internet thus from now I am usіng net for artiсleѕ or rеνiеws, thankѕ to ωeb.
Feеl freе to surf to my ωeb-site ... just click the following internet page
I wаs wondering if уou ever thought of changing the layout
ResponderExcluirof your blog? Its very well ωrіtten; I love whаt yοuve got to say.
But maybe you cοuld a little more in the way of cоntent so peoρle сould connect
with іt better. Youvе got an
aωful lot of text for only hаving onе or 2 pictures.
Maybe you could spacе it out better?
my sіte; loverespectloyalty.com