The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers

Hmm, need to check why MariaDB got installed

Posted by jpluimers on 2015/07/06

The zypper dup has installed MariaDB; now I need to figure out which dependency did this, as I’m not happy with the update message:

Message from package mariadb:

You just installed MySQL server for the first time.

You can start it using:
 rcmysql start

During first start empty database will be created for your automatically.

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h misibook password 'new-password'

Alternatively you can run:
'/usr/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

–jeroen

2 Responses to “Hmm, need to check why MariaDB got installed”

  1. Kevin G. McCoy's avatar

    Kevin G. McCoy said

    MariaDB is simply the more-open-source version of Oracle MySQL. Lots of Linux/Windows apps need a database and use MySQL:or the interchangeable MariaDB. Both MySQL and MariaDB are open source, but MySQL has a lot of limitations on commercial use and distribution. The Mantis bug tracker can use MySQL/MariaDB.

    Anyway, since it was a new install, the messages are warning you that the root password is set to the default. Not a good thing on a public server but no big deal on a private one with no exposure to the WAN. Change the root password and create one or more non-root accounts for your software to use. The new accounts should be limited to the specific schemas they need to access.

Leave a reply to jpluimers Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.