Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.1.8
-
None
-
RHEL 7
Description
I have done below steps to install mariaDB on my test server.
OS : RHEL 7
DB : MariaDB 10.1.8
ln -s /opt/mariadb/mariadb-10.1.8-linux-x86_64 /opt/mariadb/mysql
|
groupadd mysql
|
useradd -g mysql mysql
|
chown -R mysql:mysql /opt/mariadb/mysql/
|
cp /opt/mariadb/mysql/support-files/my-small.cnf /etc/my.cnf
|
basedir=/opt/mariadb/mysql
|
datadir=/opt/mariadb/mysql/data
|
user=mysql
|
/opt/mariadb/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mariadb/mysql --datadir=/opt/mariadb/mysql/data
|
logs for the installation :
[root@dpgap02v scripts]# /opt/mariadb/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mariadb/mysql --datadir=/opt/mariadb/mysql/data
|
Installing MariaDB/MySQL system tables in '/opt/mariadb/mysql/data' ...
|
2016-04-15 12:05:53 140604141901696 [Note] /opt/mariadb/mysql/bin/mysqld (mysqld 10.1.8-MariaDB) starting as process 19522 ...
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: The InnoDB memory heap is disabled
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Memory barrier is not used
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Compressed tables use zlib 1.2.3
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Using Linux native AIO
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Using CPU crc32 instructions
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Completed initialization of buffer pool
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Highest supported file format is Barracuda.
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600709 in the ib_logfiles!
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Database was not shutdown normally!
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Starting crash recovery.
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Reading tablespace information from the .ibd files...
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Restoring possible half-written data pages
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: from the doublewrite buffer...
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: 128 rollback segment(s) are active.
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Waiting for purge to start
|
2016-04-15 12:05:53 140604141901696 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1600709
|
2016-04-15 12:05:53 140603593561856 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
2016-04-15 12:05:53 140604141901696 [Note] Recovering after a crash using tc.log
|
2016-04-15 12:05:53 140604141901696 [Note] Starting crash recovery...
|
2016-04-15 12:05:53 140604141901696 [Note] Crash recovery finished.
|
OK
|
Filling help tables...
|
2016-04-15 12:05:56 139928902223744 [Note] /opt/mariadb/mysql/bin/mysqld (mysqld 10.1.8-MariaDB) starting as process 19569 ...
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: The InnoDB memory heap is disabled
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Memory barrier is not used
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Compressed tables use zlib 1.2.3
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Using Linux native AIO
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Using CPU crc32 instructions
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Completed initialization of buffer pool
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Highest supported file format is Barracuda.
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: 128 rollback segment(s) are active.
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Waiting for purge to start
|
2016-04-15 12:05:56 139928902223744 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1616809
|
2016-04-15 12:05:56 139928352560896 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
Creating OpenGIS required SP-s...
|
2016-04-15 12:05:58 140614828787584 [Note] /opt/mariadb/mysql/bin/mysqld (mysqld 10.1.8-MariaDB) starting as process 19613 ...
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: The InnoDB memory heap is disabled
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Memory barrier is not used
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Compressed tables use zlib 1.2.3
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Using Linux native AIO
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Using CPU crc32 instructions
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Completed initialization of buffer pool
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Highest supported file format is Barracuda.
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: 128 rollback segment(s) are active.
|
2016-04-15 12:05:58 140614828787584 [Note] InnoDB: Waiting for purge to start
|
2016-04-15 12:05:59 140614828787584 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1616819
|
2016-04-15 12:05:59 140614280656640 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
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 MariaDB root USER !
|
To do so, start the server, then issue the following commands:
|
|
'/opt/mariadb/mysql/bin/mysqladmin' -u root password 'new-password'
|
'/opt/mariadb/mysql/bin/mysqladmin' -u root -h dpgap02v password 'new-password'
|
|
Alternatively you can run:
|
'/opt/mariadb/mysql/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 MariaDB Knowledgebase at http://mariadb.com/kb or the
|
MySQL manual for more instructions.
|
|
You can start the MariaDB daemon with:
|
cd '/opt/mariadb/mysql' ; /opt/mariadb/mysql/bin/mysqld_safe --datadir='/opt/mariadb/mysql/data'
|
|
You can test the MariaDB daemon with mysql-test-run.pl
|
cd '/opt/mariadb/mysql/mysql-test' ; perl mysql-test-run.pl
|
|
Please report any problems at http://mariadb.org/jira
|
|
The latest information about MariaDB is available at http://mariadb.org/.
|
You can find additional information about the MySQL part at:
|
http://dev.mysql.com
|
Support MariaDB development by buying support/new features from MariaDB
|
Corporation Ab. You can contact us about this at sales@mariadb.com.
|
Alternatively consider joining our community based development effort:
|
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
|
[root@dpgap02v scripts]#
|
[root@dpgap02v scripts]#
|
[root@dpgap02v scripts]#
|
[root@dpgap02v scripts]# service mysql start
|
Starting mysql (via systemctl): [ OK ]
|
[root@dpgap02v scripts]# service mysql status
|
ERROR! MySQL is not running
|
mysql is not up and running here.
please suggest me.
Thanks
Anil