mysql phpmyadmin configuration NO PRIVILEGE DATABASE Solved

Question

Hello,  I have uploaded phpMyAdmin on a remote server to facilitate the creation of databases.. When I connect to MyAdmin, I can only log in as "user" (not possible as "root" with or without a password)  And of course, as "user," I cannot create databases due to lack of privileges.. I have searched a bit on other forums and tutorials, but no solution has worked..  Which kind soul would be willing to look into my problem??  Thank you in advance..

zaraki490 · Accepted Answer

Well, you don't have to go far. It happened to me too. The problem comes from the installation of Phpmyadmin.  At the beginning of the install (blue DOS window), it asks you to create an 'admin User'. You need to enter "root" at that point. In fact, Phpmyadmin is not asking you to create a new "Admin User"; it wants to know which "user" it has to deal with. Who is the "su" on the server.  If you indicate something else, don't be surprised if it fails. In short, it is not necessary to uninstall and reinstall everything. As "su" you type in the prompt dpkg-reconfigure Phpmyadmin. It relaunches the blue DOS window.  You indicate the "root" account for all the 'Users' it asks you about. However, when it asks you for the database name, leave it as "Phpmyadmin". I tried to be as clear as possible...  Reload the URL to access your Phpmyadmin back office. Login: root Password: the one you provided. And then you will have all the privileges.

mjmdurand · Answer

Logically, you don't have to upload phpMyAdmin; it's the host that provides it, and when that's the case, you have the appropriate privileges.  If it's not too personal, which host?

-CCM- · Answer

hi my host .... well, myself, I have my own server.

-CCM- · Answer

1- I reinstalled my phpMyAdmin again by downloading it from the official site -->https://www.phpmyadmin.net/downloads/  2- upload the unzipped folder. 3- then modify the file name from config.sample.inc.php to config.inc.php 4- add a line "blowfish_secret": $cfg['blowfish_secret'] = '*****'  that's it! still the same, I have access without rights with any username, but as root with or without a password, no access :s  Where would the error come from? Which file is misconfigured?  I even tried adding  $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = '';  to my conf.inc.php but it doesn't change anything...  HELP

mjmdurand · Answer

Uh, it could be a restriction from the server provider; indeed, if root were allowed, anyone could connect with that login.  Go look here to modify the privileges:  http://pagesperso-orange.fr/philippe.baucour/pratiquer/mysql/configurationeasyphp.html  Maybe that will help you...

-CCM- · Answer

Uh, it could be a restriction from the server provider,  Hi, it's MY server ;) I have no restrictions, it's mine, I connect as root and it's the same access denied...     root@server:/home/user1/Desktop# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) root@server:/home/user1/Desktop# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)   For the link, thanks ;) I already had it in my favorites. I don't have a button----> Click on "Users and Privileges"   And in the console, I have the above messages!   :(

mjmdurand · Answer

ah... if you don't have the button, it gets annoying...

-CCM- · Answer

Where would it come from? At worst, I reinstall MySQL???

mjmdurand · Answer

uhh... there, I'm not really sure what to reply...  It might be because you haven't installed all the necessary PHP modules like Apache...  I don't know!!! I'm just suggesting!!!  Anyway, it's definitely easier when you have a host.

-CCM- · Answer

Hi, my problem is solved....  It's quite complicated to understand... pretty twisted!  In my privilege table, I had a particular configuration...  Allow everyone EXCEPT root to connect with no privileges. For root --> there is no account for him!!  Basically, I could have spent 10 years on this and nothing would have changed; without privileges or a root account, I couldn't grant privileges to my users or to myself...  Don't ask me where this twisted configuration came from, even I don't know!!  I had to reset the parameters to default... (I don't remember which command line) I wasn't aware of this command.  All my privileges were erased, and a root with all privileges was set by default :)  Everything is fine now...  Anyway, thanks to you mjmdurand and the others for the help and participation.  That's nice :) !!

Ben · Answer

Hi!  It would have been great if you had added the magic command, it might be useful for others! And maybe for me as well! :o)  Thanks

bgates · Answer

Hi  Here's how I was able to recover my rights without getting the 10045 Access denied error anymore  # mysql mysql -p  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;  FLUSH PRIVILEGES;  GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;  FLUSH PRIVILEGES;  GRANT ALL PRIVILEGES ON *.* TO 'root'@'mypc' WITH GRANT OPTION;  FLUSH PRIVILEGES;  quit; #  ... but I still did some searching though

zaz_louz · Answer

just enter the name of the database as well  mysql name_db -u root -p < nomdufichier.sql

mano93 · Answer

Hello everyone,  I had the same issue, actually you shouldn't log in with the "pma" account as indicated but with your "root" account (on Linux), and everything should be fine, hoping to help a bit! See you!

arno · Answer

Thank you, that helped me a lot!

gueyome · Answer

For those who still have the issue, you need to change the root password through ovhm/domain management/mysql.

pazz · Answer

Personally, I had a problem creating and opening databases and I noticed that it was because I was using Safari and that it's strangely not compatible, so I tested it on Firefox and there were no issues, no more errors.  I hope this can help someone ;)

Mysql phpmyadmin configuration NO PRIVILEGE DATABASE

18 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

My livebox is no longer detected

Magic game encyclopedia

Bank account charged but aliexpress order not found.

Can there be fake players in scrabble go?

My samsung galaxy tab 3 won't turn on and won't charge.

Philips sbc headphones batteries

Dhgate, reliable site or not?

Universal remote control temium remo3/1 code