Phpmyadmin-MYSQL管理工具安装

简述:phpMyAdmin 是一个用PHP编写的,可以通过 web 方式控制和操作 MySQL 数据库。通过 phpMyAdmin 可以完全对数据库进行操作,例如建立、复制、删除数据等等。

系统环境:CentOS 5.5 x64

所需软件:

phpMyAdmin-2.11.11-all-languages.tar.gz

mysql-5.0.56.tar.gz

mcrypt-2.6.8.tar.gz

libmcrypt-2.5.8.tar.gz

mhash-0.9.9.9.tar.bz2



MYSQL安装

#####################################

groupadd mysql

useradd -s /sbin/nologin -g mysql -M mysql

tar zxvf mysql-5.0.56.tar.gz

cd mysql-5.0.56

./configure \

--prefix=/usr/local/mysql \

--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \

--localstatedir=/usr/local/mysql/data \

--enable-assembler \

--enable-thread-safe-client \

--with-mysqld-user=mysql \

--with-big-tables \

--without-debug \

--with-pthread \

--enable-assembler \

--with-extra-charsets=complex \

--with-readline \

--with-ssl \

--with-embedded-server \

--enable-local-infile \

--with-plugins=partition,innobase \

--with-plugin-PLUGIN \

--with-mysqld-ldflags=-all-static \

--with-client-ldflags=-all-static
make

make install

cp support-files/my-small.cnf /etc/my.cnf

mkdir -p /usr/local/mysql/data

/usr/local/mysql/bin/mysql_install_db --user=mysql

chgrp -R mysql /usr/local/mysql

/usr/local/mysql/bin/mysqld_safe --user=mysql&

ps -ef |grep mysql

echo "export PATH=$PATH:/usr/local/mysql/bin/">>/etc/profile

source /etc/profile

cp support-files/mysql.server /etc/init.d/mysqld

chmod 755 /etc/init.d/mysqld

chkconfig --add mysqld

service mysqld restart

cd ..



mysqladmin -uroot password elain

mysql -uroot -p

##############################

yum install -y httpd



yum install -y php*



phpMyAdmin安装

wget http://cdnetworks-kr-2.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.3.1/phpMyAdmin-3.4.3.1-all-languages.tar.gz

tar zxvf phpMyAdmin-2.11.11-all-languages.tar.gz



mv phpMyAdmin-2.11.11-all-languages phpmyadmiin

cp -Rf phpmyadmin /var/www/html/



cd /var/www/html/phpmyadmin

cp config.sample.inc.php config.inc.php

vi config.inc.php



17 $cfg['blowfish_secret'] = 'elain';



31 $cfg['Servers'][$i]['host'] = '127.0.0.1';



37 // $cfg['Servers'][$i]['controluser'] = 'root';



38 // $cfg['Servers'][$i]['controlpass'] = 'elain';



修改以上四行即可



重启httpd



用浏览器访问http://ip/phpadmin  

扩展阅读:

http://www.phpmyadmin.net(英文站点)
文章目录
,