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

ÂÌÉ«°æ±¾mysql³õʼ»¯´´½¨Óû§µÄÎÊÌâ

´ò¿ªºÚ´°¿Ú£¬Ìáʾ£º
Welcom to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version:5.1.37-community MySQL Community Server <GPL>

Type 'help;' or '\h' for helt. Type '\c' to clear the current input statement.

mysql>


Õâ¸ö״̬ÎÒÊÇÒѾ­µÇ½ÁËô£¿Óû§ÃûÃÜÂëÊǶàÉÙ°¡¡£¡£¡£¡£ÎÒÏë´´½¨¸öÐÂÓû§£ºaaa,ÃÜÂëÊÇ123456£¬¸ÃÔõô×ö£¿
ÒѾ­µÇ¼ÁË¡£
grant all on *.* to 'aaa'@'%' identified by '123456';

°´ÕÕ1¥д·¨³ö±¨´íÌáʾÒô
ÏÔʾ£º
ERROR 1045 <28000>:Access denied for user ''@'localhost' <using password: NO>
mysql>

ÒªÊǶÔÃüÁî²»ÊìϤµÄ»°ÕÒ¸ö´°¿Ú³ÌÐòÁ¬ÉÏÈ¥£¬ÓÃÊó±êн¨Ò»¸öÄãÐèÒªµÄÓû§

ÄÇÂ鷳˭¸ø¸öºÃÓõĴ°¿Ú³ÌÐò°É¡£¡£¡£

»»³ÉÕâÌõÊÔÊÔ£º
grant all on *.* to 'aaa'@'localhsot' identified by '123456';
{{


Ïà¹ØÎÊ´ð£º

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......

´Ómysql¶ÁͼƬ·¾¶µ«ÊÇÎÞ·¨ÏÔʾ

´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:

<?php
$str="select * from product wh ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

Çë½Ì£ºÇ¶Èëʽϵͳ°²×°MySQLÊý¾Ý¿âµÄÎÊÌâ

½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ