I hope I have not posted this in the wrong location. While following your instructions at http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-ubuntu-10.10-lamp I had a learning curve. Thank you for providing a good set of instructions. I have played with Linux (Ubuntu) for a very short time. I need a server, so decided to build one. I first loaded the latest Ubuntu (10.10) and then searched for instructions. I tried several and ended up reloading Ubuntu a few times (I have since learned how to un-install things). I found your instructions and loaded MySQL (have not checked it yet), Apache2 (It Works!), PHP5 (Vi was another learning experience, but info.php works). Then I tried to install PHPMyAdmin. First, I made a mistake and said yes to using dbconfig-common for setting up the database. That got me into a loop asking for a password. This is where I learned "apt-get --purge remove phpmyadmin" and again started the phpmyadmin install. This last one appeared to work, but there are no files in the www folder other than info.php and index.html. What should I do now? Should I get the phpmyadmin page from my windows machine (and any supporting php include files)? Should I try another install of phpmyadmin? Is there a file folder I can check to see if the files installed?
The result of ls -la /etc/apache2/conf.d/ is: drwxr-xr-x 2 root root 4096 2011-03-06 21:52 . drwxr-xr-x 7 root root 4096 2011-03-06 16:51 .. -rw-r--r-- 1 root root 269 2010-11-18 16:16 charset lrwxrwxrwx 1 root root 45 2011-03-06 21:52 javascript-common.conf -> /etc/javascript-common/javascript-common.conf -rw-r--r-- 1 root root 3296 2010-11-18 16:16 localized-error-pages -rw-r--r-- 1 root root 143 2010-11-18 16:16 other-vhosts-access-log -rw-r--r-- 1 root root 1481 2010-11-18 16:16 security The output of ls -la /etc/phpmyadmin/ is: drwxr-xr-x 2 root root 4096 2011-03-06 21:52 . drwxr-xr-x 142 root root 12288 2011-03-08 17:45 .. -rw-r--r-- 1 root root 871 2011-02-15 14:04 apache.conf -rw-r----- 1 root www-data 517 2011-03-06 21:52 config-db.php -rw-r--r-- 1 root root 168 2011-02-15 14:04 config.footer.inc.php -rw-r--r-- 1 root root 168 2011-02-15 14:04 config.header.inc.php -rw-r--r-- 1 root root 3918 2011-02-15 14:04 config.inc.php -rw-r----- 1 root www-data 8 2011-03-06 21:52 htpasswd.setup -rw-r--r-- 1 root root 570 2011-02-15 14:04 lighttpd.conf -rw-r--r-- 1 root root 295 2011-02-15 14:04 phpmyadmin.service Hope that provides what you asked for. Bill
Please try this: Code: ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf /etc/init.d/apache2 restart
Falko, Thanks. I know I am getting closer to having things operational. Once I remembered to sudo su, I managed to get to the PHPMyAdmin login. When I tried to login, I received this: #1045 Cannot log in to the MySQL server What do I need to do now? Is there a phpmyadmin config file that I need to edit? Do I need to do something to MySQL? Getting closer one-step-at-a-time.
This is the results: Code: Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 localhost.localdo:mysql *:* LISTEN 1129/mysqld tcp 0 0 localhost.localdoma:ipp *:* LISTEN 1064/cupsd tcp 0 0 server01:46824 yw-in-f164.1e100.ne:www ESTABLISHED 1655/firefox-bin tcp 0 0 server01:50216 yw-in-f139.1e100.ne:www ESTABLISHED 1655/firefox-bin tcp 0 0 server01:55917 74.125.229.28:www ESTABLISHED 1655/firefox-bin tcp 0 0 server01:53277 74.125.229.8:https TIME_WAIT - tcp 0 0 server01:36499 74.125.229.27:www ESTABLISHED 1655/firefox-bin tcp 0 0 server01:43008 a96-6-45-58.deploy.:www ESTABLISHED 1655/firefox-bin tcp 0 28 server01:59142 gx-in-f103.1e100.:https FIN_WAIT1 - tcp 0 0 server01:49306 yi-in-f139.1e100.ne:www ESTABLISHED 1655/firefox-bin tcp 0 0 server01:60233 yw-in-f113.1e100.ne:www ESTABLISHED 1655/firefox-bin tcp 0 0 server01:59136 gx-in-f103.1e100.:https TIME_WAIT - tcp 0 0 server01:60993 gw-in-f139.1e100.ne:www TIME_WAIT - tcp 0 0 server01:36296 74.125.229.29:https TIME_WAIT - tcp 0 0 server01:40484 yx-in-f164.1e100.:https TIME_WAIT - tcp 0 28 server01:40974 gw-in-f120.1e100.:https FIN_WAIT1 - tcp 0 0 server01:34512 yu-in-f155.1e100.ne:www ESTABLISHED 1655/firefox-bin tcp 0 0 server01:59521 gx-in-f103.1e100.ne:www TIME_WAIT - tcp 0 0 server01:59818 yx-in-f83.1e100.n:https ESTABLISHED 1655/firefox-bin tcp 0 0 server01:34522 yu-in-f155.1e100.ne:www ESTABLISHED 1655/firefox-bin tcp 0 28 server01:38296 yw-in-f97.1e100.n:https FIN_WAIT1 - tcp 0 0 server01:43004 a96-6-45-58.deploy.:www ESTABLISHED 1655/firefox-bin tcp 0 0 server01:54113 gx-in-f105.1e100.ne:www TIME_WAIT - tcp 0 0 server01:54111 gx-in-f105.1e100.ne:www ESTABLISHED 1655/firefox-bin tcp 0 28 server01:59076 74.125.229.0:https FIN_WAIT1 - tcp 0 0 server01:59161 gw-in-f18.1e100.n:https ESTABLISHED 1655/firefox-bin tcp6 0 0 [::]:www [::]:* LISTEN 1145/apache2 tcp6 0 0 server01:ipp [::]:* LISTEN 1064/cupsd
Please open /etc/mysql/my.cnf and make MySQL listen on all interfaces (comment out bind-address = 127.0.0.1). Then restart MySQL.
I have modified my.cnf to have # bind-address = 127.0.0.1 I still get the "#1045 Cannot log in to the MySQL server" error when I try to log in to phpmyadmin. Just in case, here is the netstat -tap results: Code: Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:mysql *:* LISTEN 1103/mysqld tcp 0 0 localhost.localdoma:ipp *:* LISTEN 993/cupsd tcp 0 0 server01:60122 gx-in-f17.1e100.n:https ESTABLISHED 1621/firefox-bin tcp 0 1189 server01:50566 gw-in-f104.1e100.ne:www ESTABLISHED 1621/firefox-bin tcp 0 0 server01:34700 gw-in-f83.1e100.n:https ESTABLISHED 1621/firefox-bin tcp 0 0 server01:60123 gx-in-f17.1e100.n:https ESTABLISHED 1621/firefox-bin tcp 0 971 server01:51605 a96-17-147-25.deplo:www ESTABLISHED 1621/firefox-bin tcp6 0 0 [::]:www [::]:* LISTEN 1138/apache2 tcp6 0 0 server01:ipp [::]:* LISTEN 993/cupsd
Maybe that is the issue. I think I set different passwords for PHPMyAdmin and MySQL. Should I be using the same password for both phpmyadmin and mysql? If so, how do I change one or both so they are the same?
