linuxÖÐmysqlµÄÎÊÌâ
MYSQLÊý¾Ý¿â°²×°Ê±£¬ROOTµÄ³õʼÃÜÂëΪ¿Õ£¬ÎÒÉèÖÃÁËROOTµÄÃÜÂëºó£»Á¬½ÓMYSQL¾Í³öÏÖÁË´íÎó£¨ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)£©£¬µÇ½²»ÁË£¬ÎÒÔÚÍøÉϲ鵽½â¾ö·½·¨£¬ÐèÒª·ÖÅäÒ»ÏÂȨÏÞ£¬Ê¹ÓÃÒÔÏÂÓï¾ä:grant all on mysql.* to 'root'@'localhost' identified by 'password'; ÎÊÌâÊÇÎÒÏÖÔÚû°ì·¨µÇ¼µ½mysqlÃüÁîÐÐģʽ£¬ÒªÔõôÔËÐиÃÓï¾ä°¡
²»Ó÷¢2´Î°¡
µÇ¼mysqlµÄrootÓû§ÃÜÂë¸ÄÁË ²»ÐèÒªgrant all on mysql.* to 'root'@'localhost' identified by 'password';ÕâÑù°É
ÄãÁ¬½ÓÊäÈëµÄmysqlÃüÁîÊÇʲô
ÖÕ¶ËÏ£º
mysql -uroot -ppassowrd
OOTµÄ³õʼÃÜÂëΪ¿Õ£¬ÎÒÉèÖÃÁËROOTµÄÃÜÂëºó£»
ÄãÊÇÔõôÉèÖÃÃÜÂëµÄ£¿Í¼ÐνçÃæ£¿ÃüÁ
Ò»°ãµÄ¹ý³ÌÊÇ
yum install mysql-server mysql
service mysqld start
mysqladmin -uroot password "password"
mysql -uroot -p
ÊäÈë¸Õ²ÅµÄÃÜÂë
Èç¹ûÒª¿ª»úÆô¶¯µÄ»°ÐèÒªchkconfig mysqld on
µÇ¼µÄÃüÁîΪ£ºmysql -uroot -p£¬È»ºóÌáʾÄãÊäÈëÃÜÂë¡£
µÚÒ»´ÎÌý˵rootÒ²ÓÐÏÞÖÆ¡¡
mysqlÃüÁîÐÐģʽ ¶¼½ø²»ÁË ÔõôÇÃÃüÁ£¿£¿£¿
1.Äã²»ÊäÈëÃÜÂëÊÔÊÔ¡£
2.»»±ðµÄ»úÆ÷µÇ¼ÊÔÊÔ¡£
ÒòΪmysqlµÄÃÜÂëÊÇÕë¶ÔÌØ¶¨µÄÖ÷»úºÍÓû§µÄ£¬¾ÍÊÇ˵root@localhostºÍroot@192.168.0.1¿ÉÄܲ»ÊÇͬһ¸öÃÜÂë¡£
ËùÒÔ»»Ì¨»úÆ÷Á¬½ÓÐËÐí¿ÉÒÔÁ¬ÉÏ¡£
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÔÚ×Ô¼ºµÄµçÄÔÉϰ²×°ÁËubuntu ¾ÍÊÇÏëÍæÒ»ÏÂ3D×ÀÃæ£¬ÓÚÊÇÏÂÔØÁË
compizconfig-settings-manager
emerald
simple-ccsm
fusion
ÕâЩ¶«Î÷£¬°²×°ÍêÖ®ºó£¬ÎÒÔÚµçÄÔÀïµã»÷ÁËemerald ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
ÏÖÔÚÐèÒªÔÚÒ»¸öǶÈëʽϵͳÖÐʵÏÖʱ¼äº¯Êý£¬±àÒëÆ÷δÌṩtime¿âº¯Êý£¬ÇëÎÊ´ó¼ÒÈçºÎÓÃcÓïÑÔʵÏÖʱ¼äº¯Êý°¡£¿
ÄêÔÂÈÕʱ·ÖÃë µ½ ÕûÊýÃ루´Ó1970Ä꿪ʼ£© Ö®¼äµÄÏà¹Ø×ª»»°¡
ÀàËÆmktime ºÍlocaltimeµÄ¹¦ÄÜ£¬Ð»Ð»
mktime ......