root@avon ~ > p -S mysql resolving dependencies... looking for inter-conflicts... Targets (3): libmysqlclient-5.5.30-1 mysql-clients-5.5.30-1 mysql-5.5.30-1 Total Download Size: 12.32 MiB Total Installed Size: 123.46 MiB Proceed with installation? [Y/n] :: Retrieving packages from extra... libmysqlclient-5.5.30-1-x86_64 3.0 MiB 87.4M/s 00:00 [##########################################] 100% mysql-clients-5.5.30-1-x86_64 835.8 KiB 142M/s 00:00 [##########################################] 100% mysql-5.5.30-1-x86_64 8.5 MiB 81.8M/s 00:00 [##########################################] 100% (3/3) checking package integrity [##########################################] 100% (3/3) loading package files [##########################################] 100% (3/3) checking for file conflicts [##########################################] 100% (3/3) checking available disk space [##########################################] 100% (1/3) installing libmysqlclient [##########################################] 100% (2/3) installing mysql-clients [##########################################] 100% (3/3) installing mysql [##########################################] 100% Installing MySQL system tables... OK Filling help tables... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL 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 avon 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. See the manual for more instructions. You can start the MySQL daemon with: cd /usr ; /usr/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /usr/mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/scripts/mysqlbug script! root@avon ~ > p -S maraidb error: target not found: maraidb zsh: exit 1 pacman -S maraidb root@avon ~ > p -S mariadb resolving dependencies... looking for inter-conflicts... :: libmariadbclient and libmysqlclient are in conflict. Remove libmysqlclient? [y/N] y :: mariadb-clients and mysql-clients are in conflict. Remove mysql-clients? [y/N] y :: mariadb and mysql are in conflict. Remove mysql? [y/N] y Targets (6): libmariadbclient-5.5.29-1 libmysqlclient-5.5.30-1 [removal] mariadb-clients-5.5.29-1 mysql-5.5.30-1 [removal] mysql-clients-5.5.30-1 [removal] mariadb-5.5.29-1 Total Download Size: 17.69 MiB Total Installed Size: 154.84 MiB Net Upgrade Size: 31.37 MiB Proceed with installation? [Y/n] :: Retrieving packages from community... libmariadbclient-5.5.29-1-x86_64 7.0 MiB 12.7M/s 00:01 [##########################################] 100% mariadb-clients-5.5.29-1-x86_64 873.5 KiB 110M/s 00:00 [##########################################] 100% mariadb-5.5.29-1-x86_64 9.8 MiB 85.6M/s 00:00 [##########################################] 100% (3/3) checking package integrity [##########################################] 100% (3/3) loading package files [##########################################] 100% (3/3) checking for file conflicts [##########################################] 100% (6/6) checking available disk space [##########################################] 100% (1/3) removing libmysqlclient [##########################################] 100% (2/3) removing mysql-clients [##########################################] 100% (3/3) removing mysql [##########################################] 100% (1/3) installing libmariadbclient [##########################################] 100% (2/3) installing mariadb-clients [##########################################] 100% (3/3) installing mariadb [##########################################] 100% Installing MariaDB/MySQL system tables in '/var/lib/mysql' ... 130218 21:48:26 [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 130218 21:48:26 [ERROR] Incorrect definition of table mysql.event: 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','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','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_A ERROR: 1548 Cannot load from mysql.proc. The table is probably corrupted 130218 21:48:30 [ERROR] Aborting 130218 21:48:31 [Note] /usr/bin/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in /var/lib/mysql that may be helpful. The latest information about mysql_install_db is available at http://kb.askmonty.org/v/installing-system-tables-mysql_install_db. MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before mailing us! And remember, if you do mail us, you should use the /usr/scripts/mysqlbug script! Optional dependencies for mariadb perl-dbi perl-dbd-mysql root@avon ~ >