#776 Cannot create user and privileges

[David Spector]

I am just a beginner to MySQL and Adminer. I successfully run Adminer against my WAMP installation (Windows/Apache/MySQL). I have successfully used phpmyadmin.php, but was bothered by its extreme slowness.

I first tried to create a user in the correct DB, but got an error message. So I selected the root and tried to create a user there. Got an error message. I think somehow I accidentally edited the root user and turned off Granting, so now I'm continuing to get error messages no matter what I try.

Should I drop all the MySQL databases and try starting over somehow?

I am very confused and hope you will be gentle with me. I did try to look at the MySQL manual, but I cannot understand anything it says about users or privileges.

Do I need a tutorial, or just to fix a problem? Are there easy tutorials for creating a new user?

I need the user because I don't want to use "root" for my PHP program that updates a database for my nonprofit charity.

[David Spector]

I have been successful in fixing my root and user using phpmyadmin.php. That program, although slow, gives much better guidance for beginners than does adminer. I could click on User Accounts and see clearly the problems, and had no trouble fixing them. I will keep Adminer around if I am sure I know what I'm doing, but it does not supply defauilt values and otherwise help beginners the way phpmyadmin.php does. In my opinion, there is still a need for a good alternative to phpmyadmin. Also, your user interface has much smaller text and is not as nice looking. You have sacrificed way too much that is necessary in a user interface in order to gain speed, IMO.

[Stephan]

I first tried to create a user in the correct DB, but got an error message. So I selected the root and tried to create a user there. Got an error message. I think somehow I accidentally edited the root user and turned off Granting, so now I'm continuing to get error messages no matter what I try.

What error messages did you get? You should always provide exact descriptions of your set-up, your process, and the error messages. Otherwise, no one can help you

phpmyadmin.php

If that works for you, this is fine. Go on with it. But in comparison to Adminer, phpMyAdmin is a bloated mess. The download of version 5 is about 14 MB. Adminer for MySQL is about 0.35MB.

The interface of adminer is by far easier to understand and is highly customizable with a number of themes. And there are more security issues in phpMyAdmin in comparison to Adminer.

https://www.phpmyadmin.net/security/

But security of phpMyAdmin improved in the last years.

[David Spector]

Dear Stephan,

Thank you for your feedback. I will try adminer again when I next need
to do admin work on my DB. It is certainly fast.

David

[David Spector]

Just to let you know that this IS adminer related, since I solved the
problem by using phpmyadmin.

David Spector

On 2/7/2021 3:08 AM, "Jakub Vrána" wrote:

• status: open --> closed-rejected
• Comment:

This is not Adminer related.

---

[bugs-and-features:#776]
https://sourceforge.net/p/adminer/bugs-and-features/776/ Cannot create
user and privileges

Status: closed-rejected
Group: Git
Created: Mon Jan 04, 2021 04:42 PM UTC by David Spector
Last Updated: Mon Jan 25, 2021 10:27 AM UTC
Owner: nobody

I am just a beginner to MySQL and Adminer. I successfully run Adminer
against my WAMP installation (Windows/Apache/MySQL). I have successfully
used phpmyadmin.php, but was bothered by its extreme slowness.

I first tried to create a user in the correct DB, but got an error
message. So I selected the root and tried to create a user there. Got an
error message. I think somehow I accidentally edited the root user and
turned off Granting, so now I'm continuing to get error messages no
matter what I try.

Should I drop all the MySQL databases and try starting over somehow?

I am very confused and hope you will be gentle with me. I did try to
look at the MySQL manual, but I cannot understand anything it says about
users or privileges.

Do I need a tutorial, or just to fix a problem? Are there easy tutorials
for creating a new user?

I need the user because I don't want to use "root" for my PHP program
that updates a database for my nonprofit charity.

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/adminer/bugs-and-features/776/
https://sourceforge.net/p/adminer/bugs-and-features/776/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/
https://sourceforge.net/auth/subscriptions/

[Jakub Vrána]

This is not Adminer related.