Page 1 of 1
MariaDB and F5-221
Posted: 19 May 2022, 05:19
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?
Re: MariaDB and F5-221
Posted: 19 May 2022, 16:34
by TMSupport
Please contact our tech team to have a check.
Re: MariaDB and F5-221
Posted: 20 Feb 2023, 01:18
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.
Re: MariaDB and F5-221
Posted: 12 May 2023, 00:01
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:
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