ÂÌÉ«°æ±¾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';
{{
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý
Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......