热门关键字:  ubuntu  分区  函数  Fedora  linux系统进程

用phpMyAdmin让MySQL数据库管理温和化

来源: 作者: 时间:2008-08-14 Tag: 点击:
用phpMyAdmin让MySQL数据库管理温和化

前  言

  这里所说的“温和化”不如说成“大众化”…

  这一节介绍通过phpMyAdmin这个工具实现用浏览器来管理服务器MySQL的方法。

  但phpMyAdmin存在的意义只是为了让MySQL的管理变的让非专业人士更容易理解,其实质还是SQL命令的执行。在构建MySQL数据库服务器中,对SQL命令的初级做了简单的演习。

前言以下灰字部分为选读,如您时间宝贵,不读也不会妨碍您phpMyAdmin的安装与配置。

安装 phpMyAdmin

  首先下载phpMyAdmin,并安装。

[root@sample ~]# wget http://jaist.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.7.0-pl2.tar.gz ← 下载phpMyAdmin(连续输入,无换行)

--04:24:57-- http://jaist.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.7.0-pl2.tar.gz
=> `phpMyAdmin-2.7.0-pl2.tar.gz.1'
Resolving jaist.dl.sourceforge.net... 150.65.7.130
Connecting to jaist.dl.sourceforge.net|150.65.7.130|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3,355,025 (3.2M) [application/x-gzip]

100%[====================================>] 3,355,025 274.27K/s ETA 00:00
04:25:07 (345.11 KB/s) - `phpMyAdmin-2.7.0-pl2.tar.gz.1' saved [3355025/3355025]

[root@sample ~]# tar zxvf phpMyAdmin-2.7.0-pl2.tar.gz ← 展开被压缩的tar文件

[root@sample ~]# mv phpMyAdmin-2.7.0-pl2/ /var/www/phpmyadmin ← 移动到相应目录下

[root@sample ~]# rm -f phpMyAdmin-2.7.0-pl2.tar.gz ← 删除遗留的源代码文件

  然后,安装php-mbstring,让phpmyadmin能够正确识别字符串。

[root@sample ~]# yum -y install php-mbstring ← 在线安装php-mbstring

Setting up Install Process
Setting up repositories
dag 100% |=========================| 1.1 kB 00:00
update 100% |=========================| 951 B 00:00
base 100% |=========================| 1.1 kB 00:00
addons 100% |=========================| 951 B 00:00
extras 100% |=========================| 1.1 kB 00:00
Reading repository metadata in from local files
primary.xml.gz 100% |=========================| 25 kB 00:00
extras : ################################################## 98/98
Added 1 new packages, deleted 0 old in 0.48 seconds
Reducing Dag RPM Repository for Red Hat Enterprise Linux to included packages only
Finished
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for php-mbstring to pack into transaction set.
php-mbstring-4.3.9-3.15.i 100% |=========================| 18 kB 00:00
---> Package php-mbstring.i386 0:4.3.9-3.15 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
php-mbstring i386 4.3.9-3.15 base 920 k

Transaction Summary
=============================================================================
Install 1 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 920 k
Downloading Packages:
(1/1): php-mbstring-4.3.9 100% |=========================| 920 kB 00:01
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: php-mbstring ######################### [1/1]
Installed: php-mbstring.i386 0:4.3.9-3.15
Complete!

配置 phpMyAdmin
最新评论共有 0 位网友发表了评论
发表评论
评论内容:不能超过250字,需审核,请自觉遵守互联网相关政策法规。
用户名: 密码:
匿名?
注册