![]() ![]() Restarting the Web ServerĪfter editing the configuration file, you need to restart the web server for the changes to take effect. In Nano, you can do this by pressing Ctrl+X, then Y to confirm saving the changes, and finally Enter to confirm the file name. This line is telling the server to map the URL path /phpmyadmin to the directory /usr/share/phpmyadmin where the phpMyAdmin files are located.Īfter making any necessary changes, save the file and exit the editor. For example: Alias /phpmyadmin /usr/share/phpmyadmin This line should point to the phpMyAdmin directory. In the configuration file, look for the line that starts with Alias /phpmyadmin. Editing the phpMyAdmin Configuration File The nano command opens the Nano text editor, a simple, user-friendly text editor in the terminal. You can edit this file with root authority using the command: sudo nano /etc/phpmyadmin/nf The phpMyAdmin configuration file is typically located at /etc/phpmyadmin/nf. If the server software is running, but you are still unable to access phpMyAdmin, you may need to check the configuration file for phpMyAdmin. Checking the phpMyAdmin Configuration File apache2 and mysql are the names of the services to start. etc/init.d/ is the directory where the service scripts reside. The sudo command is used to run the command as an administrator. ![]() If the server software is not running, you can start them using the following commands: sudo /etc/init.d/apache2 start If you see any output, it means the respective software is running. These commands will list the running processes that contain the words ‘mysql’ and ‘apache’. Open your terminal and type the following commands: ps -ef | grep mysql Editing the phpMyAdmin Configuration Fileīefore we start, ensure that you have the following installed on your Ubuntu system:įirstly, we need to verify if the Apache web server and MySQL are running.Checking the phpMyAdmin Configuration File.In Ubuntu, where should the phpMyAdmin folder be put?Īs it is now, localhost/phpMyAdmin/ leads to the index file of /var/www/html/phpMyAdmin/ and everything is working. What should I have done to make it work Ubuntu-style? Rename the folder phpMyAdmin (get rid of the language part) You should have MySQL server working and have user privileges on a database.ĭelete the existing phpMyadmin folder in /var/www/html/ To get phpMyAdmin working, I did the following: What is necessary to make it work from Ubuntu, without downloading it again? The command line says phpmyadmin is installed and the latest version: > phpmyadmin is already the newest version (4:5.1.1+dfsg1-5ubuntu1). ![]() > thrown in /var/www/html/phpMyAdmin/libraries/classes/Dbi/DbiMysqli.phpĪs root I gave myself all privileges on table user > /var/> PhpMyAdmin\\DatabaseInterface->isSuperuser()\n#5 > PhpMyAdmin\\DatabaseInterface->isUserType()\n#4 > /var/www/html/phpMyAdmin/libraries/classes/DatabaseInterface.php(2332): > PhpMyAdmin\\DatabaseInterface->tryQuery()\n#3 > /var/www/html/phpMyAdmin/libraries/classes/DatabaseInterface.php(2390): ![]() > PhpMyAdmin\\Dbi\\DbiMysqli->realQuery()\n#2 > /var/www/html/phpMyAdmin/libraries/classes/DatabaseInterface.php(316): > /var/www/html/phpMyAdmin/libraries/classes/Dbi/DbiMysqli.php(199): > /var/www/html/phpMyAdmin/libraries/classes/Dbi/DbiMysqli.php:199\nStack > command denied to user for table 'user' in > ::1:37214] PHP Fatal error: Uncaught mysqli_sql_exception: SELECT Attempts to open phpMyAdmin showed a blankpage, or a "connection refused" page.įrom the apache2 error.log: > [client I upgraded from Ubuntu 20.04 to Ubuntu 22.04. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |