¹ØÓÚ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';
Ïà¹ØÎĵµ£º
1.apacheµÄ°²×°
apache±¾À´ÊÇÏëÓñàÒë°²×°µÄ£¬µ«ÊÇÆädevelÐèÒªÒÀÀµÒ»Ð©ÆäËûµÄ°ü£¬°²×°ÆðÀ´Ì«Âé·³£¬ËùÒÔ¾ö¶¨Ê¹Óñ¾µØyumÔ´°²×°£»ÔÚrhel5u3ÉÏ£¬Ö±½Ó yum install httpd
yum install httpd-devel
ÕâÑù»áÓÐhttpd-develµÄһЩÒÀÀµ°üÒ»²¢°²×°ÁË£»
rpm°²×°µÄhttpdÓÐÈçϼ¸¸öÖØÒªµÄĿ¼£º
1)/etc/ht ......
±ÏÒµÉè¼ÆµÄ³ÌÐòÖ÷Ìå±àºÃÁË£¬ÔËÐÐÉÙÁ¿Êý¾ÝûÓÐÈκÎÎÊÌ⣬һµ©Êý¾ÝÁ¿Ôö¼Óµ½22w£¬ÔËÐÐʱ¼ä¾Í³¤µÃÁîÈË·¢Ö¸¡£µ¼Ê¦½¨Ò飬³ÌÐòÖо¡¿ÉÄܵؼõÉÙÓëÊý¾Ý¿â½»»¥µÄ´ÎÊý£¬¾¡¿ÉÄܵذѹ¤×÷¶ª¸øÊý¾Ý¿âÍê³É¡£ÔÚÕâһ˼ÏëµÄÖ¸µ¼Ï£¬ÎÒÈýÌì´ó·ùÐ޸ijÌÐò£¬²¿·Ö´úÂ뼸ºõÊÇ·ÐÂÁËÒ»±é¡£×ܵÄÀ´Ëµ£¬ÔËÐÐʱ¼äȷʵµÃµ½ÁË ......
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 ......
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Îļþ¿ ......
¡¡ÏÖÔÚʹÓÃMySQLµÄÔ½À´Ô½¶àÁË£¬ÎÒÒ²ÓÃËü×öÁË×ÔÒѵÄÁôÑÔ°å¡£ÔÚʹÓùý³ÌÖУ¬
ÂýÂýµØ
¾ÍÒªÇó¶ÔËüµÄ¹ÜÀí
¹¦ÄÜÐèÒª½üÒ»²½µÄÕÆÎÕ£¬²»½öÊÇÎÒ£¬Ò²ÊǺܶàÍøÓѵÄÒªÇó¡£ÏÖÔÚÓÐһЩÎÊÌâÊǹØ
ÓÚÈçºÎ
´ÓMySQLÖе¼³öÊý¾Ý£¬
ÒÔ±ãÓÃÔÚ±¾µØ»òÆäËüµÄÊý¾Ý¿âϵͳ֮ÉÏ£»ÒÔ¼°½«ÏÖÓÐÊý¾Ýµ¼ÈëMySQLÊý¾Ý¿âÖ ......