I just finished installing mysql-server, and then installed phpmyadmin which came with Apache and PHP. It set it up alright and made a phpMyAdmin database, but I can't seem to find the URL to get t...
I've installed phpmyadmin sudo apt-get install phpmyadmin. Of course, I have also mysql and a web server running properly. Now how can I reach it?
run the command: sudo dpkg-reconfigure phpmyadmin You need to reconfigure it because lamp and xampp run phpmyadmin in different ports. So, it is probably a port conflict. You can also open server.xml in your lampp and change the port no. which would be different from that of xampp. Then both MySQL (of xampp and lamp as well) will run.
I can not, however, drop by typing the SQL directly. I can drop a database from the command prompt, no problems There is one particular database that seems to be screwed up. If I try to DROP from the command prompt, it says it has lost connection to the server. If I try from within PHPMyadmin, it errors out and logs me out instantly.
Network World: WampServer delivers a smart, Windows-friendly platform for Apache, MySQL and PHP-based apps
WampServer delivers a smart, Windows-friendly platform for Apache, MySQL and PHP-based apps
To fix it, I found the config-db.php file in /etc/phpmyadmin/ and got the password from there. Root access to PHPMyAdmin was working, so I logged in as root to PHPMyAdmin and used the query SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD([copy and paste the password here]) and it worked!
Alternatively, you could restrict Phpmyadmin to only one specific port by creating a Phpmyadmin version host and use the Listen 99 directive to that virtual host. Details for creating a virtual host for Apache2 can be found here: Make a symbolic link to /usr/share/phpmyadmin the virtualhost document root.