PhpMyAdmin installation tips

The installation of phpMyAdmin is not a problem because a specific php environment has been set up on that day. of course, phpmyadmin is used to manage mysql databases. Today, phpmyadmin is downloaded from the official website, then, the debian server was hit through ftp, and some problems were encountered during the installation, which took some effort and turned to the google phpMyAdmin installation minor problem.

I have set up a specific php environment that day. of course, I want to use phpmyadmin to manage the mysql database. today I downloaded phpmyadmin from the official website and then played it to debian through ftp, I encountered some problems during the installation, and it took a lot of effort to turn to google and solve the problem smoothly. I wrote down the process and shared it.

It is still in the/etc/lighttpd of lighttpd. the virtual directory of phpmyadmin is added to the conf file. the configuration of lighttpd is not like that of apache. it is OK to add it directly in the backend. I started to do the same. The result is wrong and I am wondering for a long time, later I found out that:

Alias. url + = ("/phpmyadmin/" => "/var/www/phpmyadmin /")

Add a plus sign before the equal sign. this is indeed different from other ones, haha.

After the virtual directory is configured, decompress the phpmyadmin file to your/var/www/phpmyadmin file. then, manually configure phpmyadmin and find the config in The phpmyadmin folder. sample. inc. php, use this command to change the name:

Mv config. sample. inc. php config. inc. php

Edit config. inc. php and use vi .. This is random. Next, pay attention to it. find $ cfg ['blowfish _ secret'] and set a random password after the equal sign. this is not very important, but it must be set, otherwise, you cannot use phpmyadmin.

See my phpmyadmin configuration file on this machine:

/* Authentication type */
$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker'; if it is your cgi, use cookie
/* Server parameters */
$ Cfg ['servers'] [$ I] ['host'] = 'localhost ';
$ Cfg ['servers'] [$ I] ['connect _ type'] = 'tcp ';
$ Cfg ['servers'] [$ I] ['compus'] = false;
/* Select mysqli if your server has it */
$ Cfg ['servers'] [$ I] ['extension'] = 'mysql ';
/* User for advanced features */
$ Cfg ['servers'] [$ I] ['controluser'] = ''; neither user nor passwd is added by default.
$ Cfg ['servers'] [$ I] ['controlpass'] = '';
/* Advanced phpMyAdmin features */
$ Cfg ['servers'] [$ I] ['pmadb'] = 'phpmyadmin ';

?

Basically according to the above configuration, there will be no major problems, there will be no 1043 Ah, I began to encounter many 1043 problems, the configuration is not wrong .. Then, the local cookie is cleared and the access is OK .. Pay attention to this ..

Another small problem is that the system prompts that mcrypt is not supported during login. later, it was found that this so was not installed... You as long as aptitude install php5-mcrypt is OK, debian will be automatically configured, you do not need to modify php. ini, and then you can smoothly use phpmyadmin ..

?