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
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,167 views 2 13
Read article

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