![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
华丽转身Kiss
咸鱼一小块
展开
-
MySQL column Type存储最大长度
在SpringBoot项目中进行数据库数据插入操作时,报出以下异常: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [insert into work_flow_log(model_name,obj_id,uid,action_name,action_parameters) valu...原创 2019-05-21 12:50:17 · 846 阅读 · 0 评论 -
MySQL:Create user with a password but when logining no password is needed.
Just because there are anonymous user which column ‘User’ is ‘’. Do as following: (1)Delete all anonymous user. mysql[mysql]> delete from user where user=''; (2)Flush privileges. mysql> flush p...原创 2019-07-12 18:36:05 · 303 阅读 · 0 评论 -
MySQL create readonly account
First, create a account: mysql> CREATE USER 'readonly'@'%' IDENTIFIED BY 'readonly'; Then, grant select privilige to the user above: mysql> GRANT SELECT ON *.* TO 'readonly'@'%';原创 2019-07-10 11:44:52 · 134 阅读 · 0 评论