Shulou(Shulou.com)06/01 Report--

This article is mainly about how to upgrade MySQL in phpStudy. If you are interested, let's take a look at this article. I believe it is of some reference value to everyone after reading how to upgrade MySQL in phpStudy.

1. Download the latest compressed version of MySQL.

The URL is as follows: https://dev.mysql.com/downloads/mysql/, pull to the bottom of the page, choose the combination you need, and you can get the 64-bit compressed version of mysql under the latest version of win.

two。 Back up the current MySQL.

Stop the service of phpStudy and exit phpStudy. Rename the MySQL folder under phpStudy to MySQL.old. The default location is C:\ phpStudy\ PHPTutorial\ MySQL.

3. Extract the latest version of mysql

Extract the downloaded mysql compressed version to the mysql directory under phpstudy. The default location is C:\ phpStudy\ PHPTutorial\ MySQL.

4. Add a MySQL path to the environment variable

5. Configure my.ini

6. Add skip-grant-tables to the mysqld of my.ini and omit the password to log in

7. Start MySQL

Start cmd as an administrator and type net start mysql to start MySQLmysql-uroot to connect to MySQL

8. Run the following command under MySQL

Use mysql; # use mysql tableupdate user set authentication_string=PASSWORD ("root") where User='root'; # update password to rootupdate user set plugin= "mysql_native_password" where User='root'; # set password resolving to default mechanism for root userflush privileges;quit

9. Comment out skip-grant-tables in my.ini and restart the mysql service

10. Reconnect to MySQL and log in with root/root

Does the above details about how to upgrade MySQL in phpStudy help you? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.