Ubuntu – Phptheadmin 404 error on fresh ubuntu 12.04 install

12.04lampMySQLphpmyadminvirtualbox

I regularly set up Virtualbox ubuntu setups to run as local webservers. I have set these up several times and never had an issue. However, something has changed:

1)VB guest additions no longer allow me to copy and paste (I'll worry about that later)

2)More importantly phpmyadmin no longer works as installed – Initially going to localhost/phpmyadmin gave a message that the page could not be found. So I have followed some instructions which told me to do the following in var/www:

sudo ln -s /usr/share/phpmyadmin phpmyadmin

which has created a phpmyadmin directory in /var/www but now I get an error saying:

the mysqli extension is missing.

If I run phpinfo mysql and mysqli are listed.

All I have done so far is

sudo apt-get update  
sudo apt-get install apache2
sudo apt-get install php5
sudo apt-get install mysql-server

and

sudo apt-get install phpmyadmin

I found a post of a similar question which suggested I should do

sudo apt-get install php5-mysql

(I've done this) and edit php.ini and uncomment the line:

extension=mysqli.so

This is not there, so I tried adding it but no joy. I have restarted apache and still no phpmyadmin.

I'm running a windows 7 machine and the guest os is ubuntu 12.04

Best Answer

Ok I have found the answer to this.

Dont do this step (not needed):

sudo ln -s /usr/share/phpmyadmin phpmyadmin

Dont do this step (not needed):

edit php.ini and uncomment the line:

extension=mysqli.so

Do do this:

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf

Apparently this serves to "symlink the phpMyAdmin conf file within the apache2/conf.d/" courtesy of pete fisher: http://blog.peterfisher.me.uk/2012/06/27/solution-to-phpmyadmin-throwing-a-404-error/

Related Solutions

Ubuntu – Mysqli for PHP in package thesql

From the description of the package php5-mysql(version 5.3.10-1ubuntu3.2) :

This package provides modules for MySQL database connections directly from PHP scripts. It includes the generic "mysql" module which can be used to connect to all versions of MySQL, an improved "mysqli" module for MySQL version 4.1 or later, and the pdo_mysql module for use with the PHP Data Object extension.

So, the package php5-mysql does contain support for MYSQLi extension.

Ubuntu – phptheadmin throws a 404 on opening

Maybe it is an apache permission problem. Try to put in your /etc/apache2/sites-available/default the following lines

<Directory /> AllowOverride All </Directory>

and check that the /var/www folders owner is www-data

==================================================================================

Install mysql server: sudo apt-get install mysql-server

Here the installer will ask the mysql-server root password

Install apache 2: sudo apt-get install apache2

Test it: localhost (You must see "It works!" etc)

Install php5: sudo apt-get install php5

sudo apt-get install libapache2-mod-php5

sudo /etc/init.d/apache2 restart

Testing it: create the file php_info.php in /var/www/

The content of the file: <?php phpinfo(); ?>

Install php modules: sudo apt-get install php-pear php5-gd php5-xsl curl libcurl3 libcurl3-dev php5-curl

Connect apache 2 and mysql together: sudo apt-get install libapache2-mod-auth-mysql

Install phpmyadmin:

`sudo apt-get install php5-mysql`
`sudo apt-get install phpmyadmin`

Connect php5 with mysql server:

Edit the file /etc/php/apache2/php.ini

Uncomment the following line: extension=mysql.so

Restart apache: service apache2 restart

Try phpmyadmin: localhost/phpmyadmin/

This worked for me many times.

Best Answer

Related Solutions

Ubuntu – Mysqli for PHP in package thesql

Ubuntu – phptheadmin throws a 404 on opening

Related Question