UPDATE mysql.user SET authentication_string = PASSWORD('Root123A'), password_expired = 'N' WHERE User = 'root' AND Host = 'localhost';
flush privileges;
quit;
这样就将mysql root用户的默认密码修改成了Root123A
如果是5.7以前的用户可以尝试使用:
update msyql.user set password=password("Root123A") where user="root";
flush privileges;
quit;
CREATE procedure proc_update_use_arr(myID BIGINT(10))
BEGIN
DECLARE arr VARCHAR(100);
DECLARE arr_flag INT;
DECLARE index_a INT;
DECLARE num INT;
SET arr = '1,2,3,4,5';
SET arr_flag = 1;
SET index_a = 1 ;
WHILE arr_flag <= 5 DO
SET num = substring_index(substring_index(arr,',',index_a),',',-1);
SET index_a = index_a + 1 ;
SET arr_flag = arr_flag + 1;
INSERT INTO b(id,num) VALUES(arr_flag,num);
END WHILE;
COMMIT;
END$$
近期评论