Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #232195 > unrolled thread

mariadb installation question

Back to article view | Back to linux.debian.user

Contents

  mariadb installation question Semih Ozlem <semihozlemlinuxuser@gmail.com> - 2021-02-27 22:10 +0100
    Re: mariadb installation question Nicholas Geovanis <nickgeovanis@gmail.com> - 2021-02-27 22:40 +0100

#232195 — mariadb installation question

[Multipart message — attachments visible in raw view] — view raw

Hi everyone

I am getting the following error after installing mariadb. Any ideas why
this would be the case
It asks for a root password. I previously installed and uninstalled mysql
and mariadb twice because of errors.

user@debian:/media/user/Windows/usercreatedfolders/debianrepos/mysql$ sudo
mysql_secure_installation

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):
Warning: World-writable config file
'/media/user/Windows/usercreatedfolders/debianrepos/mysql/.my.cnf.1437' is
ignored
ERROR 1156 (08S01): Got packets out of order
Enter current password for root (enter for none):
Aborting!

Cleaning up...

[toc] | [next] | [standalone]

#232196

[Multipart message — attachments visible in raw view] — view raw

On Sat, Feb 27, 2021, 3:09 PM Semih Ozlem <semihozlemlinuxuser@gmail.com>
wrote:

> Hi everyone
>
> I am getting the following error after installing mariadb. Any ideas why
> this would be the case
> It asks for a root password. I previously installed and uninstalled mysql
> and mariadb twice because of errors.
>
> user@debian:/media/user/Windows/usercreatedfolders/debianrepos/mysql$
> sudo mysql_secure_installation
>
> 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):
> Warning: World-writable config file
> '/media/user/Windows/usercreatedfolders/debianrepos/mysql/.my.cnf.1437' is
> ignored
> ERROR 1156 (08S01): Got packets out of order
> Enter current password for root (enter for none):
> Aborting!
>
> Cleaning up...
>

So it's talking about the root password in the system catalog of the
database. Not the root password for the system.

Also this important. It says that your mariadb config file is
world-writable. It might be changed by bad actors, so mariadb is ignoring
it at startup.

>

[toc] | [prev] | [standalone]

Back to top | Article view | linux.debian.user

csiph-web