This article tells you how to follow 12 methods to write high-quality JS code. Friends who need this convenience can refer to it.
Environment related:
OS: CentOS release 6.9
IP: 192.168.1.10
MySQL: MariaDB-10.1.30
1. Confirmation before modification
To change the root password, you need to restart the mysql library. Confirm that production can really restart the mysql library;
Confirm whether production uses the root user to connect to the library directly. If so, Corresponding changes must be made;
Please stop the application connected to the library before changing the password, that is, stop all production lines related to the library.
2. Stop the database and change the password
ps -ef|grep mysql|grep -v grep # 找到对应的mysql服务器守护进程,查看是否有其他mysql服务守护进行存在 ps -ef|grep mysql|grep -v grep|xargs kill -9 # 杀掉root启动库的命令进程和库的守护进程,否则库会自动再次启动 # 杀掉进程,停库,杀掉进程之前请确保连接到库的应用全部停掉!!! mysqld_safe --user=mariadb --skip-grant-tables & # 忽略授权表启动库,此时如果使用密码则无法登陆库 # 连接到库的应用如果没有停掉,此时是无法成功连接到库的 mysql use mysql; select Host,User,Password from user where user='root'; exit; # 进到mysql库中,查询当前的root密码的密值,保存密值用以回滚 # 比如我当前密码是vincent,密值是'*CDA83EBFF468E905FF304FE0D3D9F4D665C6579D' mysql use mysql; update user set password=password('test') where user='root'; exit; # 进到mysql库中,设置root密码 mysqladmin shutdown mysqld_safe --user=mariadb & # 重启库,登录测试 mysql -uroot -ptest -Dmysql exit; # 登录成功
3. Roll back the operation
After you change the root password, Many problems were found, such as unknown applications connecting to the library with the original root password (fucked historical problems), which needed to be rolled back.
mysql -uroot -ptest -Dmysql update user set password='*CDA83EBFF468E905FF304FE0D3D9F4D665C6579D' where user='root'; flush privileges; exit; # 使用上一步记录的root密码修改前的密值进行回滚 mysql -uroot -pvincent -Dmysql exit; # 回滚完成
4. Related knowledge points
You can directly use the secret value of the password to set the password. Currently, there is no way to directly reverse the secret value into the plain text of the password. View You can use the password function for the password value:
mysql -uroot -pvincent select password('vincent'),password('test');
But if you know the password value, you can modify a user's password with root privileges without knowing it, use it, and then restore it.
This situation is mostly used when a user forgets his password and resets his password. The same situation also occurs in the Oracle database.
The above is what I compiled for everyone. I hope it will be helpful to everyone in the future.
Related articles:
Configuring steps for Axios (detailed tutorial)
Compatible browser issues in JS
How to get the value of SessionStorage using JS
How to implement the login and registration function using node.js and other technologies?
How to use filter filter in vue
The above is the detailed content of MySQL changes root password. For more information, please follow other related articles on the PHP Chinese website!

查版本号的命令:1、“cat /etc/issue”或“cat /etc/redhat-release”,可输出centos版本号;2、“cat /proc/version”、“uname -a”或“uname -r”,可输出内核版本号。

centos重启网卡的方法:1、对于centos6的网卡重启命令是“service network restart”;2、对于centos7的网卡重启命令是“systemctl restart network”。

centos php安装opcache的方法:1、执行“yum list php73* | grep opcache”命令;2、通过“yum install php73-php-opcache.x86_64”安装opcache;3、使用“find / -name opcache.so”查找“opcache.so”的位置并将其移动到php的扩展目录即可。

centos离线安装mysql的方法:1、将lib中的所有依赖上传到linux中,并用yum命令进行安装;2、解压MySQL并把文件复制到想要安装的目录;3、修改my.cnf配置文件;4、复制启动脚本到资源目录并修改启动脚本;5、将mysqld服务加入到系统服务里面;6、将mysql客户端配置到环境变量中,并使配置生效即可。

centos7安装不出现界面的解决办法:1、选择“Install CentOS 7”,按“e”进入启动引导界面;2、 将“inst.stage2=hd:LABEL=CentOS\x207\x20x86_64”改为“linux dd”;3、重新进入“Install CentOS 7”,按“e”将“hd:”后的字符替换成“/dev/sdd4”,然后按“Ctrl+x”执行即可。

centos删除php的方法:1、通过“#rpm -qa|grep php”命令查看全部php软件包;2、通过“rpm -e”命令卸载相应的依赖项;3、重新使用“php -v”命令查看版本信息即可。

方法:1、利用“vim ~/.bashrc”编辑用户目录(~)下的“.bashrc”文件;2、在文件内添加“alias ls="ls --color"”;3、利用“:wq!”命令保存文件内的更改;4、“exit”命令退出终端后重新连接即可。

我们的PC中有一个磁盘驱动器专门用于所有与Windows操作系统相关的安装。该驱动器通常是C驱动器。如果您还在PC的C盘上安装了最新的Windows11操作系统,那么所有系统更新(很可能是您安装的所有软件)都会将其所有文件存储在C盘中。因此,保持此驱动器没有垃圾文件并在C驱动器中拥有足够的存储空间变得非常重要,因为该驱动器拥有的空间越多,您的Windows11操作系统运行起来就越顺畅。但是您可以在磁盘驱动器上增加多少空间以及可以删除多少文件是有限制的。在这种情况下,


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

SublimeText3 Linux new version
SublimeText3 Linux latest version

SublimeText3 English version
Recommended: Win version, supports code prompts!
