DEV Community

Lyner Lim

Posted on Mar 4

MariaDB - can log in via the command line but not through app like TablePlus

#mariadb

For MariaDB older than 10.4

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NewPassword');
FLUSH PRIVILEGES;

then

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NewPassword');
FLUSH PRIVILEGES;

Subscribe

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.