Minor installation problems with phpMyAdmin
Not that day set up the specific PHP environment, of course, to use phpMyAdmin to manage the MySQL database, today to the official website to download the phpMyAdmin, and then through the FTP to the Debian, the installation of the time also encountered some problems, and took a lot of effort, Turn to Google God, the problem is a smooth solution, I will drop the process to write down, share.
Still in Lighttpd's/etc/lighttpd/. lighttpd.conf add phpmyadmin virtual directory, how to say, lighttpd configuration is not like Apache, is directly in the back add on OK, I began to do so, the result is wrong, puzzled half a day, later found to this:
Alias.url + = ("/phpmyadmin/" = "/var/www/phpmyadmin/")
is to precede the equal sign with the + number, this and the other is really different, haha.
The virtual directory is configured, the files in the phpMyAdmin are extracted to your/var/www/phpmyadmin, and then, you will manually configure the next phpMyAdmin, We found the config.sample.inc.php under the phpMyAdmin folder and changed the name with this command:
MV Config.sample.inc.php config.inc.php
Then edit this config.inc.php, use VI Bar. This random, then, you have to pay attention to find $cfg[' Blowfish_secret ' this line, after the equal sign set a random password, this is not very important, but must be set, otherwise, you can not use phpMyAdmin.
Please look at my phpMyAdmin profile on this machine:
/* Authentication type */
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; If it's your CGI, use cookies.
/* Server Parameters */
$cfg [' Servers '] [$i] [' host '] = ' localhost ';
$cfg [' Servers '] [$i] [' connect_type '] = ' TCP ';
$cfg [' Servers '] [$i] [' compress '] = false;
/* Select mysqli If your server has it */
$cfg [' Servers '] [$i] [' extension '] = ' mysql ';
/* User for Advanced features */
$cfg [' Servers '] [$i] [' controluser '] = '; USER,PASSWD I have not added by default
$cfg [' Servers '] [$i] [' controlpass '] = ';
/* Advanced phpMyAdmin Features */
$cfg [' Servers '] [$i] [' pmadb '] = ' phpmyadmin ';
?
Basic according to the above configuration, there will not be too much problem, there will be no 1043 ah, I began to encounter a lot of 1043 problems, configuration is not wrong. Then I emptied the cookie of the machine, then the visit was no problem. Let's take a look here.
There is a small problem is landing when the hint did not support MCrypt,, and later found that it is not installed on the so ... You just aptitude install php5-mcrypt OK, Debian will be automatically configured, do not need you to modify php.ini, and then you can use phpmyadmin smoothly.
?