Arch Linux

donnut

Member

Registered: 2015-06-12

Posts: 16

[SOLVED] error running install script of mariadb

I just installed mariadb (v10.1.9-4)

Then when trying to run the script as root:

mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

the log shows two errors and the process aborts :

2015-12-23 17:18:29 140548222478080 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-12-23 17:18:29 140548653422336 [ERROR] Incorrect definition of table mysql.proc: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVA
2015-12-23 17:18:29 140548653422336 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES

I can not find any log file in the /usr/lib/mysql directory.

I removed mariadb and the older mysql and tried to install mariadb again, but the result is the same.

Any help is appreciated.

Last edited by donnut (2015-12-27 10:47:06)

Elizine

Member

From: United Kingdom

Registered: 2015-10-07

Posts: 39

Website

Re: [SOLVED] error running install script of mariadb

Post installation, you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB.

[root@tecmint yum.repos.d]#  mysql_secure_installation
/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

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):

OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] Y

New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

---

Cloud Hosting Solutions

donnut

Member

Registered: 2015-06-12

Posts: 16

Re: [SOLVED] error running install script of mariadb

Thanks for the reply, but I don't think that solves the issue I'm facing. When I run

mysql_secure_installation

I get the error

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory")

I tried to install mariadb on another box running Arch Linux that didn't have mysql install before, and that installation wen't without any problem. So, my guess is that it has to do with the 'old' mysql installed.

respiranto

Member

Registered: 2015-05-15

Posts: 479

Website

Re: [SOLVED] error running install script of mariadb

I could imagine that the old data in /var/lib/mysql is posing problems.
So I would suggest simply (re)moving the directory.
Since the mariadb package contains an empty /var/lib/mysql directory, it might be necessary to recreate it (or reinstall mariadb).

donnut

Member

Registered: 2015-06-12

Posts: 16

Re: [SOLVED] error running install script of mariadb

I solved the installation problem by running

systemctl enable mysqld

and rebooting. After that it all runs fine.
Awkward. Thank you all for your help.