MariaDB Kurulumu

Teşekkürler böylece mysql'a gönderilen sorgular 1 saniyede iken mariadb de 0.25 saniye gibi kısa süreye düşücektir. Zamanında offlineshop ilk çıktığında bugların oluşma sebebi mysqlın yavaşlığı diye birşey söz konusuydu çoğu kişi mariadb öneriyordu o zamand. Yanlışım varsa düzeltiniz tekrar teşekkürler yararlı bir paylaşım

select sorgusu bu engellerde çalışır. okuma hızındaki artış select sorgusunun da hızlanmasını sağlar ama bu tarz hata çözümlerinde uygun olur mu bilmem. bu konuda mariadb yi çözüm olarak görürsen, başarısız olduğunda mariadb seni mahçup etmiş olur
mariadb için söylenilecek tek şey, artısı çok eksisi yok.

Komut satırlarını aynen yapıştırdım ama navicat bağlantısı sağlamıyor sebebi nedir

Kurulum:

Bu kodu yazıyoruz ve MariaDB 10.4 kurulmuş olacaktır.
pkg install -y mariadb104-server



Başlangıç MariaDB Otomatik Başlaması İçin:
echo 'mysql_enable="YES"' >> /etc/rc.conf

Bu aşamadan sonra eğer elinizde MariaDB kurulu olan bir sunucudan alınmış yedek dosyası var ise bunu yazarak kurabilirsiniz. Sıfırdan kurulum için adımları izlemeye devam edin.
/var/db && tar zxvf mysql_yedek.tgz

Sıfırdan Mariadb Kurulumu
Konsola service mysql-server onestart && mysql yazıyoruz daha sonra ilk girişimiz olduğu için şifre istemeden mysql girecektir. Bu kodu yazarak root adında şifresi 1 olan bir hesap kullanıcı hesabı oluşturmuş olacağız.

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "1";

Yeni güvenlik yamasından sonra artık kullanıcı oluşturulduğunda GRANT(yetki tanımlama) yetkisi olmadan oluşturuluyor. Bu yetkiyi vermek için:
GRANT GRANT OPTION ON *.* TO root@"%";



Diğer Mysql Kurulum Rehberleri:
Bot Dogrulama Bot Dogrulama

Welcome to FreeBSD!

Release Notes, Errata: https://www.FreeBSD.org/releases/
Security Advisories:   https://www.FreeBSD.org/security/
FreeBSD Handbook:      https://www.FreeBSD.org/handbook/
FreeBSD FAQ:           https://www.FreeBSD.org/faq/
Questions List: https://lists.FreeBSD.org/mailman/listinfo/freebsd-questions/
FreeBSD Forums:        https://forums.FreeBSD.org/

Documents installed with the system are in the /usr/local/share/doc/freebsd/
directory, or can be installed later with:  pkg install en-freebsd-doc
For other languages, replace "en" with a language code like de or fr.

Show the version of FreeBSD installed:  freebsd-version ; uname -a
Please include that output and any error messages when posting questions.
Introduction to manual pages:  man man
FreeBSD directory layout:      man hier

Edit /etc/motd to change this login announcement.
root@A:~ # pkg install -y mariadb104-server
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Updating database digests format: 100%
The following 13 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
        boost-libs: 1.72.0_5
        galera26: 26.4.8_1
        icu: 69.1,1
        libedit: 3.1.20210216,1
        libiconv: 1.16
        liblz4: 1.9.3,1
        libxml2: 2.9.12
        mariadb104-client: 10.4.21_1
        mariadb104-server: 10.4.21_1
        rsync: 3.2.3_1
        unixODBC: 2.3.9
        xxhash: 0.8.0
        zstd: 1.5.0

Number of packages to be installed: 13

The process will require 481 MiB more space.
60 MiB to be downloaded.
[1/13] Fetching mariadb104-server-10.4.21_1.txz:  28%    9 MiB   9.6MB/s    00:0                                                                                                   [1/13] Fetching mariadb104-server-10.4.21_1.txz: 100%   32 MiB  33.4MB/s    00:0                                                                                                   1
[2/13] Fetching libxml2-2.9.12.txz: 100%  823 KiB 842.9kB/s    00:01
[3/13] Fetching rsync-3.2.3_1.txz: 100%  354 KiB 362.9kB/s    00:01
[4/13] Fetching xxhash-0.8.0.txz: 100%   73 KiB  74.5kB/s    00:01
[5/13] Fetching libiconv-1.16.txz: 100%  606 KiB 620.7kB/s    00:01
[6/13] Fetching zstd-1.5.0.txz: 100%  580 KiB 593.5kB/s    00:01
[7/13] Fetching liblz4-1.9.3,1.txz: 100%  131 KiB 134.0kB/s    00:01
[8/13] Fetching libedit-3.1.20210216,1.txz: 100%  138 KiB 141.1kB/s    00:01
[9/13] Fetching unixODBC-2.3.9.txz: 100%  464 KiB 474.7kB/s    00:01
[10/13] Fetching mariadb104-client-10.4.21_1.txz:  24%  344 KiB 352.3kB/s    00:                                                                                                   [10/13] Fetching mariadb104-client-10.4.21_1.txz: 100%    1 MiB   1.5MB/s    00:                                                                                                   01
[11/13] Fetching galera26-26.4.8_1.txz: 100%  859 KiB 880.1kB/s    00:01
[12/13] Fetching boost-libs-1.72.0_5.txz: 100%   13 MiB  13.1MB/s    00:01
[13/13] Fetching icu-69.1,1.txz: 100%   10 MiB  10.9MB/s    00:01
Checking integrity... done (0 conflicting)
[1/13] Installing liblz4-1.9.3,1...
[1/13] Extracting liblz4-1.9.3,1: 100%
[2/13] Installing icu-69.1,1...
[2/13] Extracting icu-69.1,1: 100%
[3/13] Installing xxhash-0.8.0...
[3/13] Extracting xxhash-0.8.0: 100%
[4/13] Installing libiconv-1.16...
[4/13] Extracting libiconv-1.16: 100%
[5/13] Installing zstd-1.5.0...
[5/13] Extracting zstd-1.5.0: 100%
[6/13] Installing libedit-3.1.20210216,1...
[6/13] Extracting libedit-3.1.20210216,1: 100%
[7/13] Installing boost-libs-1.72.0_5...
[7/13] Extracting boost-libs-1.72.0_5: 100%
[8/13] Installing libxml2-2.9.12...
[8/13] Extracting libxml2-2.9.12: 100%
[9/13] Installing rsync-3.2.3_1...
[9/13] Extracting rsync-3.2.3_1: 100%
[10/13] Installing unixODBC-2.3.9...
[10/13] Extracting unixODBC-2.3.9: 100%
[11/13] Installing mariadb104-client-10.4.21_1...
[11/13] Extracting mariadb104-client-10.4.21_1: 100%
[12/13] Installing galera26-26.4.8_1...
[12/13] Extracting galera26-26.4.8_1: 100%
[13/13] Installing mariadb104-server-10.4.21_1...
===> Creating groups.
Creating group 'mysql' with gid '88'.
===> Creating users
Creating user 'mysql' with uid '88'.
===> Creating homedir(s)
[13/13] Extracting mariadb104-server-10.4.21_1: 100%
=====
Message from boost-libs-1.72.0_5:

--
You have built the Boost library with thread support.

Don't forget to add -pthread to your linker options when
linking your code.
=====
Message from mariadb104-client-10.4.21_1:

--
MariaDB respects hier(7) and doesn't check /etc and /etc/mysql for
my.cnf. Please move existing my.cnf files from those paths to
/usr/local/etc/mysql or /usr/local/etc. Sample
configuration files are provided in /usr/local/etc/mysql
and /usr/local/etc/mysql/conf.d.

This port does NOT include the mytop perl script, this is included in
the MariaDB tarball but the most recent version can be found in the
databases/mytop port
=====
Message from galera26-26.4.8_1:

--
Find the Galera Cluster documentation at
http://galeracluster.com/documentation-webpages/
=====
Message from mariadb104-server-10.4.21_1:

--
MariaDB respects hier(7) and doesn't check /etc and /etc/mysql for
my.cnf. Please move existing my.cnf files from those paths to
/usr/local/etc/mysql or /usr/local/etc. Sample
configuration files are provided in /usr/local/etc/mysql
and /usr/local/etc/mysql/conf.d.

This port does NOT include the mytop perl script, this is included in
the MariaDB tarball but the most recent version can be found in the
databases/mytop port
root@A:~ # echo 'mysql_enable="YES"' >> /etc/rc.conf
root@A:~ # service mysql-server onestart && mysql
Installing MariaDB/MySQL system tables in '/var/db/mysql' ...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system


Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is mysql@localhost, it has no password either, but
you need to be the system 'mysql' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

You can start the MariaDB daemon with:
cd '/usr/local' ; /usr/local/bin/mysqld_safe --datadir='/var/db/mysql'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/local/mysql-test' ; perl mysql-test-run.pl

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

Starting mysql.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run                                                                                                   /mysql/mysql.sock' (2)
root@A:~ # GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "145350";
GRANT: No match.
root@A:~ # GRANT GRANT OPTION ON *.* TO root@"%" IDENTIFIED BY "145350";
GRANT: No match.
root@A:~ # ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/va                                                                                             r/run      /mysql/mysql.sock' (2)
root@A:~ #