1、下载
下载页面是 http://dev.mysql.com/downloads/mysql/http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz
如果出现新的版本,直接更改这个链接中的版本号即可,如现在应改为
http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
2、复制到linux中,并解压
tar xvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz -C /usr/local
[root@zw oradata]# mv /usr/local/mysql-5.6.23-linux-glibc2.5-x86_64/ mysql
3、创建Mysql的用户和组 [root@zw oradata]# groupadd dba[root@zw oradata]# useradd -r -g dba mysql
userdel -r test 删除test用户
4 # 修改目录权限,指定给 mysql用户和用户组
[root@zw oradata]# chown -R mysql:dba /usr/local/mysql/
5.设置环境变量 export PATH=/usr/local/mysql/bin:$PATH
6、安装DB 初始化命令只能在 mysql 这个目录下执行,不然会报错
[root@zw oradata]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ [root@zw oradata]# cp my.cnf /etc
7.修改配置文件 [root@zw oradata]# cp my.cnf /etc/my.cnf
/usr/local/mysql
[root@zw oradata]# vi /etc/my.cnf
[mysqld]中添加:
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
server_id = 1log-bin=mysql-bin
8 :启动mySQL服务,
/usr/local/mysql/bin/mysqld_safe --user=root&
9、连接mysql
#使用MySQL命令的全路径。
[root@zw oradata]# /usr/local/mysql/bin/mysql -u root -pEnter password:上面设置的password
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.5.40-log MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
10.设置root密码
./bin/mysqladmin -u root password 123
10、启动、关闭mysql
[root@zw oradata]#/usr/local/mysql/support-files/mysql.server start
[root@zw oradata]#/usr/local/mysql/support-files/mysql.server stop如果想执行 service mysql start or restart stop 命令咋办的? 在不能老#./mysql.server start
解决方法: 将 mysql.server 复制一份到 /etc/rc.d/init.d 下并改名 mysql 或建个连接文件
假设当前目录为 /etc/rc.d/init.d
[root@zw oradata]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
启动: ① service mysql start 前提是执行了cp support-files/mysql.server /etc/init.d/mysql ② ./etc/init.d/mysql start ③ ./usr/local/mysql/bin/mysqld_safe --user=root& ④ /usr/local/mysql/support-files/mysql.server start 关闭:①. service mysql stop②./etc/init.d/mysql stop③./usr/local/mysql/bin/mysqladmin -u root -p shutdown④./usr/local/mysql/support-files/mysql.server stop
11、设置开机启动项
[root@zw oradata]# cp support-files/mysql.server /etc/init.d/mysql 上面已经做了可以省略
[root@zw oradata]# chkconfig --add mysql