Home Backend Development PHP Tutorial Installation and upgrade of MySQL 4.1_PHP tutorial

Installation and upgrade of MySQL 4.1_PHP tutorial

Jul 13, 2016 pm 05:01 PM
mysql upgrade and Install yes Beta Version of program alpha

4.1 is an alpha beta, this version is not made for fool installers or has many inconveniences. However, I quite like the distribution of
compressed packages :) The following are my steps for a new installation and upgrade to 3.23.49.
A fresh installation
Use WinRAR to decompress the files to the C:mysql directory (default directory, worry free!!), and execute
c:mysql inmysqld-??? --installnet start mysql
It is very simple. If you install it in another directory, remember to modify the path in the configuration file as mentioned before!
Second upgrade installation
Whether it is from 3.23.x It makes no big difference whether you upgrade or upgrade from 4.0.x!
First of all, you need to back up the old database and prepare a regret medicine for yourself just in case! !
Then stop the current mysql database and remove it from the service. If WinMySQLAdmin is still running, be sure to close it!
Except for the data directory, all old version files will be overwritten with version 4.1 files!
Start mysql from the command line with c:mysql inmysqld-opt --skip-grant-tables, and then execute
c:mysql inmysql < c:mysqlscriptsmysql_fix_privilege_tables.sql to create a new grant
Power table.
If the above steps are correct, stop mysql c:mysql inmysqladmin -u root shutdown.
Then reinstall it as a system service according to your personal needs!
I took a look at the header file of this version and found it quite confusing. If you are interested, go check it out for yourself!


http://www.bkjia.com/PHPjc/631133.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631133.htmlTechArticle4.1 is an alpha beta version, this version is not made for fool installers or many inconveniences. However, I quite like the distribution of compressed packages :) Here is my fresh installation and...
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

The page is blank after PHP is connected to MySQL. What is the reason for the invalid die() function? The page is blank after PHP is connected to MySQL. What is the reason for the invalid die() function? Apr 01, 2025 pm 03:03 PM

The page is blank after PHP connects to MySQL, and the reason why die() function fails. When learning the connection between PHP and MySQL database, you often encounter some confusing things...

How to efficiently integrate Node.js or Python services under LAMP architecture? How to efficiently integrate Node.js or Python services under LAMP architecture? Apr 01, 2025 pm 02:48 PM

Many website developers face the problem of integrating Node.js or Python services under the LAMP architecture: the existing LAMP (Linux Apache MySQL PHP) architecture website needs...

Tokens to be listed: $DOGEL, $BRAIN, $BTD, $PINU and $PIMEME Tokens to be listed: $DOGEL, $BRAIN, $BTD, $PINU and $PIMEME Mar 03, 2025 pm 08:03 PM

The cryptocurrency market continues to develop, bringing investors a growing investment opportunity. The listing of new coins has always attracted much attention, and February 2025 is the month when new coins are crowded, providing investors with a wide range of choices. Cryptocurrencies to watch in February 2025: Potential projects that cannot be missed This article will focus on five cryptocurrency projects that will be launched in February, and whether you are an experienced investor or a newbie, you can find the projects you are interested in. They are DogeLife ($DOGEL), DistriBrain ($BRAIN), Bitcoin USD ($BTD), PiINU ($PINU) and PIMEME ($PIMEME). Please be prepared and put these days

How to share the same page on the PC and mobile side and handle cache issues? How to share the same page on the PC and mobile side and handle cache issues? Apr 01, 2025 pm 01:57 PM

How to share the same page on the PC and mobile side and handle cache issues? In the nginx php mysql environment built using the Baota background, how to make the PC side and...

PHP optimistic locking combined with transaction deduction balance failed: How to ensure that the balance is correctly deducted in concurrency situations? PHP optimistic locking combined with transaction deduction balance failed: How to ensure that the balance is correctly deducted in concurrency situations? Mar 31, 2025 pm 11:42 PM

Detailed explanation of the problem of deducting balances in combination with PHP optimistic locks and transactions in this article will analyze in detail a balance deduction using PHP, optimistic locks and database transactions, only...

Is Debian Strings compatible with multiple browsers Is Debian Strings compatible with multiple browsers Apr 02, 2025 am 08:30 AM

"DebianStrings" is not a standard term, and its specific meaning is still unclear. This article cannot directly comment on its browser compatibility. However, if "DebianStrings" refers to a web application running on a Debian system, its browser compatibility depends on the technical architecture of the application itself. Most modern web applications are committed to cross-browser compatibility. This relies on following web standards and using well-compatible front-end technologies (such as HTML, CSS, JavaScript) and back-end technologies (such as PHP, Python, Node.js, etc.). To ensure that the application is compatible with multiple browsers, developers often need to conduct cross-browser testing and use responsiveness

Docker builds LNMP environment: Is a single Dockerfile or Docker Compose better? Docker builds LNMP environment: Is a single Dockerfile or Docker Compose better? Apr 01, 2025 pm 02:09 PM

Dockerfile Best Practice for Building LNMP Environment Learning During Docker, many developers try to build their own LNMP (Linux, Nginx, MySQL, PHP)...

See all articles