MySQL phpMyAdmin °²×°
Ê×ÏÈ°²×°phpMyadmin
[root@aladdin phpMyAdmin]# uname -a
Linux aladdin.leadtek.com.cn 2.6.32.11-99.fc12.i686.PAE #1 SMP Mon Apr 5 16:15:03 EDT 2010 i686 i686 i386 GNU/Linux
[root@aladdin phpMyAdmin]# yum info phpmyadmin
Loaded plugins: presto, refresh-packagekit
Installed Packages
Name : phpMyAdmin
Arch : noarch
Version : 3.2.5
Release : 1.fc12
Size : 11 M
Repo : installed
from repo : updates
Summary : Web based MySQL browser written in php
URL : http://www.phpmyadmin.net/
License : GPLv2+
Description: phpMyAdmin is a tool written in PHP intended to handle the
: administration of MySQL over the Web. Currently it can create and
: drop databases, create/drop/alter tables, delete/edit/add fields,
: execute any SQL statement, manage keys on fields, manage
: privileges,export data into various formats and is available in 50
: languages
°²×°Íê³Éºó·ÃÎÊ http://localhost/phpMyAdmin, ÐèÒªhttpÈÏÖ¤, ¹ÊÐèÒªÐÞ¸ÄÅäÖÃÎļþ.
ÐÞ¸ÄÅäÖÃÎļþ, ²Î¿¼ http://www.phpmyadmin.net/documentation/#config
ÔÚ/etc/phpMyAdmin/ÖÐ
# cd /etc/phpMyAdmin
# mkdir config # create directory for saving
# chmod o+rw config # give it world writable permissions
# cp config.inc.php config/ # copy current configuration for editing
# chmod o+w config/config.inc.php # give it world writable permissions
ʹÓÃä¯ÀÀÆ÷·ÃÎÊ http://localhost/phpMyAdmin/setup
Ñ¡ÔñConnect without passwo
Ïà¹ØÎĵµ£º
mysql ¿ÉÒÔͨ¹ý×Ó²éѯµÃµ½ÒªÉ¾³ýµÄ¼Ç¼Ìõ¼þ£¬È»ºóͨ¹ý×Ó²éѯµÃ½á¹ûÆ¥ÅäҪɾ³ýµÄ¼Ç¼¡£µ«ÊÇ mysql ²»ÄÜÖ±½Óɾ³ý×Ó²éѯ±íÖеÄÊý¾Ý£¬±ØÐëͨ¹ýÒ»¸öÁÙʱ±íÀ´½â¾ö¡£ÀýÈ磺
delete from t_transaction where exists
(select d.* from t_ti_category a,t_category b,t_ ......
²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽ ......
ÎÊÌ⣺
1¡¢Êý¾Ý¿âĬÈϵÄ×Ö·û¼¯ÉèÖÃΪUTF-8£»
2¡¢Í¨¹ýibatis¶ÁдÊý¾ÝÖÐÎÄÕý³££»
3¡¢µ«ÊÇÓÃwindowsÃüÁîÐÐÖ´ÐÐselectÓï¾äÖÐÎÄÏÔʾÂÒÂë¡£
½â¾ö£º
Êý¾Ý¿âÓû§µÇ¼ʱ²ÎÊýÉ趨×Ö·û¼¯£º
mysql --default-character-set=gb2312 -u ̞ -p
£¨¹À¼ÆºÍwindowsµÄcmdÃüÁîÐÐÓйأ© ......
ת×Ôhttp://blog.csdn.net/ytz_linuxer/archive/2009/07/04/4321259.aspx
ÒÔ°æ±¾phpMyAdmin-2.6.1.tar.gzΪÀý
ÏȽâѹphpMyAdmin-2.6.1.tar.gzµ½/usr/local/apache2/htdocs£¬
µÃµ½Îļþ¼ÐphpMyAdmin-2.6.1£¬½«ÆäÖØÃüÃûΪphpmyadmin,(ÕâÑùÔÚÒÔºóµÄ²Ù×÷Öн«»á±äµÄ¼ò±ã)¡£
  ......
×î½üÏëÔÚ·þÎñÆ÷ÉÏÊÔÊÔMySQL5.1µÄ·ÖÇø£¬ÓÚÊǾÍÏë×Å×°¸öMySQL5.1£¬¾¹ýÍ´¿àµÄÒ»¶Î¾Àúºó£¬ÖÕÓÚÕÒ¸öÏÂÃæ×°¸öºÜºÃµÄ½Ì³Ì£¬ÌûÉÏÀ´±¸Íü¡£
1¡¢MySQLÃâ°²×°°æ/¶þ½øÖÆ°æÈí¼þ£¬²»ÓñàÒ룬ÏÂÔصØÖ·£º
http://dev.mysql.com/downloads/
Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡¢´ ......