debian mysql 允许外部链接方法
1 modify the /etc/mysql/my.cnf
# 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
#
you see the bind-address, comment it. 注掉它。
2 update the database -- mysql.
shell > mysql -uroot -p
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| mysql |
+--------------------+
5 rows in set (0.00 sec)
mysql> select t.host, t.user from user t;
+-----------+------------------+
| host | user |
+-----------+------------------+
|127.0.0.1 | debian-sys-maint |
|127.0.0.1 | james |
| 127.0.0.1 | root |
| debian | root |
| localhost | root |
+-----------+------------------+
5 rows in set (0.00 sec)
mysql > update user set host='%' where user='yourUsername';
mysql > flush privileges;
remark:
if wanna create user please follow:
create user 'james'@'%' identified by 'password';
相关文档:
在mysql的slow query log中,可能存在类似这样的特殊记录:
# Time: 100127 23:17:01
# User@Host: root[root] @ [127.0.0.1]
# Query_time: 18446744073709.351562 Lock_time: 0.000129 Rows_sent: 1 Rows_examined: 11030
SET timestamp=1264663021;
SELECT dummy.id AS dummy_id
from dummy&nbs ......
笔者(mqboss)近期在做MySQL集群的技术调研,会陆续把自己的心得体会写出来和大家分享,请大家继续关注。
1.从mysq官方网站下载安装文件mysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.tar.gz,并通过FTP上传到Solaris服务器上;
2.添加用户组mysql和用户mysql(注:mysql用户属于mysql用户组)
shell> groupadd mys ......
用InstallAnywhere打包Java程序包含MySQL数据库
InstallAnywhere打包Java程序时可以自动完成jre的打包,但是需要MySQL数据库的程序就得手动添加。资料太少,纠结了三天,终于解决
1、 下载绿色版的MySQL,可以去官网下载。网友制作了MySQL的绿色精简Bat版(http://download.csdn.net/source/524812),可以 ......
MySQL+PHP产生乱码原因:
◆ MySQL数据库默认的编码是utf8,如果这种编码与你的PHP网页不一致,可能就会造成MySQL乱码;
◆ MySQL中创建表时会让你选择一种编码,如果这种编码与你的网页编码不一致,也可能造成MySQL乱码;
◆ MySQL创建表时添加字段是可以选择编码的,如果这种编码与你的网页编码不一致,也可能造成MySQ ......