centos在线安装mysql,centos在线安装mysql

安装mysql

yum install -y mysql-server

service mysqld start    启动服务

service mysqld stop    关闭服务

修改/ect/my.cnf，如果文件不存在，直接创建，修改内容如下：

[mysqld]

transaction-isolation=READ-COMMITTED

# Disabling symbolic-links is recommended to prevent assorted security risks;

# to do so, uncomment this line:

# symbolic-links=0

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

key_buffer              = 16M

key_buffer_size         = 32M

max_allowed_packet      = 32M

thread_stack            = 256K

thread_cache_size       = 64

query_cache_limit       = 8M

query_cache_size        = 64M

query_cache_type        = 1

max_connections         = 550

# log_bin should be on a disk with enough free space

# NOTE: replace '/x/home/mysql/logs/binary' below with

#       an appropriate path for your system.

log_bin=/usr/local/mysql/mysql/logs/binary/mysql_binary_log

# For MySQL version 5.1.8 or later. Comment out binlog_format for older versions.

binlog_format           = mixed

read_buffer_size = 2M

read_rnd_buffer_size = 16M

sort_buffer_size = 8M

join_buffer_size = 8M

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

创建目录：

mkdir -p /usr/local/mysql/mysql/logs/binary/

chown mysql /usr/local/mysql/mysql/logs/binary/

sudo -u mysql touch /usr/local/mysql/mysql/logs/binary/mysql_binary_log.index

配置：/usr/bin/mysql_secure_installation

配置过程中，除了Disallow root login remotely？设置为n，其余全部设置为y。

启动服务，登录：mysql -uroot -p123456

创建数据库：

create database amon DEFAULT CHARACTER SET utf8;

create database rman DEFAULT CHARACTER SET utf8;

create database metastore DEFAULT CHARACTER SET utf8;

create database sentry DEFAULT CHARACTER SET utf8;

create database nav DEFAULT CHARACTER SET utf8;

create database navms DEFAULT CHARACTER SET utf8;

create database scm DEFAULT CHARACTER SET utf8;

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

FLUSH PRIVILEGES;

show engines，如果发现没有InnoDB引擎，卸载mysql数据库，从新安装，没有InnoDB引擎有可能是在my.cnf中配置了InnoDB相关参数，

去掉在my.cnf中所有有关InnoDB的参数配置，卸载步骤如下：

yum remove -y mysql-server

rm -rf /var/lib/mysql/ /usr/local/mysql/ /var/log/mysqld.log /var/run/mysqld.pid /etc/my.cnf

重新安装，执行以上步骤；

设置mysql开机启动：

sudo /sbin/chkconfig mysqld on;

sudo /sbin/chkconfig --list mysqld;