Welcome to the Linux Foundation Forum!

Lab 18 - Starting my sql

As I try this command:

mysql_secure_installation

I get the following error:

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 1156 (08S01): Got packets out of order

Can someone here guide me as to what the next step is? How to solve this error?

Answers

  • lee42x
    lee42x Posts: 380

    Interesting, the short answer is use sudo, like:
    [student@CentOS7 ˜]$ sudo mysql_secure_installation
    and it should work fine.

    The long answer will take some investigation.

    Thanks for bringing this to our attention.

    Lee

  • lee42x
    lee42x Posts: 380

    The long answer, Ubuntu locks the root user.
    sudo works, the lab will be updated to use sudo.

Categories

Upcoming Training