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

Mysql³õʼ»¯rootÃÜÂëºÍÔÊÐíÔ¶³Ì·ÃÎÊ

Mysql³õʼ»¯rootÃÜÂëºÍÔÊÐíÔ¶³Ì·ÃÎÊ
mysqlĬÈÏrootÓû§Ã»ÓÐÃÜÂ룬ÊäÈëmysql –u root ½øÈëmysql
1¡¢³õʼ»¯rootÃÜÂë
½øÈëmysqlÊý¾Ý¿â
1
mysql>update user set password=PASSWORD(‘123456’) where User='root';
2¡¢ÔÊÐímysqlÔ¶³Ì·ÃÎÊ,¿ÉÒÔʹÓÃÒÔÏÂÈýÖÖ·½Ê½:
a¡¢¸Ä±í¡£
1
mysql -u root –p
2
mysql>use mysql;
3
mysql>update user set host = '%' where user = 'root';
4
mysql>select host, user from user;
b¡¢ÊÚȨ¡£
ÀýÈ磬ÄãÏërootʹÓÃ123456´ÓÈκÎÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷¡£
1
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Èç¹ûÄãÏëÔÊÐíÓû§jack´ÓipΪ10.10.50.127µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃ654321×÷ΪÃÜÂë
1
mysql>GRANT ALL PRIVILEGES ON *.* TO 'jack'@’10.10.50.127’ IDENTIFIED BY '654321' WITH GRANT OPTION;
2
mysql>FLUSH RIVILEGES
c:ÔÚ°²×°mysqlµÄ»úÆ÷ÉÏÔËÐУº
1
//½øÈëMySQL·þÎñÆ÷
2
d:\mysql\bin\>mysql -h localhost -u root
3
//¸³ÓèÈκÎÖ÷»ú·ÃÎÊÊý¾ÝµÄȨÏÞ
4
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION
5
//ʹÐÞ¸ÄÉúЧ
6
mysql>FLUSH PRIVILEGES
7
//Í˳öMySQL·þÎñÆ÷
8
mysql>EXIT


Ïà¹ØÎĵµ£º

mysql µÇ¼£¬ÖØÆô

Mysql怬
µÇ¼MySQLµÄÃüÁîÊÇmysql£¬ mysql µÄʹÓÃÓï·¨ÈçÏ£º
¡¡¡¡mysql [-u username] [-h host] [-p[password]] [dbname]
¡¡¡¡username Óë password ·Ö±ðÊÇ MySQL µÄÓû§ÃûÓëÃÜÂ룬mysqlµÄ³õʼ¹ÜÀíÕʺÅÊÇroot£¬Ã»ÓÐÃÜÂ룬עÒ⣺Õâ¸örootÓû§²»ÊÇLinuxµÄϵͳÓû§¡£MySQLĬÈÏÓû§ÊÇroot£¬ÓÉÓÚ³õʼûÓÐÃÜÂ룬µÚÒ»´Î½øÊ± ......

mysql´æ´¢¹ý³Ì

1¡¢Ð½¨±ítest create table test1( field1 int not null ) ENGINE=MyISAM DEFAULT CHARSET=gbk; insert into test1(field1) values(1); 2¡¢É¾³ýÒÑ´æÔڵĴ洢¹ý³Ì -- ɾ³ý´¢´æ¹ý³Ì delimiter // -- ¶¨Òå½áÊø·ûºÅ drop procedure p_test; 3¡¢mysql´æ´¢¹ý³Ì¶¨
1¡¢Ð½¨±ítest
create table test1(
field1 int not null
)
......

¸ßЧµÄMySQL·ÖÒ³

PERCONA PERFORMANCE CONFERENCE 2009ÉÏ£¬À´×ÔÑÅ»¢µÄ¼¸Î»¹¤³Ìʦ´øÀ´ÁËһƪ”Efficient Pagination Using MySQL“µÄ±¨¸æ£¬ÓкܶàÁÁµã£¬±¾ÎÄÊÇÔÚÔ­ÎÄ»ù´¡ÉϵĽøÒ»²½ÑÓÉì¡£
Ê×ÏÈ¿´Ò»Ï·ÖÒ³µÄ»ù±¾Ô­Àí£º
mysql> explain SELECT * from message ORDER BY id DESC LIMIT 10000, 20\G
***************** 1. row ** ......

ÈçºÎ°²×°mysql plugin


¡¡¡¡1¡¢°²×°Plugin
¡¡¡¡Óï·¨ÈçÏ£º INSTALL PLUGIN plugin_name SONAME 'plugin_library'
¡¡¡¡ÊµÀý£º
¡¡¡¡Mysql>INSTALL PLUGIN  Archive    SONAME ‘ha_archive.so’;
¡¡¡¡Mysql>INSTALL PLUGIN  InnoDB    SONAME ‘ha_innodb.so’;
¡¡
¡¡p ......

LINUXÏÂmysql¿Í»§¶Ë²»ÄÜÊäÈëÖÐÎÄ

LINUXÏ mysql¿Í»§¶Ë²»ÄÜÊäÈëÖÐÎÄ
½ñÌìÓöµ½ÁËÕâ¸öÎÊÌ⣬ÔÚLINUXÏÂÊäÈëÖÐÎÄ£¬Ã»ÓÐÎÊÌ⣬µ«ÔÚMYSQL¿Í»§¶ËÉÏÎÞ·¨ÊäÈëÖÐÎÄ£¬ºÜÆæ¹Ö£¿
ÕÒÁ˺ܶà×ÊÁÏÖÕÓÚ½â¾öÁËÕâ¸öÎÊÌ⣬ÆäʵÕâ¸öºÍ×Ö·û¼¯Î޹ء£Í¨³£³öÏÖÔÚ×Ô¼º±àÒëµÄmysql°æ±¾ÉÏ£¬Èç¹ûÊÇREDHATµÄ»°£¬ÇëʹÓÃϵͳ×Ô´øMYSQL¿Í»§¶Ë¡£ÏµÍ³Ä¬ÈÏrpm°²×°µÄmysqlÔòûÓÐÕâ¸öÎÊÌâ³öÏÖ¡£
Á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ