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

This widget could not be displayed.
Alexey Matveev Community Champion Nov 11, 2017

Hello,

Try this

select * from <confluenceuser>.CWD_USER

This widget could not be displayed.
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

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

401 views 4 6
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