- 安装perl
yum install -y perl
yum -y install autoconf
yum –y install perl-devel #安装不成功,好像没影响
- 卸载mariadb,与mysql冲突
rpm -qa|grep mariadb
mariadb-libs-5.5.44-2.el7.centos.x86_64
rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
- mysql安装资源
mysql5.6.36资源
链接:https://pan.baidu.com/s/1vmzWq6pbaW19JQ50hR-QAg
提取码:72wt
- 安装操作
进入mysq安装文件路径
执行 命令 rpm -ivh *.rpm 自行安装
查看的密码=cat /root/.mysql_secret
service mysql start
mysql -uroot -p此处输入上面查看的密码
set password=password(‘your password’)
use mysql
#创建用户
create user 'spark'@'%' identified by '123456';
#授权
grant all privileges on *.* to 'spark'@'%' identified by '123456' with grant option;
flush privileges;
exit;
- 重新启动mysql
service mysql restart
- 设置表名大小写不敏感和连接超时
在配置文件my.ini中的[mysqld]标签下,增加如下内容
lower_case_table_names=1
wait_timeout=1728000 #自己根据情况设定
- 问题解决
mysql没权限
#ps aux| grep mysql
root 5327 0.0 0.0 11776 1568 ? S 10:24 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid
mysql 5423 0.0 24.0 1304836 449760 ? Sl 10:24 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/localhost.localdomain.err --pid-file=/var/lib/mysql/localhost.localdomain.pid
root 5830 0.0 0.0 112660 968 pts/3 R+ 10:48 0:00 grep --color=auto mysql
#chown -R mysql.mysql /var/lib/mysql
- 查看mysql错误日志
tail -f -n1000 /var/lib/mysql/localhost.localdomain.err