Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Exporting user accounts does not contain CREATE USER #17996

Open
rokka opened this issue Dec 29, 2022 · 9 comments · May be fixed by #18550
Open

Exporting user accounts does not contain CREATE USER #17996

rokka opened this issue Dec 29, 2022 · 9 comments · May be fixed by #18550
Labels
affects/5.2 This issue or pull-request affects 5.2.x releases (and maybe further versions) affects/6.0 This issue or pull-request affects 6.0.x releases (and maybe further versions) Bug A problem or regression with an existing feature help wanted

Comments

@rokka
Copy link

rokka commented Dec 29, 2022 •
edited by williamdes

Describe the bug

The function to export a specific mysql user account does only contain the GRANT queries but a CREATE USER query in the begining is missing. This is a problem when importing the users to a MySQL 8 server which requires the CREATE USER query.

To Reproduce

Steps to reproduce the behavior:

  1. Go to 'User accounts' in the top menu
  2. Click on 'Export' on a specific user
  3. See only GRANT queries
@williamdes
Copy link
Member

Hi @rokka
What is the database server version and the phpMyAdmin version?

@williamdes williamdes added the question Used when we need feedback from the submitter or when the issue is a question about PMA label Dec 29, 2022
@rokka
Copy link
Author

rokka commented Dec 29, 2022

Hi,

excuse me.

PhpMyAdmin: 5.2.0
MySQL Server: Server-Version: 5.7.20-19-log - Percona Server (GPL), Release '19', Revision '3c5d3e5d53c'

@williamdes
Copy link
Member

Thank you, we will look into it and let you know :)

@williamdes williamdes added Bug A problem or regression with an existing feature help wanted affects/5.2 This issue or pull-request affects 5.2.x releases (and maybe further versions) affects/6.0 This issue or pull-request affects 6.0.x releases (and maybe further versions) and removed question Used when we need feedback from the submitter or when the issue is a question about PMA labels Dec 29, 2022
@Gemui
Copy link

Gemui commented Jul 12, 2023

@williamdes
Is this bug still exists ?
I can work on it, If there further information could you please provide it .

@williamdes
Copy link
Member

@williamdes Is this bug still exists ? I can work on it, If there further information could you please provide it .

As far as I know, yes
Did you manage to reproduce it on MySQL 5.7.20?

@Gemui
Copy link

Gemui commented Jul 15, 2023

As far as I know, yes Did you manage to reproduce it on MySQL 5.7.20?

Yes I will work to reproduce it on MySQL 5.7.20 also.

@Gemui
Copy link

Gemui commented Jul 15, 2023

@williamdes
The export will be like that

image

Is that satisfied or we need to do some changes ?

@williamdes
Copy link
Member

Let's ask @rokka
Does it work better in 5.2.1?

@Gemui
Copy link

Gemui commented Jul 16, 2023

Let's ask @rokka Does it work better in 5.2.1?

It's a global feature in phpmyadmin not related to this issue only because It doesn't exists in any version, So I am asking is the feature statisted by this way or it need any type of improvement.

@Gemui Gemui linked a pull request Jul 19, 2023 that will close this issue
Open
6 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects/5.2 This issue or pull-request affects 5.2.x releases (and maybe further versions) affects/6.0 This issue or pull-request affects 6.0.x releases (and maybe further versions) Bug A problem or regression with an existing feature help wanted
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

add create user query with exporting data Gemui/phpmyadmin
3 participants
@rokka @williamdes @Gemui