centos7源码安装mysql5

1、Mysql数据库安装

下载MySQL源码包，优先找国内源，http://mirrors.sohu.com/mysql/

• mysql-5.5.60.tar.gz上传/opt
• 检查是否安装过mysql

rpm -qa |grep -i  mysql
rpm -qa |grep -i  maria
yum remove -y maria*

• 安装编译环境

yum install -y gcc gcc-c++ git cmake ncurses-devel bison

• 进入/opt文件夹（我这里使用的是国产的ssh软件，finalshell），并把mysql安装包放到里面，并解压mysql的安装包

• 安装配置检查，这里把代码一次性复制完，然后粘贴到命令框运行，记得进入mysql的解压文件夹里运行

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/ \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_DATADIR=/data/mysql/ \
-DSYSCONFDIR=/etc \
-DMYSQL_TCP_PORT=3306 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS=1 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_DEBUG=0

• 编译安装mysql

make && make install

• 将源码安装的Mysql数据库服务设置为系统服务，可以使用chkconfig管理，并启动MYSQL数据库
  （代码是一个井号一个命令）

# cd /usr/local/mysql/
# cp support-files/my-large.cnf /etc/my.cnf
# cp support-files/mysql.server /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --level 35 mysqld on
# mkdir -p /data/mysql
# useradd mysql
# /usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/data/mysql/ --basedir=/usr/local/mysql/
# ln -s /usr/local/mysql/bin/* /usr/bin/
# systemctl restart mysqld
# systemctl status mysqld
# ps -ef |grep mysql
# netstat -lntp |grep 3306

• 到这里MySQL的源码安装已经完成了

下面是MySQL的一些常用命令操作

//登录数据库
# mysql
//显示所有库
# show databases;
创建cx库
# create database cx;
//切换到jfedu库
# use cx;
//显示所有表
# show tables;
//创建表t1，两个字段id，name
# create table t1 (id varchar(20),name varchar(20));
//表t1插入一条数据
# insert into t1 values ("1","cx");
//查询表t1所有数据
# select * from t1;
//条件查询表t1
# select * from t1 where id="1" and name="cx";
//查询表t1字段信息
# desc t1;
//修改表t1的name字段的长度为32
# alter table t1 modify column name varchar(32);
//修改name字段的内容
# update t1 set name='cx.out' where id=1;
//刷新权限
# flush privileges;

//清空表t1内容
# delete from t1;
//删除表t1
# drop table t1;
//删除cx数据库
# drop database cx;
//查看数据库字符集
# show variables like '%char%';
//查看MySQL存储引擎
# show engines;
//查看MySQL默认的存储引擎
# show variables like '%storage_engine%';
//修改t1表存储引擎；
# alter table t1 engine=innodb;

Mysql数据库密码管理命令

// MYSQL创建用户及授权
# create database cx;
# grant all on cx.* to '123456'@'localhost' identified by '123456';
# select user,host,password from mysql.user where user="root";
# mysql -u root -p									#登录成功
//克隆虚拟机，修改ip地址后测试
# mysql -h 192.168.65.130 -P 3306 -u root -p		#登录失败
//给192.168.65.131授权
# grant all on cx.* to 'root'@'192.168.65.131' identified by '123456';
# select user,host,password from mysql.user where user="root";
# mysql -h 192.168.65.130 -P 3306 -u root -p		#登录成功
//给test用户授权可以增删改查
# grant select,insert,update,delete on *.* to 'root'@'%' identified by '123456';

//MYSQL密码破解方法
# select user,host,password from mysql.user;
# grant all on *.* to 'root'@'localhost' identified by '123456';
# /etc/init.d/mysqld stop
# /usr/bin/mysqld_safe --user=mysql --skip-grant-tables &
# mysql
# use mysql;
# update user set password=password('123456') where user='root';
# flush privileges;
# /etc/init.d/mysqld restart
# mysql -u root -p