Syntax Error MySQL Find User in CWD_User table

Question

Hey guys, I'm on my first steps to configure confluence on a own server. Because of that I have a Noobie question. I want to find all user in the CWD_User table , but I have the follwing problem in the console: - mysql> /database SELECT * FROM cwd_user; - ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/database SELECT * FROM cwd_user' at line 1 - mysql> /database -> select * from CWD_USER; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/database select * from CWD_USER' at line 1 It seems, that mysql can find the database, but what is wrong in this sql statement? Thanks for help and greetz Philipp

AnnWorley · Answer

Hi Philipp,

The database directory in the Confluence home directory is related to the non-production evaluation database bundled with Confluence. If you are using MySQL, you don't need to concern yourself with it.

At your MySQL prompt, please type:

use Confluence

Then go ahead and type:

select * from cwd_user;

I look forward to hearing whether this works for you.

Thanks,

Ann

Alexey Matveev · Answer

Hello,

Try this

select * from <confluenceuser>.CWD_USER