set @range_id := 90000000;
update TB_Category
set RangeID = (
	select @range_id := @range_id + 1
) order by Id;

See also

• mysql命令行执行sql语句并输出到log
• Mysql5.7 Linux安装
• MySQL+Keepalived高可用
• cluster
• 命令行安装mysql