卸载自带的数据库
使用命令:rpm -qa|grep -i mysql 查询MySQL的包
使用命令:rpm -e --nodeps+包名,将查到的MySQL的包全部删除
- 删除老版本mysql文件和库
rm -fr /usr/lib/mysql
rm -fr /usr/include/mysql
注意:卸载后/var/lib/mysql中的数据及/etc/my.cnf不会删除,如果确定没用后就手工删除
rm -f /etc/my.cnf
rm -fr /var/lib/mysql
软件安装
- 使用rpm包安装mysql
安装mysql,安装前准备两个rpm的包
MySQL-client-5.5.31-2.el6.x86_64
MySQL-server-5.5.31-2.el6.x86_64
rpm -ivh MySQL-server-5.5.31-2.el6.x86_64.rpm #安装服务端
rpm -ivh MySQL-client-5.5.31-2.el6.x86_64.rpm #安装客户端
chkconfig mysqld on #设置开机启动
service mysqld start #启动mysql服务
- 通过yum安装mysql
yum install mysql-server #安装mysql服务器
chkconfig mysqld on #设置开机启动
service mysqld start #启动mysql服务
初始化配置
根据提示设置root的初试密码:
mysqladmin -u root password 'xxxx'
修改密码:
mysql -uroot –pxxxx
mysql> update mysql.user set password=password(”新密码”)where user=”root”;
mysql> flush privileges;
修改 Mysql-Server 用户配置:
mysql> USE mysql; -- 切换到 mysql DB
Database changed
mysql> SELECT User, Password, Host FROM user; -- 查看现有用户,密码及允许连接的主机
+------+----------+-----------+
| User | Password | Host |
+------+----------+-----------+
| root | | localhost |
+------+----------+-----------+
1 row in set (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.100' IDENTIFIED BY '' WITH GRANT OPTION; --只允许192.168.1.100 连接
mysql> flush privileges;
mysql> -- @'192.168.1.100'可以替换为@‘%’就可任意ip访问