LinuxÏÂMysqlµÄ°²×°£¨Ò»£©
ÈçºÎÔÚLinuxϰ²×°mysqlµÄ¶þ½øÖÆÔ´´úÂë°ü--¸ß¼¶Óû§
¼¸ÌìÑо¿Á˺þã¬ÖÕÓÚ±»ÎÒÖªµÀÁËÈçºÎÔÚLinuxϰ²×°mysqlµÄ¶þ½øÖÆÔ´´úÂë°ü£¬×îÖÕ½â¾öÁËERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)µÄȨÏÞÎÊÌâ£¬ÕæµÄÊǸп®Íò·Ö°¡£¬Ö»Ïë°ÑËûд³öÀ´£¬ÈÃ×Ô¼ºÒÔºó²»ÒªÍü¼ÇÁË£¬ºÃÁË£¬·Ï»°²»¶à˵ÁË£¬¿´¿´Îҵݲװ²½Öè°É£¡
1.ÏÂÔØmysql-5.0.51a-linux-i686-glibc23.tar.gz£¬ÏÂÔØµØÖ·Îªhttp://download.unix-center.net/ ... i686-glibc23.tar.gz
2.°ÑÏÂÔØµÄÎļþ·ÅÔÚÄãµÄÖ÷Ŀ¼£¬ÔÚÖÕ¶ËÊäÈëls,ÈçÏÂ:
[root@localhost mysql]# ls
Desktop Documents Download Music mysql-5.0.51a-linux-i686-glibc23.tar.gz Pictures Public Templates Videos
3.È»ºóÓÃtar -zxvf mysql-5.0.51a-linux-i686-glibc23.tar.gzÃüÁî½âѹµ½µ±Ç°Ä¿Â¼£¬ÈçÏ£º
[root@localhost mysql]# tar -zxvf mysql-5.0.51a-linux-i686-glibc23.tar.gz
[root@localhost mysql]# ls
Desktop Download mysql-5.0.51a-linux-i686-glibc23 Pictures Templates
Documents Music mysql-5.0.51a-linux-i686-glibc23.tar.gz Public Videos
4.ÒòΪÓõÄÊÇÔ´´úÂ룬ËùÒÔÒª°ÑÎļþcopyµ½°²×°Ä¿Â¼/usr/local/Ï£¬²ÅÄÜÔËÐÐ!
[root@localhost mysql]# cp –rf mysql-5.0.51a-linux-i686-glibc23 /usr/local/
5.²é¿´ÏµÍ³ÓÐûÓа²×°¹ýmysql,²éÕÒrpm,ÈçÏÂ:
[root@localhost mysql]# rpm –qa | grep mysql
ÓеĻ°Ò»¸öÒ»¸öɾ³ýµô£¬ÓÃrpm -eÃüÁî,È»ºó²éÕÒһϲÐÁôµÄÎļþ:
[root@localhost mysql]# cd /
[root@localhost /]# find / -name mysql
Èç¹û²éÕÒµ½rm -rf filenameɾ³ý.
[root@localhost /]# find / -name my.cnf
Èç¹û²éÕÒµ½É¾³ý£¬Ò»°ãmy.cnfÊÇÔÚ/etc/my.cnfÕâÀï.
6.Á´½Óµ½mysql,ÈçÏ£º
[root@localhost /]# cd /home/mysql
[root@localhost mysql]# ln -s mysql-5.0.51a-linux-i686-glibc23 /usr/local/mysql
7.³õʼ»¯mysql±í¸ñ£¬°²×° mysql ĬÈÏÊý¾Ý¿â£¬ÈçÏ£º
[root@localhost mysql]# cd /usr/local/mysql
[root@localhost mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system ta
Ïà¹ØÎĵµ£º
Ê×ÏÈ£¬´ò¿ªMySQL Query Browser£¬ÔÚµ±Ç°TestÊý¾Ý¿âÏ£¬Ð½¨Ò»¸östudent±í£¬ÓÐÈçÏÂÊôÐÔ£º
create table student (name varchar(10),id int(2),sex varchar(10));
³ÌÐò¼ûÏ£º
package com.JDBC;
import java.sql.*;
public class JDBCTest {
public static void main(String[] args) {String driver = "com.mys ......
ÔÚÊý¾Ý¿â±íÖУ¬¶Ô×ֶν¨Á¢Ë÷Òý¿ÉÒÔ´ó´óÌá¸ß²éѯËÙ¶È¡£¼ÙÈçÎÒÃÇ´´½¨ÁËÒ»¸ö mytable±í£º
CREATE TABLE mytable(
ID INT NOT NULL,
username VARCHAR(16) NOT NULL
);
ÎÒÃÇËæ»úÏòÀïÃæ²åÈëÁË10000Ìõ¼Ç¼£¬ÆäÖÐÓÐÒ»Ìõ£º5555, admin¡£
ÔÚ²éÕÒusername="admin"µÄ¼Ç¼ SELECT * from mytable WHERE username='admin';ʱ£¬Èç¹ ......
1. ÔÚʹÓÃNavicat 8 for MySQL¿Í»§¶Ë´´½¨Êý¾Ý¿âʱ£¬±àÂëµÄÉèÖÃÈçÏÂͼ£º
2. ½«°²×°Ä¿Â¼F:\MySQL\MySQL Server 5.1Ï£¬my.iniÎļþÉèÖñäÁ¿Öµdefault-character-set=gbk £¨°üº¬Á½´¦£¬¿É²éÕÒdefault-character-set£©£¬È»ºóÖØÆôMYSQL·þÎñ¡£ ......
ÒÔmysql-noinstall-5.1.6(win32)ΪÀý
1>°ÑѹËõÎļþmysql-noinstall-5.1.6-alpha-win32.zip½âѹµ½Ò»¸öĿ¼Ï£¬ÔÚ»·¾³±äÁ¿ÖÐÉèÖÃMYSQL_HOME£¬°Ñ%MYSQL_HOME%\bin ¼Ó
Èëµ½ path¡£
2>´´½¨my.iniÅäÖÃÎļþ,ÄÚÈÝÈçÏ£º
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=...\mysql
datadir=...\mysql\data
my.iniÎ ......
Éý»ªÌṩÖÕÉíÃâ·ÑASP+access PHP+mysqlÐéÄâÖ÷»ú
Ò»£ºÉý»ªÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾,ÓëÉý»ªÍ¬ÔÚÕ¾³¤ÖÕÉíÃâ·Ñ¿Õ¼ä·ö³Ö¼Æ»®.
1¡¢×ð¾´µÄÓû§ÄúºÃ,Ò²ÐíÄú»¹ÔÚΪÿÄêÒ»½»µÄ¿Õ¼ä·ÑÓ÷¢³î,Ò²ÐíÄúÏë»ñµÃÒ»¸ö¸üÓÅÖʵĿռäÈ´²»ÏëͶÈëÌ«¶à,´ÓÏÖÔÚÆð ÕâЩÎÊÌ⽫ÓÈжø½â→Éý»ªÍøÂç←ÓëÉý»ªÍ¬ÔÚÕ¾³¤·ö³Ö¼Æ»®È«ÃæÆô¶¯¡£
2¡¢Ã»ÓÐ×¢²á¹«Ë¾ ......