ÈçºÎÐÞ¸Ämysql rootÃÜÂë
1¡¢±à¼MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñ
windows»·¾³ÖУº
net stop MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)
net start MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)
linux»·¾³ÖУº
/etc/init.d/MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d restart
3¡¢ÉèÖÃеÄROOTÃÜÂë
È»ºóÔÙÔÚÃüÁîÐÐÏÂÖ´ÐУº
MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ) -uroot -p MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)
Ö±½Ó»Ø³µÎÞÐèÃÜÂë¼´¿É½øÈëÊý¾Ý¿âÁË¡£
ÏÖÔÚÎÒÃÇÖ´ÐÐÈçÏÂÓï¾ä°ÑrootÃÜÂë¸üÐÂΪ 7758521£º
update user set password=PASSWORD("7758521") where user='root';
quit Í˳öMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)¡£
4¡¢»¹ÔÅäÖÃÎļþ²¢ÖØÆô·þÎñ
È»ºóÐÞ¸ÄMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ°Ñ¸Õ²ÅÌí¼ÓµÄÄÇÒ»ÐÐɾ³ý¡£
ÔÙ´ÎÖØÆðMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñ£¬ÃÜÂëÐÞ¸ÄÍê±Ï¡£
ÐÞ¸ÄÍê±Ï¡£
ÓÃÐÂÃÜÂë7758521ÊÔһϰɣ¬ÓÖÄܵÇÈëMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄ¸Ð¾õ¾ÍÊDz»Ò»Ñù°É£¿
Ïà¹ØÎĵµ£º
1.DATE_FORMAT('2010-05-15 15:47:36','%H:%i:%s') -> ½á¹û£º15:47:36
½«ÈÕÆÚ¸ñʽ¸ù¾ÝÌõ¼þ²»Í¬×ª»»³ÉËùÐèÒªµÄÈÕÆÚ¡¢Ê±¼ä¸ñʽ
2.timediff('23:40:00', ' 18:30:00') -> ½á¹û£º05:10:00
......
£¨1£©INFORMATION_SCHEMA
select (sum(data_length) + sum(index_length))/(1024*1024) from INFORMATION_SCHEMA.`TABLES` where table_schema = 'your_table_schema' and table_name like 'your_table_name';
£¨2£©show table status like '';
try {
Class.forName("com.mysql.jdbc.Driver");
......
×÷/ÒëÕߣºÒ¶½ðÈÙ£¨Email: £©£¬À´Ô´£ºhttp://imysql.cn£¬×ªÔØÇë×¢Ã÷×÷/ÒëÕߺͳö´¦£¬²¢ÇÒ²»ÄÜÓÃÓÚÉÌÒµÓÃ;£¬Î¥Õ߱ؾ¿¡£
Ê×ÏÈ,ÕâÆ¬ÎÄÕ´¿´âÊÇÎҵĸöÈ˾Ñé̸֮,ÊÊÓÃÓÚÎÒ³£¼ûµÄ»·¾³¼°ÏîÄ¿ÖÐ.
¸öÈ˽¨Òé,Êý¾Ý¿â×Ö·û¼¯¾¡Á¿Ê¹ÓÃutf8(HTMLÒ³Ãæ¶ÔÓ¦µÄÊÇutf-8),ÒÔʹÄãµÄÊý¾ÝÄܺÜ˳ÀûµÄʵÏÖÇ¨ÒÆ,ÒòΪutf8×Ö·û¼¯ÊÇĿǰ×îÊʺÏÓÚÊ ......
#!/bin/bash
#ɾ³ý100¸öÊý¾Ý¿âÖеÄ1000¸ö±íµÄ¹ýÆÚÊý¾Ý
DBHOST="127.0.0.1"
DBPWD="pwd"
DBUSER="root"
MYSQLBIN="/usr/local/mysql/bin/mysql"
for((dbindex = 0;dbindex < 100;dbindex++))
do
for((tabindex = 0;tabindex < 10;tabindex++))
do
if [&n ......
MySQLµÄ×Ö·û¼¯Ö§³Ö(Character Set Support)ÓÐÁ½¸ö·½Ã棺
×Ö·û¼¯(Character set)ºÍÅÅÐò·½Ê½(Collation)¡£
¶ÔÓÚ×Ö·û¼¯µÄÖ§³Öϸ»¯µ½Ëĸö²ã´Î:
·þÎñÆ÷(server)£¬Êý¾Ý¿â(database)£¬Êý¾Ý±í(table)ºÍÁ¬½Ó(connection)¡£
1.MySQLĬÈÏ×Ö·û¼¯
MySQL¶ÔÓÚ×Ö·û¼¯µÄ ......