{"id":30,"date":"2013-02-27T17:52:15","date_gmt":"2013-02-27T16:52:15","guid":{"rendered":"http:\/\/blog.rabahi.net\/?page_id=30"},"modified":"2014-08-21T21:51:39","modified_gmt":"2014-08-21T19:51:39","slug":"mysql","status":"publish","type":"page","link":"https:\/\/blog.rabahi.net\/?page_id=30","title":{"rendered":"MariaDB"},"content":{"rendered":"

Installation<\/h1>\n
  1. #!\/bin\/bash<\/span><\/div><\/li>
  2.  <\/div><\/li>
  3. echo<\/span> "install mariadb-server"<\/span><\/div><\/li>
  4. yum<\/span> -y<\/span> install<\/span> mariadb-server phpMyAdmin<\/div><\/li>
  5.  <\/div><\/li>
  6. echo<\/span> "activate mariadb at startup"<\/span><\/div><\/li>
  7. systemctl enable<\/span> mariadb.service<\/div><\/li>
  8.  <\/div><\/li>
  9. echo<\/span> "start the server"<\/span><\/div><\/li>
  10. systemctl start mariadb.service<\/div><\/li>
  11.  <\/div><\/li>
  12. echo<\/span> "set password for root. WARN! for this example we choose unsecure password root"<\/span><\/div><\/li>
  13. \/<\/span>usr\/<\/span>bin\/<\/span>mysqladmin -u<\/span> root password 'root'<\/span><\/div><\/li>
  14.  <\/div><\/li>
  15. echo<\/span> "Note: by default only local users can access to phpMyAdmin."<\/span><\/div><\/li>
  16. echo<\/span> "Let's update the file \/etc\/httpd\/conf.d\/phpMyAdmin.conf and allow everyone."<\/span><\/div><\/li>
  17. sed<\/span> -i<\/span> "s\/\\(Require\\s*ip\\s*127.0.0.1\\)\/Require all granted\\n<\/span>\\1\/i"<\/span> \/<\/span>etc\/<\/span>httpd\/<\/span>conf.d\/<\/span>phpMyAdmin.conf<\/div><\/li>
  18. sed<\/span> -i<\/span> "s\/\\(Require\\s*ip\\\\)\/#\\1\/i"<\/span> \/<\/span>etc\/<\/span>httpd\/<\/span>conf.d\/<\/span>phpMyAdmin.conf<\/div><\/li>
  19.  <\/div><\/li>
  20. #Uncomment these following lines to open firewall<\/span><\/div><\/li>
  21. #echo "add service to firewalld"<\/span><\/div><\/li>
  22. #firewall-cmd --permanent --add-service mysql<\/span><\/div><\/li>
  23. #firewall-cmd --reload<\/span><\/div><\/li>
  24.  <\/div><\/li>
  25. echo<\/span> "Now reload httpd"<\/span><\/div><\/li>
  26. systemctl reload httpd.service<\/div><\/li>
  27.  <\/div><\/li><\/ol><\/pre>\n
    Test<\/h1>\n
    Let’s connect to the database:<\/p>\n
    \r\nmysql -u root -p\r\n<\/pre>\n
    Let’s check if the port 3306 is open:<\/p>\n
    \r\ntelnet localhost 3306\r\n<\/pre>\n
    SOS i am lost!<\/h1>\n
    Have a look at the MariaDB Survival Guide here<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
    Installation Test Let’s connect to the database: mysql -u root -p Let’s check if the port 3306 is open: telnet localhost 3306 SOS i am lost! Have a look at the MariaDB Survival Guide here<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1203,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-30","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/30","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=30"}],"version-history":[{"count":60,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/30\/revisions"}],"predecessor-version":[{"id":1200,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/30\/revisions\/1200"}],"up":[{"embeddable":true,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/1203"}],"wp:attachment":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}