¹ØÓÚMySQLµÄÓû§²Ù×÷
Ò»¡¢²é¿´Óû§
1¡¢ÏÔʾµ±Ç°Ê¹ÓõÄuser¼°host£º
mysql>select USER();
2¡¢ÏÔʾ¸ÃÊý¾Ý¿âÊÚȨµÇ½µÄÓû§Ãû(²»ÏÔÊ¾ÖØ¸´Óû§Ãû)£º
mysql>use mysql;
mysql>select distinct(User) from user;
3¡¢ÏÔʾ¸ÃÊý¾Ý¿âÊÚȨµÇ½µÄÓû§Ãû¼°hostÏÞÖÆ£º
£¨1£©·½·¨Ò»£º
mysql>use mysql;
mysql>select User,host from user;
£¨2£©·½·¨¶þ
mysql>select user,host from mysql.user;
4¡¢ÏÔʾ¸ÃÊý¾Ý¿âÊÚȨµÇ½µÄÓû§µÄÈ«²¿ÐÅÏ¢£º
mysql>select * from mysql.user;
5¡¢ÁгöΪijMySQLÓû§ÕË»§¸´ÖÆÈ¨ÏÞʱ±ØÐë·¢²¼µÄGRANTÓï¾ä£º
mysql>show grants for 'username'@'yourhost';
¶þ¡¢Ìí¼ÓÓû§
1¡¢Ìí¼ÓÒ»¸ö±¾µØ¹ÜÀíÔ±Óû§:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'somepassword' WITH GRANT OPTION;
2¡¢Ìí¼ÓijÊý¾Ý¿âµÄ¹ÜÀíÔ±Óû§:
mysql> GRANT ALL PRIVILEGES ON databasename.* TO username@localhost IDENTIFIED BY 'somepassword';
3¡¢Ìí¼ÓÔ¶³ÌÓû§:
mysql> GRANT ALL PRIVILEGES ON *.* TO username@192.168.8.9 IDENTIFIED BY 'somepassword';
4¡¢Ìí¼ÓÈκλúÆ÷¶¼ÄܵǼµÄÓû§:
mysql> GRANT ALL PRIVILEGES ON *.* TO username@% IDENTIFIED BY 'somepassword';
5¡¢Ìí¼ÓÒ»¸öÓû§²¢ÊÚȨÔö¡¢É¾¡¢¸Ä¡¢²é£º
mysql> GRANT select,delete,insert,update ON databasename.* TO username@localhost IDENTIFIED BY 'somepassword';
Èý¡¢É¾³ýÓû§
1¡¢È¡ÏûÒ»¸öÓû§µÄȨÏÞ£¬´ËÓû§ÈÔÈ»±£Áô
mysql>revoke all on *.* from username@localhost;
2¡¢É¾³ýÒ»¸öÓû§
mysql>DELETE from user WHERE User='user_name' and Host='host_name';
Ïà¹ØÎĵµ£º
´ÓÍøÂçÕª³µ½µÄ½â¾ö·½·¨——
½â¾ö·½·¨¶þ£º
Á¬½Ómysqlʱ(ÎÞÂÛÔÚ´Ómysql¶Á»¹ÊÇÈ¡Êý¾ÝµÄÇé¿ö)£¬Ö¸¶¨Ê¹ÓõıàÂ뷽ʽΪutf-8£¬¾ßÌå´úÂëÈçÏÂ
//×°ÔØmysql-jdbcÇý¶¯
Class.forName("com.mysql.jdbc.Driver" ......
Êý¾Ý²Ö¿âÖ®¸¸Bill InmonÔÚ1991Äê³ö°æµÄ“Building the Data
Warehouse”Ò»ÊéÖÐËùÌá³öµÄ¶¨Òå±»¹ã·º½ÓÊÜ——Êý¾Ý²Ö¿â£¨Data Warehouse£©ÊÇÒ»¸öÃæÏòÖ÷ÌâµÄ£¨Subject
Oriented£©¡¢¼¯³ÉµÄ£¨Integrated£©¡¢Ïà¶ÔÎȶ¨µÄ£¨Non-Volatile£©¡¢·´Ó³ÀúÊ·±ä»¯£¨Time
Variant£©µÄÊý¾Ý¼¯ºÏ£¬ÓÃÓÚÖ§³Ö¹ÜÀí¾ö²ß(D ......
Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ
1¡¢°ÑÖ÷¼ü¶¨ÒåΪ×Ô¶¯Ôö³¤±êʶ·ûÀàÐÍ
ÔÚmysqlÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪauto_incrementÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int auto_increment primary key not null, name varchar(15));
insert into customers(name) values("name1"),("nam ......
ÔÚÒìµØµÄ·þÎñÆ÷±¸·ÝMysqlʱ£¬ÒìµØµÄ·þÎñÆ÷ûÓа²×°MysqlÊý¾Ý¿â£¬±¸·ÝµÄmysqldumpÃüÁîÊDz»ÄÜÉúЧµÄ¡£ËùÒÔ¿ÉÒ԰Ѱ²×°mysqlÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÖеÄmysqldump.exe£¨È磺C:\Program Files\MySQL\MySQL Server 5.0\binĿ¼ÖеÄmysqldump.exe£©¿½±´µ½ÒìµØ·þÎñÆ÷ÖеÄÒ»¸öĿ¼ÖУ¨È磺F:\MySQLBackup£©¡£
±ÈÈçÎļþà ......
1. Êý¾Ý¿âµÄ²¿Êð
£¨1£©Èí¼þµÄ°²×°
A. MySql——±ØÐë°²×°ÔÚCÅÌÏ£¬·ñÔò°²×°mysql-connector-net-6.2.2ºóÎÞÕýÈ·ÅäÖÃ
B. mysql-connector-net-6.2.2——½«MySql.Data.dll·ÅÔÚBinÎļþ¼ÐÏÂ
£¨2£©Êý¾Ý¿âµÄµ¼³öµ¼Èë
MySQL-FrontµÄ"Áí´æÎª"¹¦ÄÜ¿ÉÒÔ½«Êý¾Ý¿âµ¼³öΪ.sqlÎļþ£¬È»ºóÔÙͨ¹ýËüÖ±½Óµ¼Èë.sqlÎļþ¿ ......