推薦：mysql中alter數據表中增加、刪除字段與表名修改例子
alter是非常強大的一個功能我們可以利用alter來修改數據表表名字體名及一些其它的操作了，下面一起來看看mysql中alter數據表中增加、刪除字段與表名修改的一個例子． 修改刪除mysql數據庫中的數據內容： [root@hk ~]# /usr/local/mysql/bin/mysql -uroot -p'admin' #進

用戶授權在mysql中使用grant命令就可以了，我相信各位都會有了解過了，下面小編為各位介紹一個Mysql下建立用戶授權權限例子，希望本文章對各位有幫助．    

建立用戶，授權數據庫：

mysql> create user 'byrd'@'localhost' identified by 'admin123';    #建立主機為localhost，密碼為admin123的用戶byrd
Query OK, 0 rows affected (0.05 sec)
mysql> show grants for 'byrd'@'localhost';    #查看byrd權限，USAGE表示連接權限
+-------------------------------------------------------------------------------------------------------------+
| Grants for byrd@localhost                                                                                   |
+-------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'byrd'@'localhost' IDENTIFIED BY PASSWORD '*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C' |
+-------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select user,host from mysql.user;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1       |
| root | lamp      |
| byrd | localhost |
| root | localhost |
+------+-----------+
5 rows in set (0.00 sec)
mysql> grant all on gbk.* to 'byrd'@'localhost';    #用戶byrd、主機localhost對數據庫gbk擁有所有權限
Query OK, 0 rows affected (0.01 sec)

mysql> show mysqls for 'byrd'@'localhost';
+-------------------------------------------------------------------------------------------------------------+
| Grants for byrd@localhost                                                                                   |
+-------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'byrd'@'localhost' IDENTIFIED BY PASSWORD '*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C' |
| GRANT ALL PRIVILEGES ON `gbk`.* TO 'byrd'@'localhost'                                                       |
+-------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> flush privileges;
mysql> grant all on gbk.* to test@'localhost' identified by 'admin123';    #建立用戶test，用戶gbk數據庫所有權限，同上
mysql> show grants for 'test'@'localhost';
+-------------------------------------------------------------------------------------------------------------+
| Grants for test@localhost                                                                                   |
+-------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'test'@'localhost' IDENTIFIED BY PASSWORD '*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C' |
| GRANT ALL PRIVILEGES ON `gbk`.* TO 'test'@'localhost'                                                       |
+-------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
遠程連接同上：

分享：Mysql大小寫敏感的問題
一、1 CREATE TABLE NAME(name VARCHAR(10)); 對這個表，缺省情況下，下面兩個查詢的結果是一樣的： 代碼如下: SELECT * FROM TABLE NAME WHERE name='clip'; SELECT * FROM TABLE NAME WHERE name='Clip'; MySql默認查詢是不區分大小寫的,如果需要區分他,必須在建表的