MariaDB and F5-221

Using Web Server, PHP, MySQL, MariaDB.
Post Reply
User avatar
mordhae
Posts: 1
Joined: 19 May 2022, 05:11

MariaDB and F5-221

Post by mordhae »

I've been trying to login in to MariaDB to no avail, I've already reinstalled MariaDB 3 or 4 times and the problem is always the same same, the login does not work, root/admin, simply does not work and even setting a new password it's always the same problem "Access denied for user 'root'@'localhost' (using password: YES)".
I'm using the latest 4.2.32 firmware, and despite reseting, deleting the database, I just cannnot login on to MariaDB. I've changed the password at least 10 times and it never works, always the same error.

So is there any solution for this?
User avatar
TMSupport
TerraMaster Team
Posts: 2314
Joined: 13 Dec 2019, 15:15

Re: MariaDB and F5-221

Post by TMSupport »

Please contact our tech team to have a check.
To contact our team, please send email to following addresses, remember to replace (at) with @
Technical team: support(at)terra-master.com (for technical support)
Service team: service(at)terra-master.com (for purchasing, return, replacement, RMA service)
User avatar
grunts
Posts: 1
Joined: 20 Feb 2023, 01:17

Re: MariaDB and F5-221

Post by grunts »

TMSupport wrote: 19 May 2022, 16:34 Please contact our tech team to have a check.
No guys! Please answer that question; other users have the very same issue - particularly after upgrading to TOS 5.
User avatar
Toxster
Posts: 19
Joined: 29 Jun 2021, 17:19

Re: MariaDB and F5-221

Post by Toxster »

I solved it on TOS 5.1.24, F5-221 working with Community MariaDB + phpMyAdmin having the same issues:
( @outkastm might be interested)

Code: Select all

service MariaDB stop
cd /usr/local/MariaDB/bin/MariaDB/bin
./mysqld_safe --defaults-extra-file=/usr/local/MariaDB/config/mycfg.ini --skip-grant-tables
-- OPEN NEW TERMINAL

Code: Select all

cd /usr/local/MariaDB/bin/MariaDB/bin
./mysql -u root
-- IN MYSQL

Code: Select all

USE mysql;
SELECT user,host,password from mysql.user;
This showed 4 "invalid" passwords - ::1; localhost; 127.0.0.1;... For each you have to run the following (replacing the localhost with the host you want to update):

Code: Select all

FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password 
USING PASSWORD('my secret password');
FLUSH PRIVILEGES;
To check whether the passwords are set:

Code: Select all

SELECT user,host,password from mysql.user;
If everything is correct:

Code: Select all

EXIT;
now getting back to normal operation, execute in terminal:

Code: Select all

ps -A | grep mysqld
kill xxxxx (enter the process ID of the mysqld instead of the xxxxx)
service MariaDB start
Post Reply