Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

linux mysqlµÄ°²×°¼°Ò»Ð©ÅäÖ÷½·¨

1.¼ì²éÒÔǰ°²×°µÄMySQL,Ð¶ÔØ¡£
rpm -qa|grep -i mysql
rpm -e XXXXX
×¢Èç¹û³öÏÖÁ½ÌõÏàͬµÄ£¬ÔòʹÓÃrpm -e --allmatches
2.°²×°rpm°ü¡£
rpm -ivh MySQL-server-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-shared-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-devel-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-client-community-5.1.37-0.rhel5.x86_64.rpm
3.cp ²ÎÊýÎļþµ½ /etc/my.cnf
find / -name "my*.cnf"
Ìí¼Ó²ÎÊý
transaction-isolation=READ-COMMITTED
default-storage-engine=INNODB
innodb_flush_log_at_trx_commit=2
4.¸üÐÂȨÏÞ¼°Óû§
mysql -u root -p
use mysql;
select user,host from user;
delete from user where user <> 'root';
delete from user where host <> 'localhost';
update user set host ='%' where user ='root';
select user,host from user;
¸üÐÂuser±íµ½ÈçÏÂ״̬
mysql> select user,host from user;
+------+------+
| user | host |
+------+------+
| root | %    |
+------+------+
1 row in set (0.00 sec)
´´½¨Óû§
grant select,insert,update,delete,create,drop,alter,index,RELOAD, lock tables, execute, create routine, alter routine,Create temporary tables 
on *.* to mysql@"%" identified by "123456";
set global transaction isolation level read committed;
set session transaction isolation level read committed;
¸üÐÂȨÏÞ
flush privileges;
5.ÉèÖÃÃÜÂë(123456)
mysqladmin -u root -p password ×××
####mysqladmin -u root -p password mypasswd
6.ÖØÆô·þÎñ£¬ÑéÖ¤ÉèÖá£
/etc/init.d/mysql restart
怫mysql
Ð¶ÔØÇý¶¯
rpm -e --justdb mysql-connector-odbc-5.1.5-0
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1234 K
bytes of memory
MySQL Íü¼Ç¿ÚÁîµÄ½â¾ö°ì·¨
Èç¹û MySQL ÕýÔÚÔËÐУ¬Ê×ÏÈɱ֮£º killall -TERM mysqld¡£
Æô¶¯ MySQL £ºbin/safe_mysqld --skip-grant-tables &
¾Í¿ÉÒÔ²»ÐèÒªÃÜÂë¾Í½øÈë MySQL ÁË¡£
È»ºó¾ÍÊÇ
use mysql;
update user set password=password("new_pass") where user="root";
update user set password=password(


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì(Áù) L2CAP±à³ÌʵÀý

ÀýÒ»£º·¢ËÍSignaling Packet£º
Signaling CommandÊÇ2¸öBluetoothʵÌåÖ®¼äµÄL2CAP²ãÃüÁî´«Êä¡£ËùÒÔµÃSignaling CommandʹÓÃCID 0x0001.
¶à¸öCommand¿ÉÒÔÔÚÒ»¸öC-frame£¨control frame£©Öз¢ËÍ¡£
 Èç¹ûÒªÖ±½Ó·¢ËÍSignaling Command.ÐèÒª½¨Á¢SOCK_RAWÀàÐ͵ÄL2CAPÁ¬½ÓSocket¡£ÕâÑù²ÅÓлú»á×Ô¼ºÌî³äCommand Code£¬Identi ......

LinuxÄÚºËÔ´´úÂëµÄÔĶÁºÍ¹¤¾ß½éÉÜ


LinuxÄÚºËÔ´´úÂëµÄÔĶÁºÍ¹¤¾ß½éÉÜ
01-7-27 ÉÏÎç 09:38:07
---------------------------------------------------------------
 
Ëæ×ÅlinuxµÄÖð²½ÆÕ¼°£¬ÏÖÔÚÓв»ÉÙÈ˶ÔÓÚLinuxµÄ°²×°¼°ÉèÖÃÒѾ­±È½ÏÊìϤÁË¡£ÓëLinux µÄÅ·¢Õ¹ÏàÊÊÓ¦£¬ÏëÉîÈëÁ˽âLinuxµÄÒ²Ô½À´Ô½¶à¡£¶øÒªÏëÉîÈëÁ˽âLinux£¬¾ÍÐèÒªÔĶÁºÍ·ÖÎölinuxÄ ......

LinuxÂ̰Ó

DansGuardian
, written by SmoothWall Ltd and others, is content-control software: software designed to control which websites users can access. It also includes virus filtering and usage monitoring features. DansGuardian must be installed on a Unix or Linux computer, such as a server computer; its ......

дµÃÂùºÃµÄlinuxѧϰ±Ê¼Ç£¨×ª£©


linuxĿ¼¼Ü¹¹
/   ¸ùĿ¼
/bin    ³£ÓõÄÃüÁî binary file µÄÄ¿錄
/boot   ´æ·ÅϵͳÆô¶¯Ê±±ØÐë¶ÁÈ¡µÄµµ°¸£¬°üÀ¨ºËÐÄ (kernel) ÔÚÄÚ
     /boot/grub/menu.lst   GRUBÉèÖÃ
     /boot/vmlinuz   ÄÚºË
 &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ