查询mysql服务是否已安装 rpm -qa|grep -i mysql //i参数忽略大小写 停止mysql服务 /etc/init.d/mysql stop 查看服务是否正常关闭 ps -ef |grep mysql // 如果有kill -9 pid 卸载mysql服务 rpm -e MySQL-server-5.5.19-1.linux2.6 rpm -e MySQL-client-5.5.19-1.linux2.6//如果有依赖错误加上--nodeps 删除附属文件 rm -rf /var/lib/mysql rm -f /etc/my.cnf 安装rpm安装包 rpm -ivh MySQL-server-5.5.19-1.linux2.6.x86_64.rpm MySQL-client-5.5.19-1.linux2.6.x86_64.rpm 拷贝一份模版为备份文件 cp /usr/share/mysql/my-huge.cnf /etc/my.cnf 启动mysql 服务 /etc/init/d/mysql start 修改root密码 mysqladmin -u root password 进入mysql mysql -u root -p 给予所有主机登录的权限 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION 使修改生效 mysql>FLUSH PRIVILEGES 退出mysql exit |
|