Arch Linux

julapas

Member

Registered: 2019-01-28

Posts: 5

SOLVED Mariadb: mysql_secure_installation

Hi everyone, I'm new as mysql user so I follow arch's wiki installation. After make mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql to be able to start mysqld service, I put mysql_secure_installation but It returns the following error: FATAL ERROR: Could not find /usr/bin/mysql. I've checked /usr/bin/ but mysql is not, there is a lot of mysql files, including mysqld but not just mysql and I don't know how to fix it. Some help please, thanks for reading.

Last edited by julapas (2019-01-29 10:27:48)

WorMzy

Administrator

From: Scotland

Registered: 2010-06-16

Posts: 13,699

Website

Re: SOLVED Mariadb: mysql_secure_installation

Please post the output of

pacman -Qs mariadb
pacman -Qkk mariadb-clients

---

Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

julapas

Member

Registered: 2019-01-28

Posts: 5

Re: SOLVED Mariadb: mysql_secure_installation

Hi, thanks for reply the output of pacman -Qs mariadb is:
local/mariadb 10.3.12-5
    Fast SQL database server, derived from MySQL
local/mariadb-clients 10.3.12-5
    MariaDB client tools
local/mariadb-libs 10.3.12-5
    MariaDB libraries

and pacman -Qkk mariadb-clients:

warning: mariadb-clients: /usr/bin/mysql (No such file or directory)
warning: mariadb-clients: /usr/bin/mysql_plugin (No such file or directory)
warning: mariadb-clients: /usr/bin/mysql_upgrade (No such file or directory)
warning: mariadb-clients: /usr/bin/mysqladmin (No such file or directory)
warning: mariadb-clients: /usr/bin/mysqlbinlog (No such file or directory)
warning: mariadb-clients: /usr/bin/mysqlcheck (No such file or directory)
warning: mariadb-clients: /usr/bin/mysqldump (No such file or directory)
warning: mariadb-clients: /usr/bin/mysqlimport (No such file or directory)
warning: mariadb-clients: /usr/bin/mysqlshow (No such file or directory)
warning: mariadb-clients: /usr/bin/mysqlslap (No such file or directory)
warning: mariadb-clients: /usr/bin/mysqltest (No such file or directory)
mariadb-clients: 27 total files, 11 altered files

Seems that i had no installed mariadb-clients don't know why.
Thank you very much WorMzy.

WorMzy

Administrator

From: Scotland

Registered: 2010-06-16

Posts: 13,699

Website

Re: SOLVED Mariadb: mysql_secure_installation

You did have it installed (it's a dependency of mariadb), it was just missing half its files. Any idea how that happened? If not, checking the health of your hard drive and (if safe to do so) running a filesystem check should be a priority for you.

---

Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

julapas

Member

Registered: 2019-01-28

Posts: 5

Re: SOLVED Mariadb: mysql_secure_installation

Could be that I erased some files trying to fix and previous error, I just reinstalled mariadb-client and got everything I deleted. Thanks.