1、今天做项目遇到了gorm 用结构体映射会给表自动加s或者es的问题
虽然可以根据报错信息去修改数据表名解决,但这样也不是办法
解决办法:
type UserTest struct {
Name string `json:"name" form:"name" gorm:"name:name"` // 用户名
Age string `json:"age" form:"age" gorm:"comment:age"` // 用户手机号
Sex uint `json:"sex" form:"sex" gorm:"comment:sex"` // 性别
}
// TableName 解决gorm表明映射
func (UserTest) TableName() string {
return "user_test"
}
2 、解决mysql新增数据id自增不连续问题
Navicat Premium中运行下边命令:
alter table 表名 auto_increment = 1
3、远程连接数据库报错:1130-Host ‘xxx’ is not allowed to connect to this MySQL server问题
运行下边命令后
INSERT INTO `mysql`.`user`(`Host`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `Create_tablespace_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`, `plugin`, `authentication_string`, `password_expired`, `password_last_changed`, `password_lifetime`, `account_locked`) VALUES ('%', 'root', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9', 'N', '2022-07-05 15:10:20', NULL, 'N');
刷新
flush privileges;