1.查看mysql数据库安装包
rpm -qa | grep mysql
批量删除rpm及其依赖(mysql)
rpm -qa | grep mysql | where read c;do rpm -e $c --nodeps;done
2.上传rpm安装包到linux服务器上
MySQl-client-5.1.73-1.glibc23.x86_64.rpm --SQL客户端
MySQl-server-5.1.73-1.glibc23.x86_64.rpm --SQL服务端
3.安装rpm安装(先–服务端server;后–客户端client)
1>rpm -ivh MySQl-server-5.1.73-1.glibc23.x86_64.rpm
2>service mysql status查看mysql状态
3>service mysql start启动mysql
4>rpm -ivh MySQl-client-5.1.73-1.glibc23.x86_64.rpm
4.登陆验证,mysql密码修改与远程登陆
①mysql -uroot -p (默认密码为空,直接回车即可)
1>show datebases 显示mysql中所含库
2>use mysql 使用库名为mysql的
3>show tables 显示mysql库中所有表
4>select host,user,password,from user 查询use表中的host,user,password
5>delete from user where host !=“127.0.0.1"删除host不是127.0.0.1的行
6>select host,user,password from user 再次查询
7>update user set host=”%" 删除本地连接限制,修改为供远程客户端工具链接地址