SiteServer CMS 6.6.2安装使用mysql时提示“错误! Table 'test.siteserver_table' doesn't exist”

anilyu commented 5 years ago

如题，请问如何解决mysql搭载问题？

环境如下：

版本信息： mysql> status;

C:\Program Files\MySQL\MySQL Server 6.0\bin\mysql.exe Ver 14.15 Distrib 6.0.11-alpha, for Win64 (unknown)

Connection id: 45 Current database: test Current user: myuser@localhost SSL: Not in use Using delimiter: ; Server version: 6.0.11-alpha-community MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: gbk Db characterset: gbk Client characterset: gbk Conn. characterset: gbk TCP port: 3306 Uptime: 2 hours 47 min 0 sec

Threads: 1 Questions: 1572 Slow queries: 0 Opens: 51 Flush tables: 1 Open tables: 7 Queries per second avg: 0.15

用户myuser权限信息： mysql> show grants; +----------------------------------------------------------------------------------------------------------------------- -----------+	Grants for myuser@%

+----------------------------------------------------------------------------------------------------------------------- -----------+	GRANT ALL PRIVILEGES ON . TO 'myuser'@'%' IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF' WITH GR ANT OPTION		GRANT ALL PRIVILEGES ON `mysql`.* TO 'myuser'@'%'
GRANT ALL PRIVILEGES ON `test`.* TO 'myuser'@'%'

+----------------------------------------------------------------------------------------------------------------------- -----------+ 3 rows in set (0.00 sec)

mysql>

anilyu commented 5 years ago

fuck! 更换到mysql5.5 OK了。。。

lpy3654321 commented 4 years ago

之前是mysql-5.5.57-winx64.msi数据库，root帐号没问题，阿里云虚拟主机是的共享数据库是Mysql 5.1.73和MySQL 5.7.25都存在这个问题t。网上说是大小写的问题，可以修改数据库的配置文件解决，但共享数据库不能修改配置文件。现在我是手动把表名都改了，刚才试过可以使用，但有没有潜在问题不知道，正在测试是不是存在其它潜在问题呢。

siteserver / cms

SiteServer CMS 6.6.2安装使用mysql时提示“错误! Table 'test.siteserver_table' doesn't exist” #1473

版本信息： mysql> status;