centos6.9使用通用包安装mysql

已经可以用yum了为什么还用通用包啊,yum不成功真的是非常尴尬.以前都是联网装顺利的一比,今天突然不好用

找了好几个还就清华的下载速度最快,要是用官网的你就等吧,说一天后能下完.

• 上传的路径
  
• 解压文件创建用户

tar -zxvf mysql-5.6.47-linux-glibc2.12-x86_64.tar.gz 
groupadd mysql && useradd -r -g mysql mysql

• 修改安装目录名称并更换所有者

mv mysql-5.6.47-linux-glibc2.12-x86_64 mysql
cd mysql
chown -R  mysql:mysql ./

• 安装依赖

yum -y install autoconf && yum install libaio* -y && yum -y install numactl 

• 执行安装脚本

#以mysql用户安装mysql数据库
 ./scripts/mysql_install_db --user=mysql 
 #修改用户权限
 chown -R root:root ./ && chown -R mysql:mysql data
 #创建默认日志
  mkdir /var/log/mariadb && touch /var/log/mariadb/mariadb.log
  #修改配置文件权限
  chmod 644 /usr/local/mysql/my.cnf
  #启动mysql服务
  /support-files/mysql.server start
  #设置用户密码
  ./bin/mysqladmin -u root -h localhost.localdomain password '123456'
  #登录数据库
  ./bin/mysql -h127.0.0.1 -uroot -p123456

卸载mysql

1. rm -rf /root/.mysql_sercret  
2. rm -rf /var/lib/mysql
3. rm -rf /usr/local/mysql

添加开机启动

#将脚本复制为开机启动脚本,并且添加可执行权限
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
#设置开机启动
chkconfig mysqld on

#启动命令为
service mysqld start
service mysqld restart
service mysqld stop

• 连接MySQL设置远程连接

mysql -uroot -p123456# 连接mysql
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";#授权远程连接
flush privileges;#刷新权限

• 查看并且设置编码

 show variables like '%char%';

vim /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

[mysqld]
character_set_server=utf8 #此行是添加的内容
#
# 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
#
# 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
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

mysql文件的下载路径:
链接：https://pan.baidu.com/s/1UanXz0PIVqzfD5pIF23T9A
提取码：j5cx
复制这段内容后打开百度网盘手机App，操作更方便哦

• 一些mysql的简单命令

show databases; #查看mysql有哪些库
use certstamps; #应用某些库
show tables; #查看库里面有哪些表
desc t_api_log; #查看某个表具体的结构
truncate t_api_log; #截断表，自增长重新统计
select * from t_api_log; #查看表内数据
select count(*) from t_api_log #查询总条数
insert into t_api_log (datsa) values ('sdfsdfsd') #插入语句
update t_api_log set id = 's'; #更新语句
select * from t_api_log where license='sss' order by create_time DESC  limit 0,10;#分页查询语句
delete from t_api_log ;#删除表的语句

//按月份统计每月的数据量。
select date_format(create_time,'%Y-%m') k,sum(1) v from t_log_login 
where create_time >= '2019-01-01 00:00:00' and create_time <= '2019-12-31 59:59:59'
group by date_format(create_time,'%Y-%m');