Quick installation of apache+mysql+php

Source: Internet
Author: User
Tags command line mysql mysql client new features version client

Although a lot of online, or here to record their own installation process, and some experience, do not have to install and then everywhere to find.

First say MySQL, because he can say completely independent and Apache, PHP installation is not directly related. Now MySql5.0 has been officially released, a number of new features, the database has a basic functionality already has, such as views, subqueries, stored procedures and so on. (MySQL official website for http://www.mysql.com, I think this should everyone should not know it ^ ^, find download Download a setup program.) ), click on the installation program, according to his one step choice, set good parameters. Smoothly installed on it, the new version of the installation program on a great improvement, has even been registered service, the previous version is only to help you copy the program file, here by the way before the service: in the operation of the input C:mysqlinmysqld-nt.exe--install. (C:mysqlj is the path to the MySQL installation.) No problem installed, command line input: net start MySQL start service can be.

If the previous version is Mysql4.1, all programs will not be able to connect to MySQL for the following reasons:

Client does not support authentication protocol problem resolution when mysql4.1 above version connection

shell> MySQL

Client does not support Authenticationprotocol requested

by server; Consider upgrading MySQL client

The official version of the statement: MySQL 4.1 and up uses a authenticationprotocol based on a password hashing of that are algorithm with that Used by older clients. .....

If you are experiencing the above problems after you upgrade MySQL to version 4.1, make sure your mysqlclient is 4.1 or later. (If there is a problem with windows, you can just skip to the solution below, because MySQL is installed with Windows client and server)

Please use one of the following two methods

One

mysql> SET PASSWORD FOR
-> ''some_user''@''some_host'' =OLD_PASSWORD(''newpwd'');

Second:



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.