环境:
CenterOs7+64bit
MySQL-server-5.5.25a-1.rhel5.x86_64.rpm
1.缺少libaio库
Linux CenterOs 64位中安装 MySQL-server-5.5.25a-1.rhel5.x86_64.rpm 出现以下错误
[root@localhost upload]# rpm -ivh MySQL-server-5.5.25a-1.rhel5.x86_64.rpm
error: Failed dependencies:
libaio.so.1()(64bit) is needed by MySQL-server-5.5.25a-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.5.25a-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.5.25a-1.rhel5.x86_64
从以上错误信息可以看出是因为缺少库libaio,所以需要安装libaio
解决方法:下载libaio-0.3.107-10.el6.x86_64.rpm
安装:rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm
2.已存在库报错
file /usr/share/mysql/charsets/cp866.xml from install of MySQL-server-5.6.36-1.linux_glibc2.5.x86_64 conflicts with file from package mariadb-libs-1:5.5.52-1.el7.x86_64
原因:已存在MySQL-server-5.1.7-0.i386的库(开始装错了的)所以需要先删除以前的库才能安装!
执行命令:
解决方法:
强制卸载!
rpm -e MySQL-server-5.1.7-0.i386 --nodeps
重新安装
rpm -ivh MySQL-server-5.6.36-1.linux_glibc2.5.x86_64.rpm
3.启动失败,原因没清理干净
root@localhost mysql]# service mysql start
Starting MySQL… ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).
解决方法:
[root@localhost mysql]# rpm -aq | grep -i mysql
MySQL-server-5.5.25a-1.el6.x86_64
[root@localhost mysql]# rpm -e MySQL-server-5.5.25a-1.el6.x86_64
删除lib下的mysql目录
[root@localhost rc.d]# cd /var/lib/
[root@localhost lib]# rm -rf mysql/
重新安装mysql
[root@localhost tools]# rpm -ivh MySQL-server-5.5.25a-1.rhel5.x86_64.rpm --nosignature
启动msyql服务成功:
[root@izwz99jkykxnz tools]# service mysql start
root忘记密码修改
修改配置文件,路径:/usr/my.cnf
[mysqld]
##新增一行
skip-grant-tables
重启即可
使用update直接编辑user表
update mysql.user set password=password(‘password123’) where user=‘root’ and host=‘localhost’;
mysql创建用户:
create user ‘miketho’@’%’ identified by ‘mikethoxxx’;
赋权限
GRANT ALL PRIVILEGES ON ldproduct.* TO ‘miketho’@’%’ IDENTIFIED BY ‘mikethoxxx’;
格式:grant 权限 on 数据库名.表名 to 用户@登录主机 identified by “用户密码”;
刷新权限
FLUSH PRIVILEGES;