phpmyadmin
来源:互联网 发布:淘宝匡威正品店 编辑:程序博客网 时间:2024/06/06 19:50
1:概念
phpmyadmin是一种网络应答式的数据管理系统,在其上面我们可以那里不会点那里的生成我们所需要的代码,也具有很多的功能等待我们去开发。首先,我们看一下他的安装和配置。
2:安装
1:先安装httpd,保证能共享在局域网上。
[root@localhost ~]# yum install httpd -yLoaded plugins: langpacksrhel_dvd | 4.1 kB 00:00 Resolving Dependencies--> Running transaction check---> Package httpd.x86_64 0:2.4.6-17.el7 will be installed--> Processing Dependency: httpd-tools = 2.4.6-17.el7 for package: httpd-2.4.6-17.el7.x86_64--> Processing Dependency: /etc/mime.types for package: httpd-2.4.6-17.el7.x86_64--> Processing Dependency: libapr-1.so.0()(64bit) for package: httpd-2.4.6-17.el7.x86_64--> Processing Dependency: libaprutil-1.so.0()(64bit) for package: httpd-2.4.6-17.el7.x86_64--> Running transaction check---> Package apr.x86_64 0:1.4.8-3.el7 will be installed---> Package apr-util.x86_64 0:1.5.2-6.el7 will be installed---> Package httpd-tools.x86_64 0:2.4.6-17.el7 will be installed---> Package mailcap.noarch 0:2.1.41-2.el7 will be installed--> Finished Dependency ResolutionDependencies Resolved======================================================================= Package Arch Version Repository Size=======================================================================Installing: httpd x86_64 2.4.6-17.el7 rhel_dvd 1.2 MInstalling for dependencies: apr x86_64 1.4.8-3.el7 rhel_dvd 103 k apr-util x86_64 1.5.2-6.el7 rhel_dvd 92 k httpd-tools x86_64 2.4.6-17.el7 rhel_dvd 77 k mailcap noarch 2.1.41-2.el7 rhel_dvd 31 kTransaction Summary=======================================================================Install 1 Package (+4 Dependent packages)Total download size: 1.5 MInstalled size: 4.3 MDownloading packages:(1/5): apr-1.4.8-3.el7.x86_64.rpm | 103 kB 00:00 (2/5): apr-util-1.5.2-6.el7.x86_64.rpm | 92 kB 00:00 (3/5): httpd-tools-2.4.6-17.el7.x86_64.rpm | 77 kB 00:00 (4/5): mailcap-2.1.41-2.el7.noarch.rpm | 31 kB 00:00 (5/5): httpd-2.4.6-17.el7.x86_64.rpm | 1.2 MB 00:00 -----------------------------------------------------------------------Total 8.1 MB/s | 1.5 MB 00:00 Running transaction checkRunning transaction testTransaction test succeededRunning transaction Installing : apr-1.4.8-3.el7.x86_64 1/5 Installing : apr-util-1.5.2-6.el7.x86_64 2/5 Installing : httpd-tools-2.4.6-17.el7.x86_64 3/5 Installing : mailcap-2.1.41-2.el7.noarch 4/5 Installing : httpd-2.4.6-17.el7.x86_64 5/5 Verifying : mailcap-2.1.41-2.el7.noarch 1/5 Verifying : httpd-tools-2.4.6-17.el7.x86_64 2/5 Verifying : apr-1.4.8-3.el7.x86_64 3/5 Verifying : apr-util-1.5.2-6.el7.x86_64 4/5 Verifying : httpd-2.4.6-17.el7.x86_64 5/5 Installed: httpd.x86_64 0:2.4.6-17.el7 Dependency Installed: apr.x86_64 0:1.4.8-3.el7 apr-util.x86_64 0:1.5.2-6.el7 httpd-tools.x86_64 0:2.4.6-17.el7 mailcap.noarch 0:2.1.41-2.el7 Complete![root@localhost ~]# systemctl restart httpd
2:切换到http的共享目录 /var/www/html 下,开始配置相关设备。我们先得得到一个包,这个包就是我们所要共享在局域网上的httpmyadmin 的安装包。但是我们会发现我们没这个包,那么,我们就需要使用lftp从局域网上有这个包的机器上下载,在此,我们首先得配置好yum源,下载lftp,如下:
[root@localhost ~]# cd /var/www/html/[root@localhost html]# ls[root@localhost html]# lftp 172.25.254.250bash: lftp: command not found...[root@localhost html]# yum install lftp -yLoaded plugins: langpacksResolving Dependencies--> Running transaction check---> Package lftp.x86_64 0:4.4.8-3.el7 will be installed--> Finished Dependency ResolutionDependencies Resolved======================================================================= Package Arch Version Repository Size=======================================================================Installing: lftp x86_64 4.4.8-3.el7 rhel_dvd 749 kTransaction Summary=======================================================================Install 1 PackageTotal download size: 749 kInstalled size: 2.4 MDownloading packages:lftp-4.4.8-3.el7.x86_64.rpm | 749 kB 00:00 Running transaction checkRunning transaction testTransaction test succeededRunning transaction Installing : lftp-4.4.8-3.el7.x86_64 1/1 Verifying : lftp-4.4.8-3.el7.x86_64 1/1 Installed: lftp.x86_64 0:4.4.8-3.el7 Complete!
3:从172.25.254.250上获取所需要的安装包。
[root@localhost html]# lftp 172.25.254.250lftp 172.25.254.250:~> lsdrwxr-xr-x 2 0 0 4096 Mar 15 2016 CSA文档drwxr-xr-x 3 0 0 41 Sep 21 2015 baidudrwxr-xr-x 4 0 0 4096 Oct 02 2016 docsdrwxr-xr-x 20 0 0 4096 Jun 24 08:46 publftp 172.25.254.250:/> cd pub/lftp 172.25.254.250:/pub> cd docscd ok, cwd=/pub/docslftp 172.25.254.250:/pub/docs> cd software/lftp 172.25.254.250:/pub/docs/software> ls-rwxr-xr-x 1 1000 1000 3086326 Dec 25 2013 phpMyAdmin-2.11.3-all-languages.tar.bz2-rwxr-xr-x 1 1000 1000 4548030 Dec 25 2013 phpMyAdmin-3.4.0-all-languages.tar.bz2-rw-rw-r-- 1 1000 1000 2713600 Jun 07 2015 taobao.tar-rwxr-xr-x 1 1000 1000 52387876 Feb 01 2015 thunderbird-31.2.0-1.el7.x86_64.rpm-rwxr-xr-x 1 1000 1000 36902724 Feb 01 2015 thunderbird-31.4.0.tar.bz2lftp 172.25.254.250:/pub/docs/software> get phpMyAdmin-3.4.0-all-languages.tar.bz2 4548030 bytes transferred lftp 172.25.254.250:/pub/docs/software> quit
4:对于得到的这个包,我们会惊喜的发现他是一个压缩文件,这时,我们需要对他进行解压。解压后删除原有的压缩文件,分页浏览里面的README,根据指示进行配置。
[root@localhost html]# lsphpMyAdmin-3.4.0-all-languages.tar.bz2[root@localhost html]# tar jxf phpMyAdmin-3.4.0-all-languages.tar.bz2 #解压[root@localhost html]# lsphpMyAdmin-3.4.0-all-languages phpMyAdmin-3.4.0-all-languages.tar.bz2[root@localhost html]# rm -fr phpMyAdmin-3.4.0-all-languages.tar.bz2[root@localhost html]# lsphpMyAdmin-3.4.0-all-languages[root@localhost html]# mv phpMyAdmin-3.4.0-all-languages mysqladmin #名字化简[root@localhost html]# lsmysqladmin[root@localhost html]# ls mysqladmin #查看里面文件,里面有readme,那我们就readtabrowse_foreigners.php READMEbs_disp_as_mime_type.php README.VENDORbs_play_media.php RELEASE-DATE-3.4.0ChangeLog robots.txtchangelog.php schema_edit.phpchk_rel.php schema_export.phpconfig.sample.inc.php scriptscontrib server_binlog.phpCREDITS server_collations.phpdb_create.php server_databases.phpdb_datadict.php server_engines.phpdb_export.php server_export.phpdb_import.php server_import.phpdb_operations.php server_privileges.phpdb_printview.php server_processlist.phpdb_qbe.php server_replication.phpdb_search.php server_sql.phpdb_sql.php server_status.phpdb_structure.php server_synchronize.phpdb_tracking.php server_variables.phpdocs.css setupDocumentation.html show_config_errors.phpDocumentation.txt sql.phpenum_editor.php tbl_addfield.phpexport.php tbl_alter.phpfavicon.ico tbl_change.phpimport.php tbl_chart.phpimport_status.php tbl_create.phpindex.php tbl_export.phpINSTALL tbl_get_field.phpjs tbl_import.phplibraries tbl_indexes.phpLICENSE tbl_move_copy.phplicense.php tbl_operations.phplocale tbl_printview.phpmain.php tbl_relation.phpnavigation.php tbl_replace.phpphpdoctor.ini tbl_row_action.phpphpinfo.php tbl_select.phpphpmyadmin.css.php tbl_sql.phppmd tbl_structure.phppmd_common.php tbl_tracking.phppmd_display_field.php themespmd_general.php themes.phppmd_help.php TODOpmd_pdf.php transformation_overview.phppmd_relation_new.php transformation_wrapper.phppmd_relation_upd.php url.phppmd_save_pos.php user_password.phpprefs_forms.php view_create.phpprefs_manage.php view_operations.phpprint.css webapp.phpquerywindow.php
5:根据readme提示,我们需要复制一个文件,给他变名,同时,我们需要将readme里面的一行字符复制到 vim config.sample.inc.php里面,然后进行火墙配置,http开启。
[root@localhost html]# cp config.sample.inc.php config.inc.phpcp: cannot stat ‘config.sample.inc.php’: No such file or directory[root@localhost html]# cd mysqladmin[root@localhost mysqladmin]# cp config.sample.inc.php config.inc.php ##按指示做[root@localhost mysqladmin]# vim config.sample.inc.ph[root@localhost mysqladmin]# vim config.sample.inc.php[root@localhost mysqladmin]# less REREADME README.VENDOR RELEASE-DATE-3.4.0[root@localhost mysqladmin]# less README[root@localhost mysqladmin]# [root@localhost mysqladmin]# vim Documentation.txt
[root@localhost mysqladmin]# vim config.sample.inc.php[root@localhost mysqladmin]# vim config.inc.php[root@localhost mysqladmin]# vim config.sample.inc.php[root@localhost mysqladmin]# vim config.inc.php[root@localhost mysqladmin]# vim config.inc.php[root@localhost mysqladmin]# systemctl restart httpd[root@localhost mysqladmin]# systemctl status httpdhttpd.service - The Apache HTTP Server Loaded: loaded (/usr/lib/systemd/system/httpd.service; disabled) Active: active (running) since Fri 2017-08-11 02:15:50 EDT; 13s ago Process: 5924 ExecStop=/bin/kill -WINCH ${MAINPID} (code=exited, status=0/SUCCESS) Main PID: 5929 (httpd) Status: "Total requests: 0; Current requests/sec: 0; Current traffic: 0 B/sec" CGroup: /system.slice/httpd.service ├─5929 /usr/sbin/httpd -DFOREGROUND ├─5930 /usr/sbin/httpd -DFOREGROUND ├─5931 /usr/sbin/httpd -DFOREGROUND ├─5932 /usr/sbin/httpd -DFOREGROUND ├─5933 /usr/sbin/httpd -DFOREGROUND └─5934 /usr/sbin/httpd -DFOREGROUNDAug 11 02:15:50 localhost systemd[1]: Starting The Apache HTTP Serv....Aug 11 02:15:50 localhost httpd[5929]: AH00558: httpd: Could not re...eAug 11 02:15:50 localhost systemd[1]: Started The Apache HTTP Server.Hint: Some lines were ellipsized, use -l to show in full.
6:配置完成后,安装php并启动。
[root@localhost mysqladmin]# systemctl stop firewalld.service [root@localhost mysqladmin]# yum install php -yLoaded plugins: langpacksResolving Dependencies--> Running transaction check---> Package php.x86_64 0:5.4.16-21.el7 will be installed--> Processing Dependency: php-common(x86-64) = 5.4.16-21.el7 for package: php-5.4.16-21.el7.x86_64--> Processing Dependency: php-cli(x86-64) = 5.4.16-21.el7 for package: php-5.4.16-21.el7.x86_64--> Running transaction check---> Package php-cli.x86_64 0:5.4.16-21.el7 will be installed---> Package php-common.x86_64 0:5.4.16-21.el7 will be installed--> Processing Dependency: libzip.so.2()(64bit) for package: php-common-5.4.16-21.el7.x86_64--> Running transaction check---> Package libzip.x86_64 0:0.10.1-8.el7 will be installed--> Finished Dependency ResolutionDependencies Resolved======================================================================= Package Arch Version Repository Size=======================================================================Installing: php x86_64 5.4.16-21.el7 rhel_dvd 1.3 MInstalling for dependencies: libzip x86_64 0.10.1-8.el7 rhel_dvd 49 k php-cli x86_64 5.4.16-21.el7 rhel_dvd 2.7 M php-common x86_64 5.4.16-21.el7 rhel_dvd 559 kTransaction Summary=======================================================================Install 1 Package (+3 Dependent packages)Total download size: 4.7 MInstalled size: 17 MDownloading packages:(1/4): libzip-0.10.1-8.el7.x86_64.rpm | 49 kB 00:00 (2/4): php-5.4.16-21.el7.x86_64.rpm | 1.3 MB 00:00 (3/4): php-cli-5.4.16-21.el7.x86_64.rpm | 2.7 MB 00:00 (4/4): php-common-5.4.16-21.el7.x86_64.rpm | 559 kB 00:00 -----------------------------------------------------------------------Total 20 MB/s | 4.7 MB 00:00 Running transaction checkRunning transaction testTransaction test succeededRunning transaction Installing : libzip-0.10.1-8.el7.x86_64 1/4 Installing : php-common-5.4.16-21.el7.x86_64 2/4 Installing : php-cli-5.4.16-21.el7.x86_64 3/4 Installing : php-5.4.16-21.el7.x86_64 4/4 Verifying : php-common-5.4.16-21.el7.x86_64 1/4 Verifying : php-cli-5.4.16-21.el7.x86_64 2/4 Verifying : libzip-0.10.1-8.el7.x86_64 3/4 Verifying : php-5.4.16-21.el7.x86_64 4/4 Installed: php.x86_64 0:5.4.16-21.el7 Dependency Installed: libzip.x86_64 0:0.10.1-8.el7 php-cli.x86_64 0:5.4.16-21.el7 php-common.x86_64 0:5.4.16-21.el7 Complete!
7:启动之后,我们登录会发现他缺少一个和我们mysql数据库连接的东西,下载并安装。
[root@localhost mysqladmin]# systemctl restart httpd[root@localhost mysqladmin]# yum search phpLoaded plugins: langpacks========================== N/S matched: php ===========================php.x86_64 : PHP scripting language for creating dynamic web sitesphp-cli.x86_64 : Command-line interface for PHPphp-common.x86_64 : Common files for PHPphp-gd.x86_64 : A module for PHP applications for using the gd graphics : libraryphp-ldap.x86_64 : A module for PHP applications that use LDAPphp-mysql.x86_64 : A module for PHP applications that use MySQL : databasesphp-odbc.x86_64 : A module for PHP applications that use ODBC databasesphp-pdo.x86_64 : A database access abstraction module for PHP : applicationsphp-pear.noarch : PHP Extension and Application Repository frameworkphp-pgsql.x86_64 : A PostgreSQL database module for PHPphp-process.x86_64 : Modules for PHP script using system process : interfacesphp-recode.x86_64 : A module for PHP applications for using the recode : libraryphp-soap.x86_64 : A module for PHP applications that use the SOAP : protocolphp-xml.x86_64 : A module for PHP applications which use XMLphp-xmlrpc.x86_64 : A module for PHP applications which use the XML-RPC : protocolphp-pecl-memcache.x86_64 : Extension to work with the Memcached caching : daemon Name and summary matches only, use "search all" for everything.[root@localhost mysqladmin]# yum install php-mysql.x86_64 -yLoaded plugins: langpacksResolving Dependencies--> Running transaction check---> Package php-mysql.x86_64 0:5.4.16-21.el7 will be installed--> Processing Dependency: php-pdo(x86-64) = 5.4.16-21.el7 for package: php-mysql-5.4.16-21.el7.x86_64--> Running transaction check---> Package php-pdo.x86_64 0:5.4.16-21.el7 will be installed--> Finished Dependency ResolutionDependencies Resolved====================================================================== Package Arch Version Repository Size======================================================================Installing: php-mysql x86_64 5.4.16-21.el7 rhel_dvd 96 kInstalling for dependencies: php-pdo x86_64 5.4.16-21.el7 rhel_dvd 93 kTransaction Summary======================================================================Install 1 Package (+1 Dependent package)Total download size: 189 kInstalled size: 424 kDownloading packages:(1/2): php-mysql-5.4.16-21.el7.x86_64.rpm | 96 kB 00:00 (2/2): php-pdo-5.4.16-21.el7.x86_64.rpm | 93 kB 00:00 ----------------------------------------------------------------------Total 1.6 MB/s | 189 kB 00:00 Running transaction checkRunning transaction testTransaction test succeededRunning transaction Installing : php-pdo-5.4.16-21.el7.x86_64 1/2 Installing : php-mysql-5.4.16-21.el7.x86_64 2/2 Verifying : php-mysql-5.4.16-21.el7.x86_64 1/2 Verifying : php-pdo-5.4.16-21.el7.x86_64 2/2 Installed: php-mysql.x86_64 0:5.4.16-21.el7 Dependency Installed: php-pdo.x86_64 0:5.4.16-21.el7 Complete![root@localhost mysqladmin]# systemctl restart httpd ##重启httpd查看效果
查看效果
阅读全文
0 0
- phpMyAdmin
- PhpMyAdmin
- phpmyadmin
- phpMyAdmin
- phpmyadmin
- phpMyAdmin
- phpMyadmin
- PHPmyadmin
- phpmyadmin
- phpMyadmin
- phpMyAdmin
- phpmyadmin
- phpMyAdmin 详解
- PHPMYADMIN配置
- phpMyAdmin安装
- phpMyAdmin配置
- phpmyadmin配置
- phpmyadmin安装
- 在服务器停电后重启需要操作
- java集合原理
- 基础数论算法(⑨) 高斯消元与LU分解
- 通过数组方式向Oracle大批量插入数据(10万条11秒)
- bzoj2038: [2009国家集训队]小Z的袜子(hose)(莫队+分块模板题)
- phpmyadmin
- Spring 定时任务scheduled详解
- 紫书dp 硬币问题
- Android自定义折线图,可设置基准线,不同点颜色
- eclipse复制项目后原项目名依然伴随值所复制的项目名
- scala学习-DescriptionResourcePathLocationType value toDF is not a member of org.apache.spark.rdd.R
- MacPorts 初装后提示 command not found: port 解决方案
- 几个连接HiveServer的客户端界面工具
- Add Two Numbers