mariadb zabbix manjaro arch linux

 

[root@thinclient ~]# mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

Installing MariaDB/MySQL system tables in '/var/lib/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 https://mariadb.com/kb or the

MySQL manual for more instructions.

You can start the MariaDB daemon with:

cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/mysql'

You can test the MariaDB daemon with mysql-test-run.pl

cd '/usr/mysql-test' ; perl mysql-test-run.pl

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

The latest information about MariaDB is available at https://mariadb.org/.

You can find additional information about the MySQL part at:

https://dev.mysql.com

Consider joining MariaDB's strong and vibrant community:

https://mariadb.org/get-involved/

[root@thinclient ~]# systemctl list-unit-files | grep mariadb

mariadb.service                                                           disabled        disabled     

mariadb@.service                                                          disabled        disabled     

[root@thinclient ~]# systemctl enable mariadb.service

Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.

[root@thinclient ~]# systemctl start mariadb.service

[root@thinclient ~]# mysql -u root -p

Enter password: 

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 3

Server version: 10.5.8-MariaDB Arch Linux

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

MariaDB [(none)]> \q

Bye

[root@thinclient ~]# mysql -u root -p -e "create database zabbix character set utf8 collate utf8_bin"

Enter password: 

[root@thinclient ~]# mysql -u root -p -e "grant all on zabbix.* to zabbix@localhost identified by 'test'"

Enter password: 

[root@thinclient ~]# mysql -u zabbix -p -D zabbix < /usr/share/zabbix-server/mysql/schema.sql

Enter password: 

[root@thinclient ~]# mysql -u zabbix -p -D zabbix < /usr/share/zabbix-server/mysql/images.sql

Enter password: 

[root@thinclient ~]# mysql -u zabbix -p -D zabbix < /usr/share/zabbix-server/mysql/data.sql

Enter password: 

[root@thinclient ~]# 

[root@thinclient ~]# systemctl enable zabbix-server-mysql.service

Created symlink /etc/systemd/system/multi-user.target.wants/zabbix-server-mysql.service → /usr/lib/systemd/system/zabbix-server-mysql.service.

[root@thinclient ~]# systemctl start zabbix-server-mysql.service