mysql 非root用户安装安装

56 阅读 0 评论 37 点赞

我是靠谱客的博主无语糖豆，最近开发中收集的这篇文章主要介绍mysql 非root用户安装安装，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

安装

下载软件

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz

这里用的mysql5.7,mysql5.7有相较于5.6有较大的性能提升，但是也有相对较大的改动

解压缩

tar -axvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz

暴露mysql命令

export PATH="$PATH:/home/ascent/mysql/mysql-5.7.28/bin"

cd /home/ascent/mysql/mysql-5.7.28/bin

初始化mysql

./mysqld
--initialize --user=mysql --datadir=/home/ascent/mysql/mysql-5.7.28/data --basedir=/home/ascent/mysql/mysql-5.7.28

记住初始化后的密码
到support-files目录下，边界mysql启动配置文件

cd /home/ascent/mysql/mysql-5.7.28/support-files/

vim mysql.server

编辑mysql.server文件

把这些改成你的安装目录
datadir=/home/ascent/mysql/mysql-5.7.28/data
basedir=/home/ascent/mysql/mysql-5.7.28

启动

./mysql.server start

这个是错误的

 mysql -r root -p

应该用这个

 bin/mysql -u root -p -S /home/ascent/mysql/mysql-5.7.28/mysql.sock

1. ## 登录MySql 查看报错
这里因为是非oper用户，所以正常登录命令应该是：`bin/mysql -u root -p`，但是即使你这样输入了，一样报错。会给你报如下错误代码。
```javascript
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
```

复制你刚刚初始化的密码
设置密码

set password for root@localhost = password('yourpass');

 mysql>use mysql;
msyql>update user set user.Host='%' where user.User='root';
mysql>flush privileges;

./mysqld --defaults-file=/home/ascent/mysql/mysql-5.7.28/my.cnf --initialize --user=mysql --datadir=/home/ascent/mysql/mysql-5.7.28/data --basedir=/home/ascent/mysql/mysql-5.7.28

[client]
port=3336
socket=/home/ascent/mysql/mysql-5.7.28/mysql.sock
[mysqld]
port=3336
basedir=/home/ascent/mysql/mysql-5.7.28
datadir=/home/ascent/mysql/mysql-5.7.28/data
pid-file=/home/ascent/mysql/mysql-5.7.28/mysql.pid
socket=/home/ascent/mysql/mysql-5.7.28/mysql.sock
log_error=/home/ascent/mysql/mysql-5.7.28/error.log
server-id=100
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
lower_case_table_names=1