1 下载mysql wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.41-linux-glibc2.12-x86_64.tar.gz
2
groupadd mysql 添加用户组 useradd -r -g mysql mysql 添加用户 mkdir -p /usr/local/mysql/data/ 创建数据存储目录 chown mysql:mysql -R /usr/local/mysql/data/ 授权数据存储目录 vim /etc/my.cnf 编辑
[mysqld] user=mysql basedir=/usr/local/mysql datadir=basedir=/usr/local/mysql/data/ socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd [mysqld_safe] log-error=/var/log/mariadb/mariadb.log pid-file=/var/run/mariadb/mariadb.pid # # include all files from the config directory # !includedir /etc/my.cnf.d
如果出现上述 初始化错误 需要删除data目录中原有数据
如果出现缺少依赖 需要下载
yum install -y libaio
查看密码
cat /data/mysql/mysql.err
直接删除mysql.cnf
重启服务mysql
修改mysql密码
use mysql
查看mysql使用plugin
修改密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'xxxxxx.';
退出 重新连接
标签:安装,data,mysql,cnf,usr,linux,mariadb,local From: https://www.cnblogs.com/Lcch/p/17067235.html