I thought I could just type mysql after I SSHed into the librenms appliance, but that doesn’t work. How can I log into mysql?
edit- Trying this now, " 1. At the command prompt, run the following command to launch the mysql shell and enter it as the root user: /usr/bin/mysql -u root -p."
Here is what I see after logging in and running the commands
[email protected]:~$ /usr/bin/mysql -u librenms -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 13831
Server version: 10.1.34-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]> ALTER TABLE sensors_to_state_indexes DROP INDEX sensors_to_state_indexes_ibfk_1;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> ALTER TABLE sensors_to_state_indexes ADD INDEX state_index_id (state_index_id);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>