Difference between revisions of "Configuring basic MariaDB server"

From Notes_Wiki
m
m
Line 1: Line 1:
<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>
=Configuring basic MySQL server=
=Configuring basic MySQL server=



Revision as of 08:05, 2 December 2012

<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>

Configuring basic MySQL server

Installation

To install mysql server use:

yum -y install mysql-server


Configuration

Starting mysql server

To start mysql server use:

service mysqld start


Enabling on start-up

To configure mysql server such that it automatically runs on system boot use:

chkconfig mysqld on


Setting root password

By defauly mysql root user has no password (empty password) which is not very secure. To setup root password for mysql use '/usr/bin/mysql_secure_installation' script. This script will ask for current root password which is blank and then will ask for new root password twice. It will also ask a number of other queries. Answer 'Y' (default) for all other queries.


Back to Mysql configuration