On Fri, 29 Jun 2018 11:36:26 -0500 Richard Owlett <rowl...@cloud85.net> wrote:
> I have not used a relational database since dBASEII was current. > About a year ago I attempted to install MariaDB but didn't find a > tutorial which was a close enough match to my system. > > I use Debian 9 with MATE. > > I found: > https://www.tecmint.com/install-mariadb-in-debian/ > https://www.linode.com/docs/databases/mariadb/mariadb-setup-debian/ > > Using the official Debian repository: > apt-get install software-properties-common > apt-get install mariadb-server mariadb-client > > There seemed to be no problems. > > *BUT* both references auto-magically go to a GUI setup screen. > > It was suggested in another forum that I (as root) do: > dpkg-reconfigure debconf > dpkg-reconfigure mariadb-server > > The first appeared to run. > The second did nothing. No warnings. No error messages. Just returned > to prompt. > > Ideas. > TIA > > > > > > > > _______________________________________________ > PLUG mailing list > PLUG@pdxlinux.org > http://lists.pdxlinux.org/mailman/listinfo/plug When installing MariaDB SQL server on Debian you actually have to run a setup script to get a production ready system you can actually connect to and start using. After installing mariadb-server from APT you need to run a script as root called mysql_secure_installation. It should ask you some basic questions like what should the root login be, delete test database, and deny anonymous remote logins. after you do that just run the client, mysql and starting sending your SQL commands. If you need a good resource on SQL commands W3schools has a really good desk reference at https://www.w3schools.com/sql/ . If you plan on using this beyond just playing around with it be sure to setup an actual login for you SQL server. Running as root is typically a bad practice. _______________________________________________ PLUG mailing list PLUG@pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug
