《MYSQL教程mysql 常用設(shè)置 字符集編碼、自動(dòng)完成（自動(dòng)提示）、監(jiān)聽外網(wǎng)ip》要點(diǎn)：
本文介紹了MYSQL教程mysql 常用設(shè)置 字符集編碼、自動(dòng)完成（自動(dòng)提示）、監(jiān)聽外網(wǎng)ip，希望對(duì)您有用。如果有疑問，可以聯(lián)系我們。
設(shè)置mysql監(jiān)聽外網(wǎng)ip
代碼如下:
sudo vi /etc/my.cnf
bind-address = 127.0.0.1
設(shè)置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自動(dòng)提示,命令自動(dòng)完成,語法提示
代碼如下:
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一個(gè)庫,按tab鍵才能自動(dòng)提示.
說明：之前寫的文章太長,有重復(fù),違反DRY,現(xiàn)在整理出來.
轉(zhuǎn)載請(qǐng)注明本頁網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/4855.html
