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?
MariaDB and F5-221
Re: MariaDB and F5-221
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)
Technical team: support(at)terra-master.com (for technical support)
Service team: service(at)terra-master.com (for purchasing, return, replacement, RMA service)
Re: MariaDB and F5-221
I solved it on TOS 5.1.24, F5-221 working with Community MariaDB + phpMyAdmin having the same issues:
( @outkastm might be interested)
-- OPEN NEW TERMINAL
-- IN MYSQL
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):
To check whether the passwords are set:
If everything is correct:
now getting back to normal operation, execute in terminal:
( @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
Code: Select all
cd /usr/local/MariaDB/bin/MariaDB/bin
./mysql -u root
Code: Select all
USE mysql;
SELECT user,host,password from mysql.user;
Code: Select all
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password
USING PASSWORD('my secret password');
FLUSH PRIVILEGES;
Code: Select all
SELECT user,host,password from mysql.user;
Code: Select all
EXIT;
Code: Select all
ps -A | grep mysqld
kill xxxxx (enter the process ID of the mysqld instead of the xxxxx)
service MariaDB start