操作系统：Redhat Enterprise Linux 6.2 1. 创建用户、目录和修改权限 # mkdir -p /usr/local/mysql/data # groupadd mysql # useradd -g mysql
2014-01-13
1. 查看字符集： mysql> show variables like 'collation_%'; +----------------------+-------------------+ | Variable_name | Value | +------------------
2013-09-26
1. 停止mysql服务：# /etc/init.d/mysqld stop 2. 创建目录：# mkdir /data 3. 移动默认的mysql数据至/data：# mv /var/lib/mysql/ /data/ 4. 从/usr/share/mysql/拷贝一个配置文件至/etc/命
2013-09-26
[root@localhost ~]# mysql -u root -p mysql> use mysql mysql> update user set `Host` = '%' where `User` = 'root' limit 1; //开启远程访问 mys
2013-09-26
[root@localhost ~]# mysql -u root -p mysql> use mysql mysql> update user set password=password("newpassword"); &
2013-09-26
环境：CentOS 6.0_x64 开放端口：编辑/etc/sysconfig/iptables添加以下记录，保存后重启防火墙 -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
2013-09-24