¹ØÓÚ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';
Ïà¹ØÎĵµ£º
×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë
/**
* µ¼ÈëÊý¾Ý
* @param ½Å±¾µÄµØÖ·ºÍÃû³Æ
* @return ÊÇ·ñ³É¹¦&nb ......
mysql±àÂëӦעÒâµÄ»·½Ú£º
Õ⼸¸ö»·½Ú±àÂ붼ͳһÁË£¬Ò»°ã²»»á³öÏÖÂÒÂë¡£BTW:
¿ÉÒÔÓÃSET NAMES xÁÙʱÉèÖÃmysql±àÂ룺
Ï൱ÓÚ
SET character_set_client = x;
SET character_set_results = x;
SET character_set_connection = x;
È磺
mysql_query("SET NAMES 'gb2312'") or die("Query failed : " . mysql_er ......
mysqlÍü¼ÇrootÃÜÂëµÄ½â¾ö
Ò». MySQLÃÜÂëµÄ»Ö¸´·½·¨Ö®Ò»
Èç¹ûÍü¼ÇÁËMySQLµÄrootÃÜÂ룬¿ÉÒÔÓÃÒÔÏ·½·¨ÖØÐÂÉèÖãº
1. KILLµôϵͳÀïµÄMySQL½ø³Ì£»
killall -TERM mysqld
2. ÓÃÒÔÏÂÃüÁîÆô¶¯MySQL£¬ÒÔ²»¼ì²éȨÏ޵ķ½Ê½Æô¶¯£»
safe_mysqld --skip-grant-tables &
3. È»ºóÓÿÕÃÜÂ뷽ʽʹÓÃrootÓû§µÇ¼ MySQL£»
......
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØ
Ö·£º
http://sourceforge.net/projects/mysqldrivercs/
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½
MySQLDriver.dll
£¬È»ºó½«
MySQLDriver.dll
Ìí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ
MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using
S ......
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Îļþ¿ ......