Syntax Error MySQL Find User in CWD_User table

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> <confluence-home-directory>/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 '<confluence-home-directory>/database SELECT * FROM cwd_user' at line 1
 - mysql> <confluence-home-directory>/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 '<confluence-home-directory>/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

2 answers

0 votes

Hello,

Try this

select * from <confluenceuser>.CWD_USER

0 votes
Ann Worley Atlassian Team Nov 21, 2017

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

56 views 3 2
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you