Mysql graphical management tool mysqlphpadm installation _ MySQL

Mysql graphical management tool mysqlphpadm install bitsCN.com

Install mysql graphics management tool mysqlphpadm

[Root @ localhost mbstring] # wget http://jaist.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.0.8/phpMyAdmin-4.0.8-all-languages.tar.gz

[Root @ localhost mbstring] # tar xf phpMyAdmin-4.0.8-all-languages.tar.gz-C/www

[Root @ localhost mbstring] # chown daemon. daemon/www/-R

[Root @ localhost mbstring] # service apache restart

Http: // 127.0.0.1/phpadmin/index. php

Error

The mbstring extension is missing. Please check your PHP configuration.

The error is obvious: php module extension. because I have installed php and don't want to re-compile it, I can only dynamically expand it.

[Root @ localhost logs] # cd/usr/src/php-5.3.27/ext/

[Root @ localhost ext] # cd mbstring/

[Root @ localhost mbstring] # phpize ----- generate configure and other files

[Root @ localhost modules] #. /configure -- with-libdir =/usr/local/lib/php/extensions/no-debug-zts-20060613 -- with-php-config =/usr/local/bin/php-config

[Root @ localhost modules] # make & make install

Installing shared extensions:/usr/local/lib/php/extensions/no-debug-zts-20090626/---------- this path is the path for php module extension

Installing header files:/usr/local/include/php/

[Root @ localhost modules] # pwd

/Usr/src/php-5.3.27/ext/mbstring/modules

[Root @ localhost modules] # ls

Mbstring. so

The next step is to modify php. ini.

[Root @ localhost modules] # vi/usr/local/lib/php. ini

Extension = "/usr/local/lib/php/extensions/no-debug-zts-20090626 /"

Extension = mbstring. so

Add these two lines and then restart apache

Access http: // 127.0.0.1/phpadmin/index. php again

Authorize a tt user

Mysql> grant all on *. * to tt @ localhost identified by '20140901 ';

Query OK, 0 rows affected (0.12 sec)

Mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

Log on as an tt user

An error is reported. The mcrypt extension is missing. Check the PHP configuration

It's also a module extension, so make a patch.

[Root @ localhost mcrypt] # pwd

/Usr/src/php-5.3.27/ext/mcrypt

[Root @ localhost mcrypt] # ls

Config. m4 mcrypt. dsp mcrypt. lo tests

Config. w32 mcrypt_filter.c mcrypt. o TODO

CREDITS mcrypt_filter.lo php_mcrypt_filter.h

Mcrypt. c mcrypt_filter.o php_mcrypt.h

[Root @ localhost mcrypt] # phpize; ls

Processing ING:

PHP Api Version: 20090626

Zend Module Api No: 20090626

Zend Extension Api No: 220090626

Acinclude. m4 config. w32 mcrypt. lo

Aclocal. m4 CREDITS mcrypt. o

Autom4te. cache install-sh missing

Build ltmain. sh mkinstalldirs

Config. guess Makefile. global php_mcrypt_filter.h

Config. h. in mcrypt. c php_mcrypt.h

Config. m4 mcrypt. dsp run-tests.php

Config. sub mcrypt_filter.c tests

Configure mcrypt_filter.lo TODO

Configure. in mcrypt_filter.o

Now you can compile it.

[Root @ localhost mcrypt] #./configure -- with-php-config =/usr/local/bin/php-config -- with-mcrypt =/usr

[Root @ localhost mcrypt] # make

[Root @ localhost mcrypt] # make install

Installing shared extensions:/usr/local/lib/php/extensions/no-debug-zts-20090626/

[Root @ localhost mcrypt] # ls modules/

Mcrypt. so

[Root @ localhost mcrypt] # vi/usr/local/lib/php. ini

Extension = mcrypt. so --------------- add this line

The new version of PhpMyAdmin enhances security. you need to set a phrase password in the configuration file. Otherwise, a phrase password is required for the configuration file ." . Solution:

1. in phpMyAdmin/libraries/config. default. php

$ Cfg ['blowfish _ secret '] = ''; change to $ cfg ['blowfish _ secret'] = '000000'; (note: the '200' character is random)

[Root @ localhost libraries] # pwd

/Www/phpadmin/libraries

[Root @ localhost libraries] # vi config. default. php

$ Cfg ['blowfish _ secret'] = '000000 ';

2. in The phpMyAdmin Directory, open config. sample. inc. php, line 18.

$ Cfg ['blowfish _ secret '] = ''; change to $ cfg ['blowfish _ secret'] = '000000'; (note: the '200' character is random)

This password is used to encrypt Cookies to avoid mixing multiple PhpMyAdmin instances or sharing Cookies with other programs.

Do the above two steps, refresh the webpage, and OK, "the configuration file now requires a phrase password ." The prompt does not exist!

This error is not reported after you restart apache.

BitsCN.com