![]() What happens if I Lose my Username/Client ID and/or Password?.Can I Edit my php.ini Settings and/or Switch the version of the PHP?."This domain still has no index.html page uploaded!" and How to Fix it?.How to Upload a Website to Your Hosting Account?.Once I ran sudo apt install phpmyadmin php-mbstring php-gettext, sudo phpenmod mbstring, and sudo phpenmod mbstring phpmyadmin worked perfectly. Then I used sudo apt-get autoremove phpmyadmin & sudo apt-get purge phpmyadmin to get rid of all of the additional packages that were installed. However, this time I selected "NO",when asked if I want to delete the default db's, user privileges, & configurations. Sudo mysql -u root mysql, and GRANT ALL ON *.* TO with GRANT OPTION from the mysql> prompt.ĪT THIS POINT: I decided to completely re-install phpmyadmin because even though I had superuser privileges restored, some of the default installation databases were still missing. Sudo mkdir -v /var/run/mysqld & sudo chown mysql /var/run/mysqldĪfter this command you should be able to re-establish your root user privileges using the following commands: To RE-ESTABLISH the vital directory, use the following command: What happens is that the un-installation process deletes an utterly vital directory necessary for mysql to work properly. ![]() IF YOU SELECT "YES" (cause of problem continued): INSTEAD, select "NO", then un-installation is complete run sudo apt-get autoremove to get rid of the additiona software packages that were installed. DO NOT select the "YES" when myphpmyadmin asks if you want to delete the related db's, user privileges, & configurations. If you are trying to install myphpadmin, run into whatever problems, then decide to completely uninstall phpmyadmin. I have been reading other questions / solutions for 2 days and none of them match my LAMP / OS config with mysql 5.7 and ubuntu 18.04 and the overwhelming assume that the privileges of users work.Īnyone have any ideas how to solve this problem? The sys schema is already up to date (version 1.5.2). Which produced the following results: sudo dpkg-reconfigure mysql-server-5.7 Including running: sudo systemctl stop mysql NOTE: Again, clicking Check privileges only results in a message stating that I have no privileges on the dbs.Īlso inside of phpmyadmin, I do NOT have any Users or Privileges tabs to click on to add users and/or privileges.Īlso, when I log into MySQL from the command line use the commands SHOW GRANTS and SHOW DATABASES for root and phpmyadmin users I get confirmation of the information shown in the screenshots above.ġ.) I installed LAMP via tasksel and confirmed it installed flawlessly with and sudo apache2ctl configtestĢ.) I have completely uninstalled, purged, and reinstalled phpmyadminģ.) I confirmed that apache2 was properly configured to use phpmyadmin via ls /etc/apache2/conf-available/ and ls /etc/apache2/conf-enabled/Ĥ.) I tried every suggested solution listed in reply to similar question found here. When I log into PHPMYADMIN as phpmyadmin user, this is what I see: NOTE: Clicking Check privileges only results in a message confirming no privileges. When I log into PHPMYADMIN via the browser the default dbs are missing are different for each user. PROBLEM DETAILS: I have two mysql users root and phpmyadmin, both should have "superuser" privileges, but each time I try to grant privileges and/or create a DB using either user via mysql, I get the following errors, respectively: GRANT PRIVILEGES: ERROR 1045 (28000): Access denied for user (using password: YES)ĬREATE DATABASE: ERROR 1044 (42000): Access denied for user to database 'wp_db' MySQL 5.7 mysql Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using EditLine wrapper So I can't create my the dbs for wordpress and drupal on my localhost dev server.įresh install Ubuntu 18.04 Linux rider1 5.3.0-53-generic #47~18.04.1-Ubuntu SMP Thu May 7 13:10: x86_64 x86_64 x86_64 GNU/LinuxĪpache2 Server version: Apache/2.4.29 (Ubuntu) PROBLEM: PHPMYADMIN installs flawlessly, but none of my users have even basic permissions (ie drop, create,grant,etc). and no solution seems to work, I am risking a "duplicate post". I have searched previous posts for days now.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |