简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

mysql 4.1采用了新验证方法后的认证问题_MySQL

WBOY
Release： 2016-06-01 14:12:31
Original
1150 people have browsed it

　　mysql 4.1以后采用了新的验证方法，所以导致一些程序不能正常使用。我们可以使用old_password()函数，使mysql继续使用旧的验证方式。

　　比如我们建立一个admin的用户，拥有全部权限。密码12345

grant all on *.* to admin@localhost identified by “12345″

　　然后用下面命令设置使用旧的验证方式

set password for ‘admin’@'localhost’=old_password(’12345′)

Related labels：
method Certification question verify
source：php.cn
Previous article：ProFtpd与Mysql结合.实现FTP服务_MySQL Next article：apache+php+mysql+imap+ldap+jdk+tomcat的安装_MySQL
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
Latest Articles by Author
Latest Issues
Generate default values ​​and CSS variables using SCSS I'm implementing website styling. For legacy support reasons, I need to support IE11, at l...
From 2024-04-06 17:46:54
0
1
355
CSS styles not applied to site I'm making a website using Bootstrap5 but the index.css properties are not being applied t...
From 2024-04-06 17:12:23
0
1
336
React Three Fiber: Why are my scroll events lagging? In ReactThreeFiber, I have a React component that generates a sprite that I want to persis...
From 2024-04-06 13:39:24
0
1
410
General error in Laravel 9.x: Field 'id' has no default value I'm using UUIDs in my app and I've implemented the trait as shown online like this: traitU...
From 2024-04-06 11:12:54
0
1
350
Symfony Redis cannot connect to the host defined in the env file, which defaults to localhost We have a new Symfony setup with Redis as the caching mechanism. We want to connect to a s...
From 2024-04-06 10:53:02
0
1
375
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！