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