Linux系统安装时报错,mysql在linux系统安装

亦凉 2023-01-21 11:27 3阅读 0赞

mysql在linux系统安装

1.下载：https://dev.mysql.com/downloads/repo/yum

![53b95f7cf3c98a8c0ab3f084f76cb925.png][]

![bdb60ef691b61abd4a00dcea632db87a.png][]

2.安装https://jingyan.baidu.com/article/6525d4b1704f52ac7d2e94c1.html

拖到linux系统：安装顺序 common>libs>client>server>devel

![36aafd3f97de77a019edbcc76c406d2a.png][]

按着这个上面步骤走：https://www.cnblogs.com/lemon-feng/p/11233227.html

3.安装时如果没以下的报错可以直接忽略这一步：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql\_native\_password BY '123456';

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

密码设置错误时：https://www.jianshu.com/p/804cd2d2cdbf   用方案二

设置成功：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql\_native\_password BY '123456';

Query OK, 0 rows affected (0.02 sec)

use mysql

select \*from user;

mysql> update user set

\-> \`Select\_priv\` = 'Y',

\-> \`Insert\_priv\` = 'Y',

\-> \`Update\_priv\` = 'Y',

\-> \`Delete\_priv\` = 'Y',

\-> \`Create\_priv\` = 'Y',

\-> \`Drop\_priv\` = 'Y',

\-> \`Reload\_priv\` = 'Y',

\-> \`Shutdown\_priv\` = 'Y',

\-> \`Process\_priv\` = 'Y',

\-> \`File\_priv\` = 'Y',

\-> \`Grant\_priv\` = 'Y',

\-> \`References\_priv\` = 'Y',

\-> \`Index\_priv\` = 'Y',

\-> \`Alter\_priv\` = 'Y',

\-> \`Show\_db\_priv\` = 'Y',

\-> \`Super\_priv\` = 'Y',

\-> \`Create\_tmp\_table\_priv\` = 'Y',

\-> \`Lock\_tables\_priv\` = 'Y',

\-> \`Execute\_priv\` = 'Y',

\-> \`Repl\_slave\_priv\` = 'Y',

\-> \`Repl\_client\_priv\` = 'Y',

\-> \`Create\_view\_priv\` = 'Y',

\-> \`Show\_view\_priv\` = 'Y',

\-> \`Create\_routine\_priv\` = 'Y',

\-> \`Alter\_routine\_priv\` = 'Y',

\-> \`Create\_user\_priv\` = 'Y',

\-> \`Event\_priv\` = 'Y',

\-> \`Trigger\_priv\` = 'Y',

\-> \`Create\_tablespace\_priv\` = 'Y'

\-> where user='root' and host='%';

flush privileges;

Delete FROM user Where User='root' and Host='%';

select user,host from user；

改用户名为root1,密码为123456

create user 'root1'@'%' identified with mysql\_native\_password by '123456';

grant all privileges on \*.\* to 'root1'@'%' with grant option;

flush privileges;

exit;

mysql -uroot -p

123456

show databases;

![fdf313116d2f3d8fdd54c37b122af592.png][]

![6ca5ea698af5744978c69c9773b3824a.png][]

![cce0d19b28afd56e2daf9ca26c998488.png][]

![b9e9c15998c4557945c85d125add7ae7.png][]

![e42db42a07aeb9fc129293737608632c.png][]

![a1d4f15b9ebcf4f8798749d51f96da20.png][]

4.Navicate：

![ee001679dd5588b50217b11ec0da835f.png][]

mysql在linux系统安装相关教程

[53b95f7cf3c98a8c0ab3f084f76cb925.png]: /images/20221020/1fd0ba62d5e9436d880dc17a2278b15d.png
[bdb60ef691b61abd4a00dcea632db87a.png]: /images/20221020/bd03e103e56a475cab704272f67f06b9.png
[36aafd3f97de77a019edbcc76c406d2a.png]: /images/20221020/8f486d5145e64705b06e7a775dc7ef2b.png
[fdf313116d2f3d8fdd54c37b122af592.png]: /images/20221020/164a172c322b463598b1455474c03f89.png
[6ca5ea698af5744978c69c9773b3824a.png]: /images/20221020/e7afdf9618e84d1bad97555982e26222.png
[cce0d19b28afd56e2daf9ca26c998488.png]: /images/20221020/c8be31439a334535aea89b6a7dac0b81.png
[b9e9c15998c4557945c85d125add7ae7.png]: /images/20221020/cdbd9afd998f4761a2425f0e07da495b.png
[e42db42a07aeb9fc129293737608632c.png]: /images/20221020/52938587e3764a5ca89feaae238c6b8b.png
[a1d4f15b9ebcf4f8798749d51f96da20.png]: /images/20221020/5df4a87d7eb14471b140d42321b69449.png
[ee001679dd5588b50217b11ec0da835f.png]: /images/20221020/64d7753c909e4a99a7cb1aea14ac6204.png