Linuxmysql5.5.27_linux非root用户安装5.7.27版本mysql

先下安装包&＃xff0c;到mysql官网https://dev.mysql.com/downloads/mysql/选好安装包版本、操作系统类型(默认是最新版本&＃xff0c;点击右边链接Looking for previous GA versions?进行自选)&＃xff1a;

下完安装包mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz后&＃xff0c;通过rz上传至linux的wlf用户soft目录下&＃xff0c;并解压&＃xff1a;

$ cd soft

$ rz

$ cd ..

$ tar zxvf soft/mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz

创建软连接&＃xff1a;

$ ln -s mysql-5.7.27-linux-glibc2.12-x86_64 mysql

进入软连接目录&＃xff1a;

$ cd mysql

通过vi新增mysql配置文件my.cnf&＃xff0c;内容如下:

[client]

port&＃61;3336

socket&＃61;/home/wlf/mysql/mysql.sock

[mysqld]

port&＃61;3336

basedir&＃61;/home/wlf/mysql

datadir&＃61;/home/wlf/mysql/data

pid-file&＃61;/home/wlf/mysql/mysql.pid

socket&＃61;/home/wlf/mysql/mysql.sock

log_error&＃61;/home/wlf/mysql/error.log

server-id&＃61;100

安装mysql&＃xff1a;

$ bin/mysqld --defaults-file&＃61;/home/wlf/mysql/my.cnf --initialize --user&＃61;wlf --basedir&＃61;/home/wlf/mysql --datadir&＃61;/home/wlf/mysql/data

启动mysql&＃xff1a;

$ bin/mysqld_safe --defaults-file&＃61;/home/wlf/mysql/my.cnf --user&＃61;wlf &

[1] 1253

$ 2019-09-20T04:16:20.253918Z mysqld_safe Logging to &＃39;/home/wlf/mysql/error.log&＃39;.

2019-09-20T04:16:20.292670Z mysqld_safe Starting mysqld daemon with databases from /home/wlf/mysql/data

获取密码&＃xff1a;

$ cat error.log | grep root&＃64;localhost

2019-09-20T03:47:05.657319Z 1 [Note] A temporary password is generated for root&＃64;localhost: 6)j;ng7%-(SP

登陆mysql&＃xff1a;

$ bin/mysql -u root -p

ERROR 2002 (HY000): Can&＃39;t connect to local MySQL server through socket &＃39;/tmp/mysql.sock&＃39; (2)

不存在/tmp/mysql.sock&＃xff0c;我们只有mysql.sock&＃xff0c;所以当mysql去找这个文件时&＃xff0c;我们让它换个地方去找&＃xff1a;

ln -s /home/wlf/mysql/mysql.sock /tmp/mysql.sock

再次登录&＃xff0c;输入之前拿到的密码6)j;ng7%-(SP后登陆成功&＃xff1a;

$ bin/mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.27

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type &＃39;help;&＃39; or &＃39;\h&＃39; for help. Type &＃39;\c&＃39; to clear the current input statement.

mysql>

我们修改下密码&＃xff1a;

mysql> set password for &＃39;root&＃39;&＃64;&＃39;localhost&＃39; &＃61; password(&＃39;123456&＃39;);

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

打完收工。如果不想用root用户&＃xff0c;而是新建自己的用户&＃xff0c;参见

标签&＃xff1a;27,5.7,sock,mysqld,mysql,home,root,wlf

来源&＃xff1a; https://www.cnblogs.com/wuxun1997/p/11556403.html