redhat6.5安装解压版mysql

安装MySQL(这里我们安装的是mysql-5.6.32-linux-glibc2.5-x86_64.tar.gz)

先检查系统自带的mysql:

rpm–qa|grep –i mysql

卸载掉：

rpm-e --nodeps mysql-libs-5.1.71-1.el6.x86_64

解压mysql到指定安装目录下/app/apps:

cd/tmp/software

tarzxvf mysql-5.6.32-linux-glibc2.5-x86_64.tar.gz -C /app/apps/

设置mysql的配置文件：

cp /app/apps/mysql-5.6.32-linux-glibc2.5-x86_64/support-files/my-default.cnf/etc/my.cnf

编辑配置my.cnf

vim /etc/my.cnf

内容如下(红字为需要添加的内容):

 [root@hl-gftest1etc]# vi /etc/my.cnf

# For advice on how to change settingsplease see

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

# *** DO NOT EDIT THIS FILE. It's atemplate which will be copied to the

# *** default location during install, andwill be replaced if you

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

 

[mysqld]

 

# Remove leading # and set to the amount ofRAM for the most important data

# cache in MySQL. Start at 70% of total RAMfor dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

 

# Remove leading # to turn on a veryimportant data integrity option: logging

# changes to the binary log betweenbackups.

# log_bin

 

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

basedir=/app/apps/mysql-5.6.32-linux-glibc2.5-x86_64

datadir=/app/apps/mysql-5.6.32-linux-glibc2.5-x86_64/data

max_allowed_packet=200M

# port = .....

# server_id = .....

# socket = .....

 

character_set_server =utf8

init_connect = 'SET NAMESutf8'

 

# Remove leading # to set options mainlyuseful for reporting servers.

# The server defaults are faster fortransactions and fast SELECTs.

# Adjust sizes as needed, experiment tofind the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

 

lower_case_table_names=1

[mysql]

default-character-set =utf8

[mysql.server]

default-character-set =utf8

[mysqld_safe]

default-character-set =utf8

[client]

default-character-set =utf8

 

将mysql配置到环境变量:

vim /etc/profile

在PATH中添加mysql的安装目录和bin目录：

/app/apps/mysql-5.6.32-linux-glibc2.5-x86_64:/app/apps/mysql-5.6.32-linux-glibc2.5-x86_64/bin:

添加位置如下：

重新连接服务器使得配置文件生效。添加mysql到系统服务开机启动：

cp -ar /app/apps/mysql-5.6.32-linux-glibc2.5-x86_64/support-files/mysql.server/etc/init.d/mysqld

添加用户mysql:依次执行下面语句：注意最后两行后面是有点的

groupadd mysql

useradd -r -g mysql mysql

cd/app/apps/mysql-5.6.32-linux-glibc2.5-x86_64/

chown -R mysql .

chgrp -R mysql .

用mysql用户初始化数据库。

cd /app/apps/mysql-5.6.32-linux-glibc2.5-x86_64/

scripts/mysql_install_db --user=mysql  --defaults-file=/etc/my.cnf

启动mysql服务:

service mysqld start

cd/app/apps/mysql-5.6.32-linux-glibc2.5-x86_64/bin/

修改root密码:

mysqladmin -uroot password '123qwe!@#'

登陆查看字符集：

mysql -uroot –p

然后输入密码回车进入数据库：

查看字符集设置是否正确：

show variables like '%character%';

开启远程连接：选择要使用的mysql数据库，修改远程连接的基本信息。

use mysql

更改远程连接设置：

GRANTALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123qwe!@#' WITH GRANTOPTION;

刷新刚才修改的权限，使其生效

flushprivileges;

查看修改是否成功：

selecthost,user from user;

有红框里的东西就成功,退出重启mysql。

退出mysql：mysql>quit

service mysqld restart

Mysql至此安装完毕，安装mysql比较容易出错，我们只要根据mysql的data目录下生成的xxxx.err日志文件信息来调整就行了。

资源：

链接：http://pan.baidu.com/s/1slLHvyd 密码：towp