Installing MariaDB on Stretch
I installed like this:
Code: Select all
$ sudo apt-get install mariadb-server $ sudo mysql -u me -p Enter password: ERROR 1698 (28000): Access denied for user 'me'@'localhost' $ sudo mysql -u root -p Enter password: ====> should I now assume that it will be running with root privileges? <=== Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 6 Server version: 10.1.37-MariaDB-0+deb9u1 Raspbian 9.0 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Several web references said that during the install I would be prompted for the password for the MariaDB root user. That did not happen.
Is there a good tutorial (MariaDB for Dummies) on how to get started? ie. create the database on an external device? how do I get access without using root? What about other users and program access? Etc....RDK.