MySQLStudy之--MySQL下圖形工具的使用(phpMyAdmin)
Jun 07, 2016 pm 02:56 PMMySQL Study之--MySQL下圖形工具的使用(phpMyAdmin) 系統(tǒng)環(huán)境: RedHat EL6 數(shù)據(jù)庫: MySQL 5.6.4-m7 php MyAdmin是一個(gè)用 PHP 編寫的 軟件工具 ,是以PHP為基礎(chǔ),以Web-Base方式架構(gòu)在 網(wǎng)站 主機(jī)上的 MySQL 的 數(shù)據(jù)庫管理 工具,讓管理者可用Web接口管理
MySQL Study之--MySQL下圖形工具的使用(phpMyAdmin)
系統(tǒng)環(huán)境: RedHat EL6
數(shù)據(jù)庫: ?MySQL 5.6.4-m7
? phpMyAdmin是一個(gè)用PHP編寫的軟件工具,是以PHP為基礎(chǔ),以Web-Base方式架構(gòu)在網(wǎng)站主機(jī)上的MySQL的數(shù)據(jù)庫管理工具,讓管理者可用Web接口管理MySQL數(shù)據(jù)庫。借由此Web接口可以成為一個(gè)簡易方式輸入繁雜SQL語法的較佳途徑,尤其要處理大量資料的匯入及匯出更為方便。其中一個(gè)更大的優(yōu)勢(shì)在于由于phpMyAdmin跟其他PHP程式一樣在網(wǎng)頁服務(wù)器上執(zhí)行,但是您可以在任何地方使用這些程式產(chǎn)生的HTML頁面,也就是于遠(yuǎn)端管理MySQL數(shù)據(jù)庫,方便的建立、修改、刪除數(shù)據(jù)庫及資料表。也可借由phpMyAdmin建立常用的php語法,方便編寫網(wǎng)頁時(shí)所需要的sql語法正確性。
? 在Linux環(huán)境下安裝和配置phpMyAdmin需要安裝Apache、PHP、MySQL,這些軟件可以通過RPM包方式或源代碼方式安裝,本案例是以RPM方式安裝:
一、環(huán)境準(zhǔn)備,安裝如下軟件:?
1、Apache
[root@mysrv libraries]# rpm -qa |grep httpd httpd-tools-2.2.15-26.el6.x86_64 httpd-manual-2.2.15-26.el6.noarch httpd-2.2.15-26.el6.x86_64 [root@mysrv libraries]# rpm -qa |grep mod mod_auth_pgsql-2.0.3-10.1.el6.x86_64 mod_authz_ldap-0.26-16.el6.x86_64 xorg-x11-drv-modesetting-0.5.0-1.el6.x86_64 PackageKit-gtk-module-0.5.8-21.el6.x86_64 module-init-tools-3.9-21.el6.x86_64 mod_auth_kerb-5.4-9.el6.x86_64 mod_wsgi-3.2-3.el6.x86_64 mod_ssl-2.2.15-26.el6.x86_64 mod_dnssd-0.6-2.el6.x86_64 mod_perl-2.0.4-10.el6.x86_64 mod_auth_mysql-3.0.0-11.el6_0.1.x86_64
2、mysql
[root@mysrv libraries]# rpm -qa |grep mysql mysql-5.1.66-2.el6_3.x86_64 mysql-bench-5.1.66-2.el6_3.x86_64 mysql-devel-5.1.66-2.el6_3.x86_64 mysql-libs-5.1.66-2.el6_3.x86_64 mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 qt-mysql-4.6.2-25.el6.x86_64 php-mysql-5.3.3-22.el6.x86_64 mysql-devel-5.1.66-2.el6_3.i686 mysql-libs-5.1.66-2.el6_3.i686 mysql-connector-java-5.1.17-6.el6.noarch mysql-server-5.1.66-2.el6_3.x86_64 mod_auth_mysql-3.0.0-11.el6_0.1.x86_64 mysql-test-5.1.66-2.el6_3.x86_64
3、php
[root@mysrv libraries]# rpm -qa |grep php php-pecl-memcache-3.0.5-4.el6.x86_64 php-pgsql-5.3.3-22.el6.x86_64 php-cli-5.3.3-22.el6.x86_64 php-pdo-5.3.3-22.el6.x86_64 php-mysql-5.3.3-22.el6.x86_64 php-pecl-apc-3.1.9-2.el6.x86_64 php-ldap-5.3.3-22.el6.x86_64 php-mbstring-5.3.3-46.el6_6.x86_64 php-pear-1.9.4-4.el6.noarch php-xml-5.3.3-22.el6.x86_64 php-5.3.3-22.el6.x86_64 php-gd-5.3.3-22.el6.x86_64 php-soap-5.3.3-22.el6.x86_64 php-common-5.3.3-22.el6.x86_64 php-odbc-5.3.3-22.el6.x86_64 php-xmlrpc-5.3.3-22.el6.x86_64
其中php-mbstring,在RedHat的安裝光盤中沒有,需要從網(wǎng)上下載后安裝,安裝后需要以下配置:
[root@mysrv libraries]# echo ‘extension=mbstring.so' >>/etc/php.ini #根據(jù)php安裝目錄而定 [root@mysrv libraries]# service httpd restart
以上軟件包安裝完成后,就可以進(jìn)入phpMyAdmin的安裝和配置了
二、安裝和配置phpMyAdmin
1、下載安裝和配置phpMyAdmin
1)先到 phpMyAdmin的官方站上下載最近的 phpMyAdmin
https://www.phpmyadmin.net/downloads/
下載版本:phpMyAdmin-4.4.11-all-languages.tar.gz
2)將軟件包解壓到/var/www/html
# tar zxvf?phpMyAdmin-4.4.11-all-languages.tar.gz?-C ? /var/www/html
3) 修改目錄名為 phpMyAdmin
# mv ?phpMyAdmin-4.4.11-all-languages ?phpMyAdmin
[root@mysrv oracle]# ls -l /var/www/html/
total 8
-rw-r--r-- ?1 root root ? 17 Jul 15 14:21 index.php
drwxr-xr-x 10 root root 4096 Jul 14 17:45 phpMyAdmin
4) 配置phpMyAdmin
1、編輯. /libraries/config.default.php文件
2、查找 $cfg['Servers'][$i]['host'] = 'localhost'; 如果允許客戶端遠(yuǎn)程管理,將“l(fā)ocalhost”改為服務(wù)器ip
$cfg['Servers'][$i]['host'] = '192.168.8.24';
3、查找 $cfg['Servers'][$i]['auth_type'] = 'config';
在自己的機(jī)子里調(diào)試用config;如果在網(wǎng)絡(luò)上的空間用cookie,這里我們既然在前面已經(jīng)添加了網(wǎng)址,就修改成cookie ,這里建議使用cookie.
$cfg['Servers'][$i]['auth_type'] = 'cookie';
4、查找 $cfg['Servers'][$i]['user'] = 'root'; // MySQL user(mysql用戶名,自己機(jī)里用root;)
$cfg['Servers'][$i]['user'] = 'root';
5、查找 $cfg['Servers'][$i]['password'] = ''; // MySQL password (mysql用戶的密碼,自己的服務(wù)器一般都是mysql用戶root的密碼)
$cfg['Servers'][$i]['password'] = 'oracle';
6、查找 $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only(你只有一個(gè)數(shù)據(jù)就設(shè)置一下;如果你在本機(jī)或想架設(shè)服務(wù)器,那么建議留空)
$cfg['Servers'][$i]['only_db'] = '';
7、查找 $cfg['DefaultLang'] = 'zh'; (這里是選擇語言,zh代表簡體中文的意思,這里不知道填gbk對(duì)否)
$cfg['DefaultLang'] = 'en';
8、設(shè)置完畢后保存
? 如果出現(xiàn)“配置文件現(xiàn)在需要絕密的短語密碼(blowfish_secret)”那么請(qǐng)?jiān)?cfg['blowfish_secret'] = ' ';的等號(hào)里面設(shè)置你網(wǎng)站的cookie,例如:$cfg['blowfish_secret'] = '任意字符';這是因?yàn)槟愕摹?cfg['Servers'][$i]['auth_type'] = 'cookie'的原因。
三、測(cè)試
開啟瀏覽器,http://192.168.8.24/phpMyAdmin
圖一:登陸界面
圖二:管理界面
----至此,phpMyAdmin已經(jīng)配置成功!
注意:
以上,錯(cuò)誤,是因?yàn)樵趌inux下沒有安裝和配置php-mbstring造成 !

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

There is no legal virtual currency platform in mainland China. 1. According to the notice issued by the People's Bank of China and other departments, all business activities related to virtual currency in the country are illegal; 2. Users should pay attention to the compliance and reliability of the platform, such as holding a mainstream national regulatory license, having a strong security technology and risk control system, an open and transparent operation history, a clear asset reserve certificate and a good market reputation; 3. The relationship between the user and the platform is between the service provider and the user, and based on the user agreement, it clarifies the rights and obligations of both parties, fee standards, risk warnings, account management and dispute resolution methods; 4. The platform mainly plays the role of a transaction matcher, asset custodian and information service provider, and does not assume investment responsibilities; 5. Be sure to read the user agreement carefully before using the platform to enhance yourself

Bitcoin halving affects the price of currency through four aspects: enhancing scarcity, pushing up production costs, stimulating market psychological expectations and changing supply and demand relationships; 1. Enhanced scarcity: halving reduces the supply of new currency and increases the value of scarcity; 2. Increased production costs: miners' income decreases, and higher coin prices need to maintain operation; 3. Market psychological expectations: Bull market expectations are formed before halving, attracting capital inflows; 4. Change in supply and demand relationship: When demand is stable or growing, supply and demand push up prices.

The latest price of Dogecoin can be queried in real time through a variety of mainstream APPs and platforms. It is recommended to use stable and fully functional APPs such as Binance, OKX, Huobi, etc., to support real-time price updates and transaction operations; mainstream platforms such as Binance, OKX, Huobi, Gate.io and Bitget also provide authoritative data portals, covering multiple transaction pairs and having professional analysis tools. It is recommended to obtain information through official and well-known platforms to ensure data accuracy and security.

PEPE coins are altcoins, which are non-mainstream cryptocurrencies. They are created based on existing blockchain technology and lack a deep technical foundation and a wide application ecosystem. 1. It relies on community driving forces to form a unique cultural label; 2. It has large price fluctuations and strong speculativeness, and is suitable for those with high risk preferences; 3. It lacks mature application scenarios and relies on market sentiment and social media. The prospects depend on community activity, team driving force and market recognition. Currently, it exists more as cultural symbols and speculative tools. Investment needs to be cautious and pay attention to risk control. It is recommended to rationally evaluate personal risk tolerance before operating.

With the digital asset industry booming, choosing a safe and reliable trading platform is crucial. This article has compiled the official website entrances and core features of the top ten mainstream cryptocurrency platforms in the world, aiming to help you quickly understand the leaders in the market and provide you with a clear navigation for exploring the digital world. It is recommended to collect the official websites of commonly used platforms to avoid entering through unverified links.

The latest BTC price can be checked in real time through multiple mainstream APPs and platforms. 1. The CoinMarketCap APP provides comprehensive market data; 2. The CoinGecko APP supports multiple transaction pairs of prices; 3. The Binance APP integrates market and trading. Platform: 1. The CoinMarketCap platform supports trend chart analysis; 2. The CoinGecko platform has a friendly interface; 3. The Binance trading platform has strong liquidity; 4. The OKX trading platform is compliant and safe; 5. The TradingView chart platform is suitable for technical analysis. It is recommended to obtain information through official and well-known platforms to ensure data accuracy and asset security.

The top ten cryptocurrency platform apps worth paying attention to in 2025 include Binance, Ouyi, Coinbase, Kraken, KuCoin, Bybit, Gate.io, MEXC, Bitget and Crypto.com. 1. Binance: deep liquidity, many trading products, low handling fees, suitable for from novices to professional traders; 2. Ouyi: Strong derivatives, integrated Web3 experience, suitable for experienced traders and Web3 users; 3. Coinbase: high compliance, simple operation, strong security, suitable for beginners; 4. Kraken: top security records, high customer service, suitable for long-term investors; 5. KuCoin: fast launch of new coins, high altcoins

The price potential of major crypto assets from 2025 to 2030 is driven by technological development, market cycles and macroeconomics. 1. Bitcoin (BTC) is expected to break through the historical high in 2025 due to the halving event and the launch of ETFs, and may reach a new order of magnitude in 2030; 2. Ethereum (ETH) benefits from network upgrades and ecological expansion, and its long-term value is bullish; 3. Projects such as Solana, BNB, and Chainlink rely on ecological development and technological stability, and the overall market will mature but be accompanied by high risks.
