Install MariaDB on Ubuntu 18.04 – Database Management System, the New MySQL

MySQL/MariaDB is probably the most popular multi-user database in the world. Since Ubuntu 18.04, you should install mariadb-* packages to use this database.

Posted in Uncategorized | Tagged , , , , , , , | Comments Off on Install MariaDB on Ubuntu 18.04 – Database Management System, the New MySQL

Aikataulu – Linux palvelimet ict4tn021-3003 – to 8-14 – alkusyksy 2018p1 – 5 op

English: Learn to manage your own Linux server – in 8 weeks. Beginners welcome. Student feedback excellent 4.8 out of 5. Course is in Finnish. Aloita nollasta. Opiskele 8 viikkoa ja hallitset omaa Linux-palvelinta. Opintojakson suoritettuaan opiskelija: Osaa hallita Linuxia … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , , | 41 Comments

Configuration Management Course is Finished

My students have created many interesting projects on configuration management course. The feedback was excellent, 4.6 out of 5. The most common feedback (mode) was 5 out of 5. Thank you! Jussi Isosompppi controlled 2071 slave computers with Salt.

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Comments Off on Configuration Management Course is Finished

MySQL Automatic Install with Salt – Preseed Database Root Password

MySQL is probably the most popular multi-user database in the world*. It’s part of the most popular web development stack, LAMP (Linux Apache MySQL PHP). This article shows a Salt state to automatically install MySQL on Ubuntu. As the package … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | Comments Off on MySQL Automatic Install with Salt – Preseed Database Root Password

Aikataulu – Linux palvelimet ict4tn021 8-ma, 7-ti ja 6-to – alkukevät 2018 – 5 op

English: Learn to manage your own Linux server – in 8 weeks. Beginners welcome. Student feedback excellent 4.7 out of 5. Course is in Finnish. Aloita nollasta. Opiskele 8 viikkoa ja hallitset omaa Linux-palvelinta. Opintojakson suoritettuaan opiskelija: Osaa hallita Linuxia … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | 197 Comments

Initial Testing and Tries on MySQL Socket Authentication

MySQL has some initial support for passwordless socket authentication, but based on by very brief and initial testing, it does not seem to be ready for prime time yet. If you want socket authentication, PostgreSQL does socket authentication out of … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | Comments Off on Initial Testing and Tries on MySQL Socket Authentication

Aikataulu – Linux palvelimet ict4tn021 4-ti ja 5-to – alkusyksy 2017 – 5 op

English: Learn to manage your own Linux server – in 8 weeks. Beginners welcome. Course is in Finnish. Both groups have completed their final lab tests. Congratulations to those who finished this demanding course. Final lab test for group 4-Tuesday. … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , , , , , , , , , | 108 Comments

Aikataulu – Palvelinten hallinta ict4tn022-2 – 5 op, uusi OPS – loppukevät 2017 p2

Hallitse palvelimiasi Pupetilla. Pupettia käyttävät esimerkiksi Google, Mozilla ja Wikipedia. Sillä on toteutettu myös US Government Security Baseline hallinnon Linux ja Windows -tietokoneisiin.

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | 99 Comments

Two Common MySQL Tricks: LAST_INSERT_ID() and Trash

Create a new database item, then open it for editing: LAST_INSERT_ID(). Undo is better than “are you sure”. Mark items deleted, then empty trash when sure. Read the basics first: MySQL Install and One Table Database – SQL CRUD tutorial … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Comments Off on Two Common MySQL Tricks: LAST_INSERT_ID() and Trash

MySQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

MySQL is the most popular multi-user database. In this tutorial, you’ll learn to Install MySQL Server and Client on Ubuntu Automate MySQL login Create, read, update and delete data (CRUD)

Posted in Uncategorized | Tagged , , , , , , , , , | Comments Off on MySQL Install and One Table Database – SQL CRUD tutorial for Ubuntu