Roundcube MySQL Notes
Config:
/var/lib/roundcube/config/db.inc.php
Test the SQL roundcube login id if id is roundcube:
$ mysql -u roundcube -p
SQL Status:
$ /etc/init.d/mysql status
SQL Version:
$ mysql --version
Get list of users to confirm the roundcube login is available:
$ mysql -u root -p
MariaDB> SELECT User, Host, Password FROM mysql.user;
<a printout will follow similar to below>
root -- localhost
rcube -- localhost -- *ASDFSDAFASDFSADF
Change User Password:
MYSQL> ALTER USER 'rcube'@'localhost' IDENTIFIED BY 'enternewpasswordhere';
or
MariaDB> SET PASSWORD FOR 'rcube'@'localhost' = PASSWORD('enternewpasswordhere');
or
MariaDB> UPDATE mysql.user SET authentication_string = PASSWORD('enternewpasswordhere') WHERE User='rcube' AND Host='localhost';
MariaDB> FLUSH PRIVILEGES;
MariaDB> quit;
previous page
|