DEV Community

Lyner Lim
Lyner Lim

Posted on

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;
Enter fullscreen mode Exit fullscreen mode

then

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NewPassword');
FLUSH PRIVILEGES;
Enter fullscreen mode Exit fullscreen mode

Top comments (0)