How to change mysql password under Linux

WBOY

Release： 2023-05-18 17:22:06

forward

997 people have browsed it

The initial password is empty, use the empty password to log in to mysql and execute the following statement

mysql>use mysql;
mysql> update user set password=password("root") where user=&#39;root&#39;;
mysql> flush privileges;
mysql> quit;
修改/opt/lampp/phpmyadmin/config.inc.php

Copy after login

Find the following code:

$cfg[&#39;servers&#39;][$i][&#39;auth_type&#39;] = &#39;config&#39;;
$cfg[&#39;servers&#39;][$i][&#39;user&#39;] = &#39;root&#39;;
$cfg[&#39;servers&#39;][$i][&#39;password&#39;] = &#39;&#39;;
$cfg[&#39;servers&#39;][$i][&#39;extension&#39;] = &#39;mysql&#39;;
$cfg[&#39;servers&#39;][$i][&#39;allownopassword&#39;] = true;

Copy after login

Change to:

$cfg[&#39;servers&#39;][$i][&#39;auth_type&#39;] = &#39;config&#39;;
$cfg[&#39;servers&#39;][$i][&#39;user&#39;] = &#39;root&#39;;
$cfg[&#39;servers&#39;][$i][&#39;password&#39;] = &#39;root&#39;;
$cfg[&#39;servers&#39;][$i][&#39;extension&#39;] = &#39;mysql&#39;;
$cfg[&#39;servers&#39;][$i][&#39;allownopassword&#39;] = true;

Copy after login

The above is the detailed content of How to change mysql password under Linux. For more information, please follow other related articles on the PHP Chinese website!

Related labels：

mysql linux

source：yisu.com

Previous article：How to build a PHP web server in Linux system Next article：How to change the hostname of Linux cloud server

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn