Difference between revisions of "Configuring basic MariaDB server"
From Notes_Wiki
(Created page with "=Configuring basic MySQL server= =Installation= To install mysql server use: <pre> yum -y install mysql-server </pre> =Configuration= ==Starting mysql server== To start...") |
m |
||
| Line 31: | Line 31: | ||
By defauly mysql root user has no password (empty password) which is not very secure. To setup root password for mysql use '<tt>/usr/bin/mysql_secure_installation</tt>' 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. | By defauly mysql root user has no password (empty password) which is not very secure. To setup root password for mysql use '<tt>/usr/bin/mysql_secure_installation</tt>' 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]] | |||
Revision as of 23:07, 17 November 2012
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
