mysql用户名长度_如何增加PhpMyAdmin / mysql用户帐户的用户名长度？

ALTER TABLE t1 MODIFY col1 VARCHAR(2000);

如果是MySQL的User表,则以root身份登录

mysql --user=root mysql -pPASSWORD

ALTER TABLE user MODIFY user CHAR(100);

commit;

以上不推荐

感谢您的反馈.我已经尝试了上述内容,并且可以成功更改列用户.但是,MySQL手册警告它

MySQL user names can be up to 16 characters long. Changing the maximum length is not supported. If you try to change it, for example by changing the length of the User column in the mysql database tables, this will result in unpredictable behavior. (Altering privilege tables is not supported in any case.) Operating system user names might have a different maximum length. For example, Unix user names typically are limited to eight characters.

谢谢@BoltClock提及它.

总结

以上是生活随笔为你收集整理的mysql用户名长度_如何增加PhpMyAdmin / mysql用户帐户的用户名长度？的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。