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 , , , , , , , | Leave a comment

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 , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

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 , , , , , , , , , | Leave a comment

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 , , , , , , , , , , , , , , | Leave a comment

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 , , , , , , , , | Leave a comment

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 , , , , , , , , , | Leave a comment

Room Status Remotely with OfficeIOT – Haaga-Helia Student Project with Martela

My negotiation rooms are reserved, but is anyone actually there? What’s the utilization rate? OfficeIOT project helps you. It senses if people are in the room and sends this information to a server in the cloud. Users can then log … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Preseed MySQL Server Password with Salt Stack

MySQL is the most popular multi-user database in the world. When you install MySQL Server automatically, you must set database root password without asking user to type it. On Debian and Ubuntu, you can use Preseed to answer installer (apt-get) … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , | Leave a comment

Monty Widenius Speaks in Pasila

Monty Widenius speaks in Haaga-Helia. He created MySQL database. Database Transaction Summit on w36 Wed 2013-09-04. Free registration until w35 Fri 2013-08-30.

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

PupeSoft – Free Finnish ERP

Can you run a 70 million euro business on a Free ERP? PupeSoft is a Free Finnish ERP system. It allows a company to control all aspects of its business: from accounting, customer relationship management to warehouse. My students have … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

Reading StackOverflow XML Dump to MySQL Database

StackOverflow data is available for free. To play with the XML data dump, you must insert it into MySQL database. This report shows you how. This article is not for beginners. To follow this article, you should have the StackOverflow … Continue reading

Posted in Uncategorized | Tagged , , , , , , | 1 Comment

Change MySQL Password on Ubuntu – dpkg-reconfigure mysql-server-5.1

Update: Fix forgotten MariaDB password on Ubuntu 18.04 and newer. Update: This method does not work on Ubuntu 16.04, and I have not tested it with newer versions either. Forgot MySQL server root password? It’s trivial to change it in … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 2 Comments

Static Advantage – Could WordPress Be 400 Times Faster?

Apache served static pages 400 times faster than dynamic WordPress pages. Could caching bring this speed advantage to WordPress? I measured pages with Apache benchmark tool “ab”, using 10 simultaneous connections. I used a powerful desktop as a server on … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , | Leave a comment

Build Web Interface to Database – LAMP Linux Apache MySQL PHP

Build Web Interface to Database – LAMP Linux Apache MySQL PHP In this howto, we program a simple database application. It reads data from a database, then prints it on a web page. Techniques teached here are used for building … Continue reading

Posted in Old Site | Tagged , , , , , , , | 1 Comment
  • Recent Posts

  • Picks

  • Boxing Clock for AndroidOcton8 Diving T-ShirtsShaking Tower Panda Android GameLearn Chinese with Android
  • Student projects