MySQL error: Client does not support authentication...

I was installing php4.3.4.11 from FC2 CDs. I also installed MySQL 4.1.11. Now I have a problem; when connecting to MySQL via php I recieve this error:

client does not support authentication...."

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

In my phpinfo(); the version of mysql cilent was set 3.23.58, but when I want to upgrade it with the new one, "this package is already installed" was indicated. At first FC2 installed MySQL 3.23 for me, then I upgraded it.

Your copy of PHP was built using an older version of the MySQL client libraries that do not support the new password hashing algorithms used in MySQL version 4.1 and higher.

I answer this question on such a regular basis that I have a FAQ entry for it.

It details the cause and solution of the error you have encountered.

Related Resources

How To Migrate Windows and Linux Servers to Azure –Tech Data - MicroFocus
How To Migrate Windows & Linux Servers to AWS –Tech Data - MicroFocus
Datasheet: Red Hat Enterprise Linux Server –Red Hat
Microsoft SQL Server 2017 on Linux Quick Start Guide –Microsoft

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Data Center experts

View all Data Center questions and answers

Open source log management options for Linux distributions

What are the options for log management in Linux?

SUSE Linux Enterprise Server (SLES)

Unix

RHEL 8 promises relief from dependency hell, more integration

Steady as it goes, RHEL 6.8 brings new archiving and VPN tool

Tighter security tops RHEL 6.7 updates

Red Hat support evolves with new Access Insights services

Open source log management options for Linux distributions

SUSE Linux Enterprise Server (SLES)

Unix

Master RHEL 7.3 before you consider RHEL 8

Streamline Linux system management with these five tips

Tips and tools to deploy Linux for IoT devices

Compare the best Linux distros for enterprise servers

Consider these Linux I/O scheduler options for storage performance

What are the options for log management in Linux?

Use Red Hat System Roles to smooth Ansible integration

Master RHEL 7.3 before you consider RHEL 8

With Btrfs file system gone in RHEL 8, look at alternatives

Steps to install Docker on Ubuntu 16.04 servers

How can I prevent data loss during a Linux distribution upgrade?

Manage SELinux policies for better troubleshooting, access controls

Use a Linux file system journal for data integrity, performance

Please create a username to comment.

July Patch Tuesday brings three public disclosures

Authenticating email in Exchange for brand protection

Taking stock of Windows Server management tools

VMworld 2018 conference coverage

Set up Hyper-V nested virtualization for production

Use an IT outage communication plan to recover from a host crash

Evaluate Google Cloud TPUs for machine learning apps

Overcome app deployment challenges in a multi-cloud strategy

Microsoft bills Azure network as the hub for remote offices

Related Resources

Dig Deeper on Linux servers

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.