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 vote
Alexey Matveev Community Champion Nov 11, 2017

Hello,

Try this

select * from <confluenceuser>.CWD_USER

0 vote
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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Friday in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

262 views 11 10
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