《MYSQL教程mysql 常用設置 字符集編碼、自動完成（自動提示）、監聽外網ip》要點：
本文介紹了MYSQL教程mysql 常用設置 字符集編碼、自動完成（自動提示）、監聽外網ip，希望對您有用。如果有疑問，可以聯系我們。
設置mysql監聽外網ip
代碼如下:
sudo vi /etc/my.cnf
bind-address = 127.0.0.1
設置mysql 字符集 charset
代碼如下:
sudo vi /etc/my.cnf
在[mysqld]下面加入一行
character_set_server = utf8
在[mysql]下面加入一行
default-character-set = utf8
sudo /usr/local/mysql/support-files/mysql.server restart
mysql -uroot -p1
mysql> status
Server characterset:?utf8
Db???? characterset:?utf8
Client characterset:?utf8
Conn.? characterset:?utf8
mysql> show variables like 'character_set%';
+--------------------------+----------------------------------+
| Variable_name??????????? | Value??????????????????????????? |
+--------------------------+----------------------------------+
| character_set_client???? | utf8???????????????????????????? |
| character_set_connection | utf8???????????????????????????? |
| character_set_database?? | utf8???????????????????????????? |
| character_set_filesystem | binary?????????????????????????? |
| character_set_results??? | utf8???????????????????????????? |
| character_set_server???? | utf8???????????????????????????? |
| character_set_system???? | utf8???????????????????????????? |
| character_sets_dir?????? | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)
mysql自動提示,命令自動完成,語法提示
代碼如下:
sudo vi /etc/my.cnf
找到[mysql]
[mysql]
#no-auto-rehash
auto-rehash
sudo /usr/local/mysql/support-files/mysql.server restart
mysql -uroot -p1
use mysql
必須先use一個庫,按tab鍵才能自動提示.
說明：之前寫的文章太長,有重復,違反DRY,現在整理出來.
轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/4855.html
