日期:2014-05-16  浏览次数:20696 次

解决 Ubuntu mysql 非本机连接
cd /etc/mysql
vi my.cnf

lower_case_table_names=1  //顺带这里加上 不区分表名大小心
user            = mysql
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1  //注释掉此段
#
# * Fine Tuning
#
key_buffer   

ESC : wq
service mysql restart OK