地址:http://blog.goyiyo.com/archives/1381
默认使用centos yum安装的mysql不是5.5版本的,我们需要增加两个新的repo
rpm -Uvh http://mirror.steadfast.net/epel/6/i386/epel-release-6-8.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
查看一下是不是有mysql 5.5了
yum --enablerepo=remi,remi-test list mysql mysql-server
安装mysql5.5
yum --enablerepo=remi,remi-test install mysql mysql-server
启动mysql5.5
/etc/init.d/mysqld start
设置开机启动
chkconfig --levels 345 mysqld on
要启用MySQL 安全设置请输入以下命令
/usr/bin/mysql_secure_installation
不想启动MySQL 安全设置命令,但至少也得修改一下root用户密码
mysqladmin -u root password [your_password_here]
- DB_NAME = webdb
- USER_NAME = webdb_user
- REMOTE_IP = 10.0.15.25
- PASSWORD = password123
- PERMISSIONS = ALL
- mysql> CREATE DATABASE webdb;
2. 创建用户webdb_user
- mysql> CREATE USER 'webdb_user'@'10.0.15.25' IDENTIFIED BY 'password123';
3. 授权
- mysql> GRANT ALL ON webdb.* TO webdb_user@'10.0.15.25';
4. 重载权限表
- mysql> FLUSH PRIVILEGES;
- vi /etc/sysconfig/iptables
2. 在COMMIT之前加入以下内容:
- -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
3. 重启Iptables:
- service iptables restart
- ## OR ##
- /etc/init.d/iptables restart
4. 在客户机上测试远程访问数据库:
- mysql -h dbserver_name_or_ip_address -u webdb_user -p webdb