(ת)MySQL¸ü¸Ä/ÐÞ¸ÄrootÃÜÂëµÄÈýÖÖ·½·¨
1¡¢±à¼MySQLÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖУº
/etc/init.d/MySQLd restart
3¡¢ÉèÖÃеÄROOTÃÜÂë
È»ºóÔÙÔÚÃüÁîÐÐÏÂÖ´ÐУº
MySQL-uroot -p MySQL
Ö±½Ó»Ø³µÎÞÐèÃÜÂë¼´¿É½øÈëÊý¾Ý¿âÁË¡£
ÏÖÔÚÎÒÃÇÖ´ÐÐÈçÏÂÓï¾ä°ÑrootÃÜÂë¸üÐÂΪ 123456£º
update user set password=PASSWORD("123456") where user='root';
quit Í˳öMySQL¡£
4¡¢»¹ÔÅäÖÃÎļþ²¢ÖØÆô·þÎñ
È»ºóÐÞ¸ÄMySQLÅäÖÃÎļþ°Ñ¸Õ²ÅÌí¼ÓµÄÄÇÒ»ÐÐɾ³ý¡£
ÔÙ´ÎÖØÆðMySQL·þÎñ£¬ÃÜÂëÐÞ¸ÄÍê±Ï¡£
µÚÒ»ÖÖ£º mysql>UPDATE user SET Password=PASSWORD(’new_password’) WHERE user=’root’;
mysql>FLUSH PRIVILEGES;
µÚ¶þÖÖ£º
mysql>SET PASSWORD FOR root=PASSWORD(’new_password’);
µÚÈýÖÖ£º
shell>mysqladmin -u root password new_password;
×ÊÁÏÀ´×Ô: Öйú×ÔѧÍø(Www.CnZiXue.Com) Ïêϸ³ö´¦²Î¿¼£ºhttp://www.cnzixue.com/html/web/DataBase/2009/1107/3526.html
Ïà¹ØÎĵµ£º
Query ProfilerÊÇMYSQL×Ô´øµÄÒ»ÖÖqueryÕï¶Ï·ÖÎö¹¤¾ß£¬Í¨¹ýËü¿ÉÒÔ·ÖÎö³öÒ»ÌõSQLÓï¾äµÄÐÔÄÜÆ¿¾±ÔÚʲôµØ·½¡£Í¨³£ÎÒÃÇÊÇʹÓõÄexplain,ÒÔ¼°slow query log¶¼ÎÞ·¨×öµ½¾«È··ÖÎö£¬µ«ÊÇQuery ProfilerÈ´¿ÉÒÔ¶¨Î»³öÒ»ÌõSQLÓï¾äÖ´Ðеĸ÷ÖÖ×ÊÔ´ÏûºÄÇé¿ö£¬±ÈÈçCPU£¬IOµÈ£¬ÒÔ¼°¸ÃSQLÖ´ÐÐËùºÄ·ÑµÄʱ¼äµÈ¡£²»¹ý¸Ã¹¤¾ßÖ»ÓÐÔÚMYSQL 5.0.37ÒÔ ......
DAT_E,TIM_E,DAT_ETIME,TIM_ESTAMP,Y_EAR
MySQLÖ§³Ö¶àÖÖ¸ñʽ»¯·½Ê½£¬²åÈëʱ¿ÉÒÔÊÇ×Ö·û´®£¬¿ÉÒÔʹÊý×Ö¡£
MySQL´ú±í×Ö·û´®µÄ·½Ê½ÓÐÁ½ÖÖ£¬Ò»Êǵ¥ÒýºÅ£¬ÁíÒ»ÖÖÊÇË«ÒýºÅ¡£
ÓÖÒ»´ÎÌύʧ°Ü£¬¿´À´CSDNµÄBUG»¹ÊǺܴóµÄ¡£
ÔÒò»ù±¾È·¶¨£¬ÊÇÒòΪDATE£¬TIME£¬DATETIME£¬TIMESTAMP£¬YEARΪMySQLÊý¾ÝµÄ¹Ø¼ü×Ö£¬Ò²ÊÇÆäËûÊý¾Ý¿âµÄ¹Ø¼ü× ......
linux
mysql
°²×°½éÉÜ:
linux
·þÎñÆ÷ RedHat 5.0.server.
MySQL
°æ±¾:
ÏÂÔصØÖ·Á´½Ó:http://dev.mysql
.com/downloads/mysql
/5.1.html
MySQL
·þÎñ¶Ë:MySQL
-server-community-5.1.38-0.rhel5.i386.rpm
MySQL
¿Í»§¶Ë:MySQL
-client-community-5.1.38-0.rhel5.i386.rpm
1 °²×°²½ÖèÊ×ÏȼÓÔعâÇý ......
//µ¼³ö
String mysql="mysqldump -uroot -proot --opt databasename > d:/test.sql";
java.lang.Runtime.getRuntime().exec("cmd /c "+mysql);
//µ¼Èë
String mysql="mysqladmin -uroot -proot create databasename";
java.lang.Runt ......