My SQL Development

Everyone knows PhpMyAdmin but good ... a little reminder does no harm.

Super software to manage your mysql databases and easier to install:

Download:

Two options available to you.

The first is the best way to always have the latest version (to be in his folder apache DocumentRoot published).

svn checkout https: / / phpmyadmin.svn.sourceforge.net / svnroot / phpmyadmin / tags / STABLE / phpMyAdmin phpMyAdmin-stable
Otherwise second classical solution, download it at this URL: http://www.phpmyadmin.net/home_page/index.php

cd / var / www / or / opt / httpd / htdocs /
# wget http://prdownloads.sourceforge.net/phpmyadmin/phpMyAdmin-3.1.3-all-languages.tar.bz2! md5! 33d703d268ca10e1443896475b09b433
Then unpack the:

tar xvjf phpMyAdmin-3.1.3-all-languages.tar.bz2
ln-s phpMyAdmin-3.1.3-all-languages phpmyadmin
The symbolic link is used to simplify the creation of your vhost if you make one.

You have more's rename the configuration file like below:

cp config.inc.php config.sample.inc.php
vi config.inc.php
search blowfish_secret and put a password between the quotes.

Then go to the url of the genus http://IP my server / phpmyadmin

Advanced:

You can go further! and yes!

Connect to this url: http://localhost/phpmyadmin/setup

The you can create different sessions (users can connect to a particular database but not another or connect to another server mysql etc ...)

If you encounter errors like this:

Warning: Can not modify header information - headers already sent by (output started at / web/www/phpMyAdmin-3.1.3-all-languages/libraries/Error.class.php: 359) in / web/www/phpMyAdmin-3.1. 3-all-languages/libraries/header_http.inc.php on line 22

Edit your php.ini, find the using updatedb and locate or he should be here: / etc / php.ini or: / opt / php / php.ini

Must add your timezone as follows:

Date
; Defines the default timezone used by the date functions
date.timezone = Europe / Paris
If you create other connections / sessions you have this kind of code to add in your config.inc.php:

/ * Server: srvtest: 3309 [1] * /
$ i + +;
$ cfg [ 'Servers'] [$ i] [ 'verbose'] = 'srvtest: 3306';
$ cfg [ 'Servers'] [$ i] [' host '] = '192 .142.121.4';
$ cfg [ 'Servers'] [$ i] [ 'port'] = 3306;
$ cfg [ 'Servers'] [$ i] [ 'socket'] ='';
$ cfg [ 'Servers'] [$ i] [ 'connect_type'] = 'tcp';
$ cfg [ 'Servers'] [$ i] [ 'extension'] = 'mysql';
$ cfg [ 'Servers'] [$ i] [ 'auth_type'] = 'http';
$ cfg [ 'Servers'] [$ i] [ 'user'] = 'foo';
$ cfg [ 'Servers'] [$ i] [ 'password'] ='';

Pages: