mysql ȨÏÞÈçºÎÓýű¾±íʾ

ÎÒÔÚlinuxϸ³ÓèÈ«ÌåÓû§µÄÈ«ÏÞÒ»°ãÕâÑù½øÐУº

#mysql -uroot -p
Enter password:ÕâÀïÊäÈëÃÜÂë
mysql>use mysql;
mysql>grant all on *.* to root@'%' identified by 'password' with grant option;
mysql>exit;

µ«ÊÇÏÖÔÚÎÒÏëÓÃÒ»¸ö½Å±¾ÊµÏÖͬÑùµÄ¹¦ÄÜ£¬Ó¦¸ÃÈçºÎʵÏÖ£¿
¾Í±ÈÈçΪÓû§rootÌí¼ÓÃÜÂë¿ÉÒÔÓÃmysqladmin -u root password 'password',ÕâÑù¾Í¿ÉÒÔÔڽű¾ÀïÃæÓÃ

²»ÖªµÀÐÞ¸ÄȨÏÞÓÐûÓÐÕâÑùµÄÃüÁ»òÕßÓ¦¸ÃÀûÓÃʲôÆäËû·½·¨Í¨¹ý½Å±¾À´Ö´ÐÐ

---

¿ÉÒÔʹÓÃÂ¥Éϵķ½·¨

mysq -e ²ÎÊýÀ´Ö´ÐÐSQLÓï¾ä
BatchFile code:
C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uroot -p123 test -e "select count(*) from t1;select count(*) from t2;"
+----------+
| count(*) |
+----------+
| 100000 |
+----------+
+----------+
| count(*) |
+----------+
| 11 |
+----------+

C:\Program Files\MySQL\MySQL Server 5.1\bin>

---

ÒýÓÃ

mysql -uroot -pxxxx -e"grant all on *.* to root@'%' identified by 'password' with grant option"

¾ÍÊÇÕâ¸öÁË£¬¹þ¹þ

---

ÒýÓÃ

¿ÉÒÔʹÓÃÂ¥Éϵķ½·¨

mysq -e ²ÎÊýÀ´Ö´ÐÐSQLÓï¾ä
BatchFile codeC:\ProgramFiles\MySQL\MySQL Server5.1\bin>mysql -uroot -p123 test -e