毛卡人的博客

mysql 数据库授权备忘在服务器登录mysqlmysql -u 用户名 -p【然后输入密码即可】查看数据库上所有授权.select * from information_schema.user_privileges;查看权限show grants for ‘用户’@‘IP地址’#查看某个用户的具体授权show grants for ‘用户’@‘IP地址’创建用户#指定ip：192.118.1.1的mjj用户登录create user ‘mjj’@‘192.118.1.

SELECT    UPPER(column_name) AS '字段名称',    column_comment AS '字段描述',    UPPER(column_type) AS '字段类型',    IF(column_key='PRI','TRUE','FALSE') AS '主键唯一',    IF(IS_NULLABLE='NO','TRUE','FALSE') AS '...

按照步骤导出，否则可能报错：ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement第一步：查看表的mysql> show variables like '%secure%';+---------...