- 博客(4)
- 收藏
- 关注
原创 yum 方式安装mysql (完整记录)
一、检查系统是否安装老版本,有的话干掉#yum list installed | grep mysqlmysql-libs.x86_64 5.1.73-5.el6_6 @anaconda-CentOS-201508042137.x86_64/6.7#yum -y remove mysql-libs.x86_64二、安装及配置# wget http://repo.mysql...
2020-03-26 14:57:02
69
原创 Mysql用户权限
grantgrant all privileges on . to oldboy@’10.0.0.%’ identified by ‘123’;权限 all (privileges)所有库.所有表*.*mysql.*mysql.user针对某个字段进行脱敏处理create table stu(id int,name varchar(10),c...
2020-03-19 16:34:11
46
原创 MySQL 忘记密码
#MySQL忘记root密码一:update方式:1.停库/etc/init.d/mysql stop2.跳过授权表,跳过网络启动MySQLmysql_safe --skip-grant-tables --skip-networking &3.免密登陆MySQLmysql4.修改root@'localhost’密码update mysql.user set passwor...
2020-03-19 14:49:15
51
原创 编译安装mysql
编译安装MYSQL1.现在MYSQL包2.安装epel源wget -O /etc/yum.repos.d/epel.repo https://mirrors.aliyun.com/repo/epel-6.repo3.安装依赖包yum install -y ncurses-devel libaio-devel make autoconf automake curl curl-devel ...
2020-03-18 15:44:50
82
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人