Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

ProxoolÀ´Á¬½Ómysql½éÉÜ

±¾ÎÄÖ÷Òª½éÉÜÁ˲ÉÓÃProxoolÀ´Á¬½ÓmysqlµÄ·½·¨£¬Í¨¹ýjava  application·½Ê½¿ÉÒÔÑéÖ¤Êý¾Ý¿âµÄÁ¬½Ó¼°»ñÈ¡±íÖеÄÊý¾Ý¡£ÎªÁËÄܹ»Ó봫ͳµÄJDBC·½Ê½µÄÁ¬½Ó½øÐбȽϣ¬±¾ÎIJÉÈ¡ÁËÁ½ÖÖ·½Ê½½øÐÐÊý¾Ý¿âµÄÁ¬½Ó£¬´úÂëÈçÏ¡£
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java ......

mysqlÊý¾ÝÒÆÖ²


 
1.   ÔÚÆäËü»úÆ÷ÉÏÊ×ÏȰ²×°ºÃÐèÒªµÄmysql ºÍ¶ÔÓ¦µÄ¹ÜÀíÈí¼þ£¨ÉèÖõÄÃÜÂëºÍÔ´Êý¾Ý¿âÃÜÂëÒ»Ö£©
2.   ½«Ô´»úÆ÷ÉÏdataϵÄÊý¾Ý¿âÎļþ¼Ð£¨ÒÔÎҵĻúÆ÷ΪÀý£¬¾ÍÊÇrubberFactoryÎļþ¼Ð£¬ÆäÖУ¬
      Õâ¸öÎļþ¼ÐϵÄÊý¾ÝÎļþ¶¼ÊÇһЩ±í½á¹¹¶¨Ò壩¿½±´µ½Ä ......

Ò»¸ö¼òµ¥µÄASP.NET·ÃÎÊMySqlÊý¾Ý¿â

ÏÂÔØ ADO.NET Driver for MySQLMySql.Data.dll
°²×°ºó£¬ÔÚ°²×°Ä¿Â¼ÏÂÃæÕÒµ½Assemblies
Îļþ¼Ð£¬ÕÒµ½ MySql.Data.dll
(´ËÎļþÊÇ.Net·ÃÎÊMySQLÊý¾Ý¿âµÄÒ»¸öÇý¶¯£¬ÍêÈ«ADO.NETÊý¾Ý·ÃÎÊģʽ£¬ÓÉMySQL¹Ù·½Ìṩ£¬Óжà¸ö°æ±¾¿ÉÑ¡Ôñ¡£)
 Ñ§Ï°µÄÒ»¸öÁ´½Ó£ºhttp://www.cnblogs.com/wcfgroup/articles/1242256.html
´´½¨Ò»¸ö ......

Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ


Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ
1¡¢°ÑÖ÷¼ü¶¨ÒåΪ×Ô¶¯Ôö³¤±êʶ·ûÀàÐÍ
ÔÚmysqlÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪauto_incrementÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int auto_increment primary key not null, name varchar(15));
insert into customers(name) values("name1"),("nam ......

MySQL³£¼û×Ö·û´®º¯Êýѧϰ

1.reverse(str)º¯Êý: ·µ»Øµßµ¹×Ö·û˳ÐòµÄ×Ö·û´®str, ¸Ãº¯Êý¶Ô¶à×Ö½Ú¿É¿¿µÄ.
mysql> select * from user;
+----+------------------+
| id | name             |
+----+------------------+
|  1 | test      &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ