Hi guys,

I am brand new to MySQL & just installed it over the weekend on my Macbook which went well without any hicups (fingers crossed).

Now, the next stage was to download & install PHPMyAdmin.

I downloaded it & followed instructions step by step then hit a problem when it came to configuring it.

It asked me to run the setup through my browser by entering:-

http://localhost/~username/phpmyadmin/setup

And I get a page full of errors like this: -

Runtime Notice in ./libraries/common.inc.php#279
date_default_timezone_get() [function.date-default-timezone-get]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for 'BST/1.0/DST' instead

Backtrace

./libraries/common.inc.php#279: date_default_timezone_get()
./setup/lib/common.inc.php#18: require_once(./libraries/common.inc.php)
./setup/index.php#12: require(./setup/lib/common.inc.php)
phpMyAdmin 3.1.5-rc1 setup

Overview
Features
Navigation frame
Main frame
Import
Export
Language

Overview

Bzip2
Bzip2 compression and decompression requires functions (bzopen, bzcompress) which are unavailable on this system.
ZIP
Zip decompression requires functions (zip_open) which are unavailable on this system.
Insecure connection
You are not using a secure connection; all data (including potentially sensitive information, like passwords) is transferred unencrypted! If your server is also configured to accept HTTPS requests follow this link to use a secure connection.
Force SSL connection
This option should be enabled if your web server supports it
Servers

There are no configured servers

Configuration file


Default language
Default server
End of line

phpMyAdmin homepage Donate Check for latest version

Also, when I try to login to phpMyAdmin I get the following error on the login page: -

Cannot load mcrypt extension. Please check your PHP configuration.

I am presuming this is all to do with my php.ini file but any advice to get this corrected would be appreciated.

Thanks.
Lee

    Your PHP.ini file should have a line that says error_reporting. I believe this might be set to "E_ALL". You might want to change it to "E_ALL & ~E_NOTICE" . If you still want all the notices (little warnings that might be helpful as you develop) then you should probably use an .HTACCESS file in your phpMyAdmin folder to set error reporting there. If you choose to try the .htaccess root, you will need to configure apache to allow htaccess files to override the basic apache settings.

    As for mcrypt, you will probably need to compile and install that. There is some helpful information at the php.net site:
    http://us2.php.net/manual/en/mcrypt.requirements.php

      Ok thanks for the reply.

      I have found a site explaining plugging mcrypt into php which I am going to have a read through.

        If your machine is debian or ubuntu, installing mcrypt might be as simple as typing this command:

        apt-get install php5-mcrypt

        or if you have php 4 installed:

        apt-get install php4-mcrypt

        I think Red Hat or CentOS have similar options...like 'yum install php5-mcrypt' or something like that.

          Write a Reply...