mysql 欧拉_TCM部署数据库-EulerOS 2.3 64+mysql 5.6

准备好TCM安装包和FusionAccess_Euler_Installer_V100R006C20.iso，并在oracle官网下载mysql5.6安装包mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz

创建虚拟机并部署好操作系统，通过winscp上传mysql软件包到数据库安装目录，这里为/var目录

cd /var

tar -xzvf mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz #解压

mvmysql-5.6.41-linux-glibc2.12-x86_64 mysql #重命名文件夹

groupadd mysql #创建用户组

useradd -d /home/mysql -m mysql #创建用户的同时创建用户目录(Euler系统创建用户不会自动创建家目录)

usermod -G mysql mysql #加入mysql组

chown -R mysql:mysql mysql #修改mysql文件夹权限

cd /var/mysql/support-files/

cp my-default.cnf /etc/my.cnf #复制创建my.cnf(也可以自己手动创建)

vi /etc/my.cnf

修改内容如下(也可以直接复制替换)：

————————————————————————————————————

# For advice on how to change settings please see

#

http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

# *** DO NOT EDIT THIS FILE. It's a template which will be

copied to the

# *** default location during install, and will be replaced

if you

# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the

most important data

# cache in MySQL. Start at 70% of total RAM for dedicated

server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data

integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

basedir = /var/mysql

#修改此处为mysql安装目录

datadir =

/var/mysql/data #修改此处为mysql数据目录

port = 3306#端口号默认

character-set-server=utf8

# server_id =

socket =

/var/mysql/mysql.sock

# Remove leading # to set options mainly useful for

reporting servers.

# The server defaults are faster for transactions and fast

SELECTs.

# Adjust sizes as needed, experiment to find the optimal

values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[client]

port=3306

socket = /var/mysql/mysql.sock

default-character-set=utf8

[mysql]

socket = /var/mysql/mysql.sock

default-character-set=utf8

[mysqladmin]

socket = /var/mysql/mysql.sock

[mysqldump]

socket = /var/mysql/mysql.sock

cp mysql.server /etc/init.d/mysql

vi /etc/init.d/mysql #修改此文件

basedir=/var/mysql

datadir=/var/mysql/data

vi /etc/profile #修改此文件添加环境变量

export MYSQL_HOME="/var/mysql"

export PATH="$PATH:$MYSQL_HOME/bin"

安装数据库

cd /var/mysql

./scripts/mysql_install_db --user=mysql

安装完成后修改root，

mysqladmin -u root password 'Huawei12#$' #修改root用户密码

mysql -u root -p

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY

'your_password' WITH GRANT OPTION;#允许root用户远程访问

FLUSH PRIVILEGES;#刷新权限

exit

mysql -u root -h 127.0.0.1 -p #登陆数据库

use mysql #切换数据库

grant all privileges on *.* to 'root'@'127.0.0.1'identified

by '密码'; #授权

添加服务自启动

chkconfig --add mysql

chkconfig mysql on

按照指导书部署TCM软件，连接TCM时使用root用户