下载:dev.mysql.com或www.percona.com
下载二进制版本
http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.24-linux-glibc2.5-x86_64.tar.gz
cd /data
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.24-linux-glibc2.5-x86_64.tar.gz
http://mirrors.sohu.com/mysql/MySQL-5.7/
1、准备安装包mysql-5.6.23
2、创建一个MySQL用户组:groupadd mysql
3、一个属于MySQL的用组的mysql用户: useradd -g mysql -s /sbin/nologin -d /opt/mysql mysql
4、查看用户和组状态:
id mysql
uid=500(mysql) gid=500(mysql) groups=500(mysql)
5、解压mysql的安装包:
tar -xzvf/data/soft/mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz -C/opt/mysql/mysql-5.6.23/
6、配置myql的安装目录:
mkdir -p /data/mysql/mysql_3306/{data,tmp,logs}
ln -s /opt/mysql/mysql-5.6.23 /usr/local/mysql
ll /usr/local/
7、查看结果:
ll /usr/local/
lrwxrwxrwx 1 root root 23 Dec 17 15:24 mysql ->/opt/mysql/mysql-5.6.23
8、剪贴文件到安装目录:
cd /opt/mysql/mysql-5.6.23
mv mysql-5.6.23-linux-glibc2.5-x86_64/* .
9、查看依赖的lib库是否安全
ldd /usr/local/mysql/bin/mysqld
10、更改权限:
chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /data/mysql
chown -R mysql:mysql /opt/mysql
11、设置root的环境变量:
vi .bash_profile
export PATH=/usr/local/mysql/bin:/opt/mysql/mysql-5.6.23/bin:$HOME/bin:$PATH
source .bash_profile
12、 如果有编辑好的my.cnf文件直接上放在/etc/my.cnf
13、复制my.cnf到/etc/目录下:
创建my.cnf文件放在:/etc/my.cnf
14、初始化数据库:
cd /usr/local/mysql/
初始化数据库一定要在basedir下进行
./scripts/mysql_install_db --user=mysql --defaults-file=/etc/my.cnf
./scripts/mysql_install_db--datadir=/data/mysql/mysql_3306/data --defaults-file=/etc/my.cnf
注:5.7以后改为:
http://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html
cd /usr/local/mysql/bin
./mysqld --initialize--user=mysql --datadir=/backup/mysql/mysql_3308/data --defaults-file=/backup/my3308.cnf
./bin/mysqld --initialize-insecure--user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/mysql_3306/data
会在/data/mysql/mysql_3306/data目录下产生(auto.cnf、error.log 、ib_buffer_pool、ibdata1、mysql、performance_schema 、slow.log 、sys)此文件;
15、将启动信息加入到启动像
cd /usr/local/mysql
cp support-files/mysql.server /etc/init.d/mysql
16、启动mysql服务:
/etc/init.d/mysql start
/etc/init.d/mysql start |stop| restart
如果启动失败了看一下日志:cat/data/mysql/mysql3306/data/error.log,只看ERROR错误;
在error.log中过滤出密码:cat/data/mysql/mysql3306/data/error.log |grep password 按照这样可以得到密码
2016-08-03T01:57:04.398037Z 1 [Note] A temporary password isgenerated for root@localhost: Fb&CYhv6UlwP
密码就是:Fb&CYhv6UlwP
注:如果输入MYSQL找不到位置,在/etc/profile里加exportPATH=$PATH:/user/local/mysql/bin
17、查看mysql是否启动成功:
a、查看mysql的进程:ps axu|grep mysqld
b、查看mysql的监听:netstat -nalp|grep "3306"
18、添加启动项:
chkconfig --add mysql
chkconfig --level 35 mysql on
chkconfig --list |grep mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
19、查看mysql用户的表信息:select user,host,password(authentication_string) from mysql.user;
20、清理mysql初始化信息:
delete from mysql.user where user!='root' or host!='localhost';
truncate mysql.db;
drop database test;
grant all privileges on *.* to 'wubx'@'%' identified by 'wubxwubx';
grant replication client on *.* to 'repl'@'%' identified by 'repl4slave';
flush privileges;
reset master;
23、刷新数据库:
flush privileges;
24、检查权限:
select user,host,password(authentication_string) from mysql.user;