{"id":180,"date":"2012-12-03T13:23:18","date_gmt":"2012-12-03T10:23:18","guid":{"rendered":"http:\/\/www.sahinsolmaz.com\/blog\/?p=180"},"modified":"2013-02-03T00:20:40","modified_gmt":"2013-02-02T21:20:40","slug":"sunucu-mysql-versiyonunu-surumunu-ogrenmek","status":"publish","type":"post","link":"https:\/\/sahinsolmaz.com\/blog\/sunucu-mysql-versiyonunu-surumunu-ogrenmek\/","title":{"rendered":"Sunucu MySQL Versiyonunu – S\u00fcr\u00fcm\u00fcn\u00fc \u00d6\u011frenmek;"},"content":{"rendered":"

Merhabalar,<\/p>\n

Yine basit ama i\u015fe yarayaca\u011f\u0131n\u0131 d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcm bir SQL komutunu sizlerle payla\u015fmak istiyorum.
\nSunucunuzdaki MySQL versiyonunu<\/strong> \u00f6\u011frenmek istedi\u011finizde basit bir SQL komutu ile bu bilgiye eri\u015febilirsiniz. Bu i\u015flemi ger\u00e7ekle\u015ftirmek i\u00e7in;<\/p>\n

* phpMyadmin ‘e giri\u015f yap\u0131n\u0131z ve SQL Sekmesine ge\u00e7i\u015f yap\u0131n\u0131z.<\/p>\n

* SQL sekmesine a\u015fa\u011f\u0131daki SQL komutunu yaz\u0131n\u0131z ve sa\u011f alttaki Git <\/strong>butonuna t\u0131klayarak bu sorguyu \u00e7al\u0131\u015ft\u0131r\u0131n\u0131z.<\/p>\n

SHOW VARIABLES LIKE\u00a0 “%version%”<\/strong><\/p><\/blockquote>\n

A\u015fa\u011f\u0131da \u00f6rnek MySQL versiyon g\u00f6r\u00fcnt\u00fcs\u00fc eklidir.<\/p>\n\n\n\n\n\n\n\n\n
protocol_version<\/td>\n10<\/td>\n<\/tr>\n
version<\/strong><\/td>\n5.0.95<\/strong><\/td>\n<\/tr>\n
version_bdb<\/td>\nSleepycat Software: Berkeley DB 4.1.24: (December …<\/td>\n<\/tr>\n
version_comment<\/td>\nSource distribution<\/td>\n<\/tr>\n
version_compile_machine<\/td>\nx86_64<\/td>\n<\/tr>\n
version_compile_os<\/td>\nredhat-linux-gnu<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n
protocol_version<\/td>\n10<\/td>\n<\/tr>\n
version<\/td>\n5.0.95<\/td>\n<\/tr>\n
version_bdb<\/td>\nSleepycat Software: Berkeley DB 4.1.24: (December …<\/td>\n<\/tr>\n
version_comment<\/td>\nSource distribution<\/td>\n<\/tr>\n
version_compile_machine<\/td>\nx86_64<\/td>\n<\/tr>\n
version_compile_os<\/td>\nredhat-linux-gnu<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Merhabalar, Yine basit ama i\u015fe yarayaca\u011f\u0131n\u0131 d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcm bir SQL komutunu sizlerle payla\u015fmak istiyorum. Sunucunuzdaki MySQL versiyonunu \u00f6\u011frenmek istedi\u011finizde basit bir SQL komutu ile bu bilgiye eri\u015febilirsiniz. Bu i\u015flemi ger\u00e7ekle\u015ftirmek i\u00e7in;<\/p>\n","protected":false},"author":1,"featured_media":257,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[],"tags":[],"class_list":["post-180","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2013\/01\/plesk-10-ssh-root-sifresi-.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4sbm9-2U","jetpack-related-posts":[{"id":331,"url":"https:\/\/sahinsolmaz.com\/blog\/there-seems-to-have-been-a-slight-problem-with-our-database-error-solved-cozumu\/","url_meta":{"origin":180,"position":0},"title":"There seems to have been a slight problem with our database Error Solved \u2013 \u00c7\u00f6z\u00fcm\u00fc","author":"SahinSOLMAZ","date":"11 Mart 2014","format":false,"excerpt":"Category :\u00a0SolusVM,\u00a0Veritaban\u0131 \/ DataBase \u00a0Merhaba Arkada\u015flar, Sunucunuzda\u00a0SolusVM\u00a0kullan\u0131yorsan\u0131z, nadiren de olsa a\u015fa\u011f\u0131daki hata ile kar\u015f\u0131la\u015fabilirsiniz ve bu konu hakk\u0131nda pek fazla kaynak bulamad\u0131\u011f\u0131n\u0131z i\u00e7in de can\u0131n\u0131z epeyce s\u0131k\u0131labilir. Bu durumlarda yap\u0131lmas\u0131 gereken en sa\u011fl\u0131kl\u0131 \u00e7\u00f6z\u00fcm:\u00a0SolusVM\u00a0destek ekibine ba\u015fvuru yapmakt\u0131r. E\u011fer kendiniz ilgilenmek isterseniz a\u015fa\u011f\u0131da \u00e7\u00f6z\u00fcmden bahsedece\u011fim. SolusVM Destek Paneli:\u00a0https:\/\/www.soluslabs.com\/clients\/ Hata: There seems\u2026","rel":"","context":""Genel" i\u00e7inde","block_context":{"text":"Genel","link":"https:\/\/sahinsolmaz.com\/blog\/category\/genel\/"},"img":{"alt_text":"SolusVM","src":"https:\/\/i0.wp.com\/www.sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/01\/SolusVM.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":435,"url":"https:\/\/sahinsolmaz.com\/blog\/ssh-ile-mysql-dosyasini-iceri-aktarmak-importing-mysql-databases-via-ssh\/","url_meta":{"origin":180,"position":1},"title":"SSH ile MySQL Dosyas\u0131n\u0131 \u0130\u00e7eri Aktarmak-Importing MySQL Databases via SSH","author":"SahinSOLMAZ","date":"20 Mart 2014","format":false,"excerpt":"Sunucunuzda y\u00f6netim paneli (cPanel, Plesk panel vb.) kullanm\u0131yor olabilirsiniz dolay\u0131s\u0131 ile phpMyAdmin\u00a0eri\u015fimiz de olmayacakt\u0131r\u00a0ya da y\u00fcklemek istedi\u011finiz .sql\u00a0veritaban\u0131\u00a0dosyan\u0131z\u0131n boyutu b\u00fcy\u00fck oldu\u011fu i\u00e7in time-out, bir tak\u0131m problemler ya\u015fayabilirsiniz bu ve benzeri durumlarda ssh\u00a0\u00fczerinden veritaban\u0131 dosyan\u0131z\u0131 kolayl\u0131kla import edebilirsiniz. Servers without a control panel (such as cPanel, Plesk, or Simple Control Panel)\u2026","rel":"","context":""SSH" i\u00e7inde","block_context":{"text":"SSH","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/ssh\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":826,"url":"https:\/\/sahinsolmaz.com\/blog\/wordpress-site-adres-degisikligi-full-linkurl-sql-update-phpmyadmin\/","url_meta":{"origin":180,"position":2},"title":"WordPress Site Adres De\u011fi\u015fikli\u011fi Full Link\/URL SQL Update PhpMyadmin","author":"SahinSOLMAZ","date":"15 Kas\u0131m 2014","format":false,"excerpt":"Merhabalar, Wordpress sitenizin adres de\u011fi\u015fikli\u011fini yapman\u0131z gerekti\u011fi zaman en pratik yol olarak uygulaman\u0131z gereken en h\u0131zl\u0131 ve i\u015fe yarar ad\u0131mlar: Wordpress Y\u00f6netim paneli -> Genel sayfas\u0131n\u0131 a\u00e7\u0131n, a\u015fa\u011f\u0131daki alanlara yeni site adresini yazarak\u00a0g\u00fcncelleyin, WordPress Adresi (URL) Site Adresi (URL) Daha sonra dosyalar\u0131 ve veritaban\u0131 ilgili hostinge ta\u015f\u0131y\u0131n. E\u011fer bunu manuel\u2026","rel":"","context":""MySQL" i\u00e7inde","block_context":{"text":"MySQL","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/11\/Wordpress_Site-Adres-De%C4%9Fi%C5%9Fikli%C4%9Fi-Full-Link_URL-SQL-Update-PhpMyadmin_2.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/11\/Wordpress_Site-Adres-De%C4%9Fi%C5%9Fikli%C4%9Fi-Full-Link_URL-SQL-Update-PhpMyadmin_2.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/11\/Wordpress_Site-Adres-De%C4%9Fi%C5%9Fikli%C4%9Fi-Full-Link_URL-SQL-Update-PhpMyadmin_2.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":987,"url":"https:\/\/sahinsolmaz.com\/blog\/solved-error-1153-08s01-at-line-4147-got-a-packet-bigger-than-max_allowed_packet-bytes\/","url_meta":{"origin":180,"position":3},"title":"SOLVED – ERROR 1153 (08S01) at line 4147: Got a packet bigger than ‘max_allowed_packet’ bytes","author":"SahinSOLMAZ","date":"15 May\u0131s 2015","format":false,"excerpt":"Bir gece yaras\u0131 mysql veritaban\u0131n\u0131 import etmek istedi\u011finizde: ERROR 1153 (08S01) at line 4147: Got a packet bigger than 'max_allowed_packet' bytes hatas\u0131 ile kar\u015f\u0131la\u015f\u0131rsan\u0131z 1.se\u00e7enekteki d\u00f6rt ad\u0131m\u0131 uygulayarak bu s\u0131k\u0131nt\u0131dan kal\u0131c\u0131 olarak kurtulabilirsiniz veyahut 'max_allowed_packet' bytes hatas\u0131n\u0131 anl\u0131k olarak ge\u00e7mek isterseniz 2. se\u00e7enekteki ssh komutunu uygulayabilirsiniz. Ben MySQL dosyas\u0131n\u0131, SSH\u2026","rel":"","context":""MySQL" i\u00e7inde","block_context":{"text":"MySQL","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":381,"url":"https:\/\/sahinsolmaz.com\/blog\/change-mysql-resetupdate-password-root-ssh-kullanici-ve-sifre-islemleri\/","url_meta":{"origin":180,"position":4},"title":"Change MySQL Reset\/Update Password – Root SSH – Kullan\u0131c\u0131 ve \u015eifre \u0130\u015flemleri","author":"SahinSOLMAZ","date":"25 May\u0131s 2014","format":false,"excerpt":"1. Change root password: su - root passwd 2. Mysql root password: --> ERROR 1045 (28000): Access denied for user 'root'@'localhost' service mysqld stop mysqld_safe --skip-grant-tables & mysql -u root mysql> mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD ('yournewpassword') WHERE User='root'; mysql> FLUSH PRIVILEGES; mysql> quit; service\u2026","rel":"","context":""CentOS" i\u00e7inde","block_context":{"text":"CentOS","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/centos\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":185,"url":"https:\/\/sahinsolmaz.com\/blog\/ssh-ile-sunucu-isletim-sistemi-os-cpu-bilgilerini-ogrenmek\/","url_meta":{"origin":180,"position":5},"title":"SSH ile Sunucu \u0130\u015fletim Sistemi OS & Cpu Bilgilerini \u00d6\u011frenmek","author":"SahinSOLMAZ","date":"3 Aral\u0131k 2012","format":false,"excerpt":"SSH ile Sunucu \u0130\u015fletim Sistemi OS & Cpu, HDD, Ram, Harddisk, \u0130\u015flemci bilgilerini \u00f6\u011frenmek i\u00e7in: How to check server info, CPU, HDD, RAM, Harddisk via SSH? * \u00d6ncelikle SSH ile Sunucumuza ba\u011flan\u0131yoruz, G\u00fcncellenme: 20 Eyl\u00fcl 2015 - 23:30 Update: September 20 2015 - 23:30 \u00a0Cpu markas\u0131n\u0131, modelini, aile grubunu, h\u0131z\u0131n\u0131,\u2026","rel":"","context":""SSH" i\u00e7inde","block_context":{"text":"SSH","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/ssh\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/comments?post=180"}],"version-history":[{"count":0,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/180\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/media\/257"}],"wp:attachment":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/media?parent=180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/categories?post=180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/tags?post=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}