redhat/oracle linux 5 mysql yüklemek

1.
[root@oel5 ~]# wget --no-check-certificate https://repo.mysql.com//mysql57-community-release-el5-7.noarch.rpm
--2017-02-21 11:16:52--  https://repo.mysql.com//mysql57-community-release-el5-7.noarch.rpm
Resolving repo.mysql.com... 104.122.197.77
Connecting to repo.mysql.com|104.122.197.77|:443... connected.
WARNING: certificate common name `cdn.mysql.com' doesn't match requested host name `repo.mysql.com'.
HTTP request sent, awaiting response... 200 OK
Length: 8392 (8,2K) [application/x-redhat-package-manager]
Saving to: `mysql57-community-release-el5-7.noarch.rpm'

100%[==============================================================================================================================================>] 8.392       --.-K/s   in 0s     

2017-02-21 11:16:52 (965 MB/s) - `mysql57-community-release-el5-7.noarch.rpm' saved [8392/8392]

[root@oel5 ~]#

[root@oel5 ~]# rpm -ivh  mysql57-community-release-el5-7.noarch.rpm
warning: mysql57-community-release-el5-7.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:mysql57-community-relea########################################### [100%]
[root@oel5 ~]#

 yum update
[root@oel5 ~]# yum install mysql mysql-server
Loaded plugins: rhnplugin, security
This system is not registered with ULN.
You can use up2date --register to register.
ULN support will be disabled.
Setting up Install Process
Package mysql-server is obsoleted by mysql-community-server, trying to install mysql-community-server-5.7.17-1.el5.x86_64 instead
Resolving Dependencies
--> Running transaction check
---> Package mysql.i686 0:5.7.17-1.el5 set to be updated
--> Processing Dependency: mysql-community-libs-compat >= 5.7.9 for package: mysql
--> Processing Dependency: mysql-community-libs >= 5.7.9 for package: mysql
--> Processing Dependency: mysql-community-client >= 5.7.9 for package: mysql
---> Package mysql.x86_64 0:5.7.17-1.el5 set to be updated
---> Package mysql-community-server.x86_64 0:5.7.17-1.el5 set to be updated
--> Processing Dependency: mysql-community-common = 5.7.17-1.el5 for package: mysql-community-server
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.17-1.el5 set to be updated
---> Package mysql-community-common.x86_64 0:5.7.17-1.el5 set to be updated
---> Package mysql-community-libs.x86_64 0:5.7.17-1.el5 set to be updated
---> Package mysql-community-libs-compat.x86_64 0:5.7.17-1.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================================
 Package                                                Arch                              Version                                    Repository                                    Size
========================================================================================================================================================================================
Installing:
 mysql                                                  i686                              5.7.17-1.el5                               mysql57-community                             40 k
 mysql                                                  x86_64                            5.7.17-1.el5                               mysql57-community                             40 k
 mysql-community-server                                 x86_64                            5.7.17-1.el5                               mysql57-community                            227 M
Installing for dependencies:
 mysql-community-client                                 x86_64                            5.7.17-1.el5                               mysql57-community                             31 M
 mysql-community-common                                 x86_64                            5.7.17-1.el5                               mysql57-community                            813 k
 mysql-community-libs                                   x86_64                            5.7.17-1.el5                               mysql57-community                            2.8 M
 mysql-community-libs-compat                            x86_64                            5.7.17-1.el5                               mysql57-community                            2.1 M

Transaction Summary
========================================================================================================================================================================================
Install       7 Package(s)
Upgrade       0 Package(s)

Total download size: 264 M
Is this ok [y/N]: y


[root@oel5 ~]# /etc/init.d/mysqld
[root@oel5 ~]# service mysqld status
mysqld is stopped
[root@oel5 ~]# service mysqld start
Initializing MySQL database:                               [  OK  ]
Installing validate password plugin:                       [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@oel5 ~]# service mysqld status
mysqld (pid  20536) is running...
[root@oel5 ~]#





2.

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17-1.el5.x86_64.rpm-bundle.tar



[root@oel5 ~]# ls
anaconda-ks.cfg  Desktop  install.log  install.log.syslog  mysql-5.7.17-1.el5.x86_64.rpm-bundle.tar
[root@oel5 ~]# tar xvf mysql-5.7.17-1.el5.x86_64.rpm-bundle.tar
mysql-community-devel-5.7.17-1.el5.x86_64.rpm
mysql-community-client-5.7.17-1.el5.x86_64.rpm
mysql-community-server-5.7.17-1.el5.x86_64.rpm
mysql-community-libs-compat-5.7.17-1.el5.x86_64.rpm
mysql-5.7.17-1.el5.x86_64.rpm
mysql-community-libs-5.7.17-1.el5.x86_64.rpm
mysql-community-common-5.7.17-1.el5.x86_64.rpm
mysql-community-embedded-devel-5.7.17-1.el5.x86_64.rpm
mysql-community-test-5.7.17-1.el5.x86_64.rpm
mysql-community-embedded-5.7.17-1.el5.x86_64.rpm
[root@oel5 ~]#


[root@oel5 ~]# rpm -ivh  mysql-5.7.17-1.el5.x86_64.rpm mysql-community-libs-* mysql-community-common* mysql-community-client* mysql-community-server-5.7.17-1.el5.x86_64.rpm
warning: mysql-5.7.17-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:mysql-community-libs   ########################################### [ 17%]
   2:mysql-community-client ########################################### [ 33%]
   3:mysql-community-common ########################################### [ 50%]
   4:mysql-community-libs-co########################################### [ 67%]
   5:mysql                  ########################################### [ 83%]
   6:mysql-community-server ########################################### [100%]
[root@oel5 ~]#


[root@oel5 ~]# /etc/init.d/mysqld
[root@oel5 ~]# service mysqld status
mysqld is stopped
[root@oel5 ~]# service mysqld start
Initializing MySQL database:                               [  OK  ]
Installing validate password plugin:                       [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@oel5 ~]# service mysqld status
mysqld (pid  20536) is running...
[root@oel5 ~]#
[root@oel5 ~]# grep "A temporary password is generated for root@localhost:" /var/log/mysqld.log
2017-02-21T08:07:25.723596Z 1 [Note] A temporary password is generated for root@localhost: NRLRJWgnB5/F
[root@oel5 ~]# mysql -pNRLRJWgnB5/F
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.17

Copyright (c) 2000, 2016, 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>

joomla admin parolasını resetleme

Bir gün joomlanın admin parolasını resetlemeye ihtiyaç duyarsanız, database erişiminiz varsa, aşağıdaki gibi değiştirebilirsiniz.

mysql> update joomla_users set password=MD5('admin') where username='admin';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Bu işlemden sonra joomlanın admin parolası joomla olacaktır.
Eh artık böyle bırakmazsınız her halde.:P

Reklam

Bu gün genç arkadaşlarımızın yapmış olduğu bir uygulamayı sizlerle paylaşmak istiyorum.

https://indirkazan.net/

Yolu buradan geçen arkadaşlara denemelerini tavsiye ederim.

Uygulama hakkındaki olumlu ve/veya olumsuz görüşlerinizi direk uygulamayı geliştiren arkadaşlarla paylaşabilirsiniz.  Uygulamayı geliştiren arkadaşlar, fikirlerinize  çok önem vereceklerdir.

MySql deyip geçmeyin!

Bu yılın sonunda en yoğun kullanığım mysql sunucusunu kontrol ettiğimde gördüğüm durumu paylaşmak istedim.

Üç ay içinde toplam 1.561.731.908.514  isteğe çevap vermiş. Bu kadar rakamı nasıl okuması bile zor geliyor.

Unutmayın, bu clusterdaki üç sunucudan bir tanesi :D

linux sistemlerde uzaktan grafiksel ara birim kullanımı - x2go

Linux sistemleri kullanırken ihtiyaç duyguduğumuz temel araçlardan  birisi uzaktan grafiksel arabirimdir. vnc, remmina, nomachine, oracle remote desktop(vdi) gibi bir çok araçları kullandım. En sonunda x2go yu kullanmaya başladım.

Şu anda x2go yu x2gomatebindings eklentisiyle mate yi kullanıyorum. Oldukça başarılı bir çözüm.

Grafiksel arabirime ihtiyaç duyan veya kullanan herkese x2go yu denemelerini tavsiye ederim.


http://wiki.x2go.org/doku.php/doc:newtox2go

x2go ile iyi eğlenceler dilerim.

Bir zamanlar hayal bile değildi!

Hardisklere yazma/okuma işlemi daima sıkıntılı bir işlem ve oldukca sınırlı bir hıza sahipti.
Son bir kaç yıldaki değişikliklerden sonra saniyede 10GByte üzerinde veri yazılabilen disk sistemleri çıkmış durumdu. Her halde bir kaç yıl sonunda, hardisk erişim/yazma/okuma sorunları tamamen çözülmüş olur.

kernel güncellemelerinde infiniband sorunları

Sistem güncellemesi sonucu kullandığınız ib modülleri, yeni kernelle sorun çıkartıyorsa,
kernel ve ib paketlerini güncelleme dışı bırakmak en güzeli. Bunun için /etc/yum.conf içine aşağıdaki satırları eklememiz yeterlir.

#exclude=kernel*  ibutils*  libmthca* libmlx4* rdma* libibverbs*

exclude=kernel* ofed-scripts* libibverbs* libibverbs-utils* libibumad* libibmad* libibcm* librdmacm* librdmacm-utils* libmthca* libipathverbs* libibumad-compat* ibacm* ibpd* libibscif* opensm-libs* mstflint* ofed-docs* perftest* qperf* ibutils* infiniband-diags* infinipath* tmi* libmlx4* rdma* libcxgb4* libnes* srptools* libcxgb3*