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

This article mainly introduces how to install the green version of window mysql, the content of the article is carefully selected and edited by the author, with certain pertinence, the reference significance for everyone is still relatively large, the following with the author to understand how to install the green version of window mysql.

mysql installation requires the following two software:

Tip: . net 4 Framework-related, install first--> net4_framework.rar

tips:microsoft visual c++ 2010 32 related, install vcredist2010_x86.rar

=====================================

mysql green version:

If it is an unzipped version of mysql installation method:

1. Configure environment variables

2. cd to mysql bin below

mysqld --initialize

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

Rename my-default.ini file under MySQL to my.ini and add explicit_defaults_for_timestamp=true under [mysqld]

mysqld --install

(Install/Remove of the Service Denied Open cmd with administrator privileges)

net start mysql

3. Then log in. The first time you log in, you don't have a password.

mysql -u root

4. Change password after login:

mysql> use mysql;

mysql> update user set password=password("new password") where user="root";

(If there is no password field in the user table, as shown below, otherwise skip directly)

mysql> update `User` SET authentication_string=PASSWORD("0000") where USER='root';

mysql> flush privileges;

mysql> quit;

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

If the password is not empty the first time mysql is installed, the problem is solved as follows:

1. Edit mysql configuration file my.ini Add skip-grant-tables under [mysqld]

2. Save exit and restart mysql

3. Click Start-> Run (shortcut Win+R).

4. Start: Enter net stop mysql

5. Stop: Enter net start mysql

6. Enter mysql -u root -p in cmd and you can log in without password. When password: appears, enter directly to enter.

7.mysql> use mysql;

8.mysql> update user set password=password("new password") where user="root";

(If there is no password field in the user table, as shown below, otherwise skip directly)

mysql> update `User` SET authentication_string=PASSWORD("0000") where USER='root';

mysql> flush privileges;

mysql> quit;

After the first login, you need to reset your password, otherwise you will be prompted that you have no permissions to operate:

step 1: SET PASSWORD = PASSWORD('your new password');

step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

step 3: flush privileges;

step 4:net stop mysql

step 5:net start mysql

Set the following in my.ini to resolve database garbled issues:

[mysql]

default-character-set=utf8

[mysqld]

character-set-server=utf8

After reading the above about how to install the green version of window mysql, many readers must have some understanding, if you need to get more industry knowledge information, you can continue to pay attention to our industry information column.

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.