On Sat, Feb 27, 2021, 3:09 PM Semih Ozlem <[email protected]> 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. >
