我运行的是MariaDBforOSX10.13的MySQL Ver15.1Distrib10.3.9,有很多用户(大约14个)的用户名显然太长了,请看下面的内容。
MariaDB [(none)]> SELECT Host, User FROM mysql.user;
+-----------+-------------------------+
| Host | User |
+-----------+-------------------------+
| 127.0.0.1 | tenant_2SxSBywyXh3QW5L4 |
| 127.0.0.1 | tenant_4j3CWVXjgtDD2OrI |
| 127.0.0.1 | tenant_5OOBxRgjSvFehwI2 |
| 127.0.0.1 | tenant_6C3vAqBTVns8rMTT |
| 127.0.0.1 | tenant_9PVCY1Msa61u43Oh |
| 127.0.0.1 | tenant_RyFspluIGEi3Fkby |
| 127.0.0.1 | tenant_SQtfEQZmWRFfKmHy |
| 127.0.0.1 | tenant_VC8pYaJ3it1LdYK3 |
| 127.0.0.1 | tenant_Zr84h3vkLdwkqR33 |
| 127.0.0.1 | tenant_cvifD1I2Rjghjnpu |
| 127.0.0.1 | tenant_jO1tUJJokremTW5P |
| 127.0.0.1 | tenant_p6Bhzhi0OqMH4gc9 |
| 127.0.0.1 | tenant_rjyOX1NqEN6k6mk4 |
| 127.0.0.1 | tenant_xfcHjsn0mHBfURAw |
| 127.0.0.1 | test_testing_local |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+-------------------------+
18 rows in set (0.000 sec)
当我尝试使用下面的命令删除这些用户时,我遇到了这个错误:
MariaDB [(none)]> DROP USER 'tenant_5OOBxRgjSvFehwI2@127.0.0.1';
ERROR 1470 (HY000): String 'tenant_5OOBxRgjSvFehwI2@127.0.0.1' is too long for user name (should be no longer than 32)
MariaDB [(none)]> DROP USER 'tenant_5OOBxRgjSvFehwI2@localhost';
ERROR 1470 (HY000): String 'tenant_5OOBxRgjSvFehwI2@localhost' is too long for user name (should be no longer than 32)
有没有关于如何删除这些用户的想法?
最烦人的副作用是在打开SequalPro时,我收到14个错误(一个接一个),通知我这个用户名太长了。
另外,我想知道的另一个奇怪的问题是,为什么当这些用户名只有22-24个字符时,它们会导致……用户名太长(应该不超过32)错误,因为他们没有违反32个字符的限制?
感谢任何帮助:)
发布于 2018-12-19 08:21:28
您可以尝试多个选项。可以尝试最新的SequelPro测试版本。测试构建(3477d22)似乎为我解决了长名称问题。测试版本在这里:https://sequelpro.com/test-builds
或者是最新的开发版本。对于我来说,使用Mariadb10.x服务器和夜间构建的http://nightly.sequelpro.com/也适用于我。
发布于 2018-12-19 08:21:20
你必须注释'username‘@ 'host’...
使用:
DROP USER 'tenant_5OOBxRgjSvFehwI2'@'127.0.0.1';
发布于 2018-12-23 17:19:36
我无法重现这个问题:
MariaDB [(none)]> SELECT VERSION();
+-----------------+
| VERSION() |
+-----------------+
| 10.3.11-MariaDB |
+-----------------+
1 row in set (0.000 sec)
MariaDB [(none)]> DESC mysql.user; -- User char(80)
+------------------------+-----------------------------------+------+-----+----------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+----------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(80) | NO | PRI | | |
.
.
.
+------------------------+-----------------------------------+------+-----+----------+-------+
47 rows in set (0.001 sec)
MariaDB [(none)]> CREATE USER 'tenant_5OOBxRgjSvFehwI2'@'127.0.0.1';
Query OK, 0 rows affected (0.001 sec)
MariaDB [(none)]> DROP USER 'tenant_5OOBxRgjSvFehwI2@127.0.0.1';
ERROR 1396 (HY000): Operation DROP USER failed for 'tenant_5OOBxRgjSvFehwI2@127.0.0.1'@'%'
MariaDB [(none)]> DROP USER 'tenant_5OOBxRgjSvFehwI2I'@'127.0.0.1'; -- Wrong user
ERROR 1396 (HY000): Operation DROP USER failed for 'tenant_5OOBxRgjSvFehwI2I'@'127.0.0.1'
MariaDB [(none)]> DROP USER 'tenant_5OOBxRgjSvFehwI2'@'127.0.0.1';
Query OK, 0 rows affected (0.001 sec)
https://stackoverflow.com/questions/53842881
复制相似问题