I'm building a mail system with Dovecot, Postfix and Mailman with MySQL. I have the other three products installed but not yet configured. I'll do that after I get MySQL running.
The documentation at http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html was instrumental in remedying some errors I made along the way by following an installation procedure for Ubuntu instead of for Fedora. The installation completed successfully. The next step in the instructions I originally read said the next thing to do was run mysql_install_db. It started out well: Installing MySQL system tables...2015-06-23 11:54:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-06-23 11:54:50 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25) starting as process 23737 ... 2015-06-23 11:54:50 23737 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-06-23 11:54:50 23737 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-23 11:54:50 23737 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-06-23 11:54:50 23737 [Note] InnoDB: Memory barrier is not used 2015-06-23 11:54:50 23737 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-06-23 11:54:50 23737 [Note] InnoDB: Using Linux native AIO 2015-06-23 11:54:50 23737 [Note] InnoDB: Using CPU crc32 instructions 2015-06-23 11:54:50 23737 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-06-23 11:54:50 23737 [Note] InnoDB: Completed initialization of buffer pool 2015-06-23 11:54:50 23737 [Note] InnoDB: Highest supported file format is Barracuda. 2015-06-23 11:54:50 23737 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=1597945 2015-06-23 11:54:50 23737 [Warning] InnoDB: Starting to delete and rewrite log files. 2015-06-23 11:54:50 23737 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2015-06-23 11:54:51 23737 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2015-06-23 11:54:52 23737 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2015-06-23 11:54:52 23737 [Warning] InnoDB: New log files created, LSN=1597945 2015-06-23 11:54:52 23737 [Note] InnoDB: 128 rollback segment(s) are active. 2015-06-23 11:54:52 23737 [Note] InnoDB: Creating tablespace and datafile system tables. 2015-06-23 11:54:52 23737 [Note] InnoDB: Tablespace and datafile system tables created. 2015-06-23 11:54:52 23737 [Note] InnoDB: Waiting for purge to start 2015-06-23 11:54:52 23737 [Note] InnoDB: 5.6.25 started; log sequence number 1597945 And then things fell apart. 2015-06-23 11:54:52 23737 [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','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_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERRO 2015-06-23 11:54:52 23737 [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','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_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','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_A ERROR: 1136 Column count doesn't match value count at row 1 2015-06-23 11:54:53 23737 [ERROR] Aborting 2015-06-23 11:54:53 23737 [Note] Binlog end 2015-06-23 11:54:53 23737 [Note] InnoDB: FTS optimize thread exiting. 2015-06-23 11:54:53 23737 [Note] InnoDB: Starting shutdown... 2015-06-23 11:54:54 23737 [Note] InnoDB: Shutdown completed; log sequence number 1627743 2015-06-23 11:54:54 23737 [Note] /usr/sbin/mysqld: Shutdown complete OK Filling help tables...2015-06-23 11:54:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-06-23 11:54:54 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25) starting as process 23762 ... 2015-06-23 11:54:54 23762 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-06-23 11:54:54 23762 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-23 11:54:54 23762 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-06-23 11:54:54 23762 [Note] InnoDB: Memory barrier is not used 2015-06-23 11:54:54 23762 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-06-23 11:54:54 23762 [Note] InnoDB: Using Linux native AIO 2015-06-23 11:54:54 23762 [Note] InnoDB: Using CPU crc32 instructions 2015-06-23 11:54:54 23762 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-06-23 11:54:54 23762 [Note] InnoDB: Completed initialization of buffer pool 2015-06-23 11:54:54 23762 [Note] InnoDB: Highest supported file format is Barracuda. 2015-06-23 11:54:54 23762 [Note] InnoDB: 128 rollback segment(s) are active. 2015-06-23 11:54:54 23762 [Note] InnoDB: Waiting for purge to start 2015-06-23 11:54:54 23762 [Note] InnoDB: 5.6.25 started; log sequence number 1627743 2015-06-23 11:54:55 23762 [Note] Binlog end 2015-06-23 11:54:55 23762 [Note] InnoDB: FTS optimize thread exiting. 2015-06-23 11:54:55 23762 [Note] InnoDB: Starting shutdown... 2015-06-23 11:54:56 23762 [Note] InnoDB: Shutdown completed; log sequence number 1627753 OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system ; I don't know what those are, or where they are. ; 'find' didn't find them. 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 patronus.theglobalvoice.info 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 mysql-test ; perl mysql-test-run.pl Please report any problems at http://bugs.mysql.com/ The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com New default config file was created as /usr/my.cnf and will be used by default by the server when you start it. You may edit this file to change server settings WARNING: Default config file /etc/my.cnf exists on the system This file will be read by default by the MySQL server If you do not want to use this, either remove it, or use the --defaults-file argument to mysqld_safe when starting the server Since this is a new installation, I decided to take the advice of the automated instructions: # mysqld_safe --defaults-file 150623 11:58:52 mysqld_safe Logging to '/var/log/mysqld.log'. 150623 11:58:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150623 11:58:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Unless I'm an absolute dolt, this looked successful. Since this was my first time running MySQL, I tried the next step as if it were a new install, which it's supposed to be: # /usr/bin/mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MySQL to secure it, we'll need the current password for the root user. If you've just installed MySQL, 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 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Enter current password for root (enter for none): ^C Aborting! Cleaning up... Cleaning up... Warning: Could not unlink .my.cnf.24101: No such file or directory Warning: Could not unlink .mysql.24101: No such file or directory And that's where things are. Any help greatly appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
