mysqlÔÚÔÙ´ÎÐ¶ÔØºó֨װ³öÏÖStart services²»ÄÜÆô¶¯
×î½ü×öÒ»¸öСÏîÄ¿£¬¸ÕºÃÓöµ½Õâ¸öÎÊÌ⣬ûʲôʱ¼äÈ¥½â¾öÕâ¸öÎÊÌ⣬´ó¸ÅÔÚÍøÉÏÕÒÁËһϣ¬Ëµ¸ÄʵÀýÃû£¬¸Ä×¢²á±í£¬ÏȲ»ÊǺܸҸģ¬±Ï¾¹¶Ô×¢²á±íÒ»Ö±¾õµÃÊǸö´óÉñ£¬²»¸ÒËæ±ã¶¯£¬½ñ¶ùÊÇ»í³öÈ¥ÁË£¬¾ÍÔÚ×¢²á±íÖвéÕÒËùÓдúmysql×ÖÑùµÄÐÅϢȫ²¿É¾³ý£¬×îºó¾¹È»³ÉÁË£¬µ±È»Ð¶Ôغóɾ³ý֮ǰËùÓеÄÏà¹ØÐÅÏ¢£¬°²×°ÎļþĿ¼ºÍÏà¹ØÐÅÏ¢¡£
Ïà¹ØÎĵµ£º
ÔÚÔËÐÐmysql administratorµÄʱºò,ÎÞ·¨µÇ¼mysql·þÎñÆ÷,²éÕÒ´íÎó,ÀÏÊÇÎÞ·¨½øÐÐ.ÔÚ½øÈëwindowsϵĹÜÀí¹¤¾ßµÄ·þÎñÖÐ,ÒÀÈ»ÎÞ·¨Æô¶¯,Ìáʾ˵ÊÇ´íÎó1067.½â¾ö·½°¸ÈçÏÂ:
1\½øÈëÃüÁîÌáʾ·û,ÊäÈë sc delete mysql
ÌáʾÈôÊÇdelete service success,Ö¤Ã÷ɾ³ý·þÎñ³É¹¦;
2\ÔËÐÐmysqlµÄbinĿ¼ÏÂÃæµÄmysqlinstanceconfig,¶Ômysql½øÐ ......
ǰ´ÎдÁ˸ö³ÌÐòÅÜÔÚsolaris10ÉÏ£¬ÒªÓõ½mysqlÊý¾Ý¿â£¬È¥sunÍøÕ¾ÉÏÏÂÒ»¸ö¹ýÀ´£¬
È»ºópkgadd mysql5.* ʲôÌáʾ¶¼Ã»£¬¾Í°²×°Íê³ÉÁË£¬ÓôÃÆµÄÊÂÇé¾ÍÕâÑù·¢ÉúÁË©¤©¤
ÎÒ²»ÖªµÀMYSQLµÄĬÈÏÓû§ÃûÃÜÂëÊÇʲô£¬°´ÕÕWINDOWSÖÐʹÓõľÑéÊÔÁËN±é£¬
²»ÐУ¡Ö»ºÃGOOGLEÁË£¬ºÃ²»ÈÝÒ׸㶨¡£Ò»ÏÂΪGOOGLEÖ®ÄÚÈÝ£¬·ÇÔ´´
Unix&Linux ......
Ò»¡¢°²×°·þÎñÆ÷¶Ë
£¨1£©¡¢ÔÚÓÐÁ½¸örmpÎļþµÄĿ¼ÏÂÔËÐÐÈçÏÂÃüÁ
[root@test1 local]# rpm -ivh MySQL-server-5.0.26-0.i386.rpm
ÏÔʾÈçÏÂÐÅÏ¢£º
warning: MySQL-server-5.0.26-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing……¡¡¡¡¡¡¡¡¡¡¡¡¡¡##################################### ......
Ê×ÏÈ£¬½¨InnoDBÀàÐÍµÄ±í£¬²ÅÄÜÖ§³ÖÊÂÎñ
$handler = mysql_connect('localhost', '', '');
mysql_select_db('test');
mysql_query('SET AUTOCOMMIT=0'); // ÉèÖÃΪ²»×Ô¶¯Ìá½»²éѯ
mysql_query('START TRANSACTION'); // ¿ªÊ¼²éѯ£¬ÕâÀïÒ²¿ÉÒÔʹÓÃBEGIN
mysql_query("INSERT INTO users VALUES ('ccc')");
mysql_query( ......
°²×°ºó
/etc/init.d/mysql start (stop) ΪÆô¶¯ºÍÍ£Ö¹·þÎñÆ÷
/etc/mysql/ Ö÷ÒªÅäÖÃÎļþËùÔÚλÖà my.cnf
/var/lib/mysql/ ·ÅÖõÄÊÇÊý¾Ý¿â±íÎļþ¼Ð£¬ÕâÀïµÄmysqlÏ൱ÓÚwindowsÏÂmysqlµÄdateÎļþ¼Ð
Æô¶¯mysqlºó£¬ÒÔrootµÇ¼mysql
isher@isher-ubuntu:~$ mysql -u root
>show variables like 'character%'; #Ö´ÐбàÂëÏ ......