MySQL start-Stop and restore backup recovery database

1.mysql Start-Stop

Go to cmd

Enter the following command

net stop MySQL (your own MySQL name)-------stop

NET Strat MySQL--------------------------

2. Backing up and recovering databases

I only use the database folder (for example Worktime) in the backup C:\ProgramData\MySQL\MySQL Server 5.1\data path

The backup script is as follows:

Color 0A--Set colors
Title Work Management database backup (please do not close, you can minimize)!
@echo off&setlocal enabledelayedexpansion
Set sourdir= "C:\ProgramData\MySQL\MySQL Server 5.1\data\worktime"
Set Targdir=d:\db_backup
Set jt=%date:~0,4%%date:~5,2%%date:~8,2%
Echo Current date is%jt%
If EXIST%targdir%\%jt% (
RD/S/q%targdir%\%jt%
MD%targdir%\%jt%
xcopy/c/e/y/i/q%sourdir%%targdir%\%jt%\worktime
) ELSE (
MD%targdir%\%jt%
xcopy/c/e/y/i/q%sourdir%%targdir%\%jt%\worktime
)

Recovery:

Under the new MySQL (preferably two versions), copy the Worktime to the above path and restart MySQL

You may be prompted for a local connection at this time

ERROR 1130:host ' 192.168.1.3 ' isn't allowed to connect to this MySQL server

Workaround:

The premise is to get into MySQL, mine is Root/system

1. Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", from "localhost" to "%"

Mysql-u root-pvmwaremysql>use mysql;mysql>update User Set host = '% ' where user = ' root '; Mysql>select host, use R from user;--- didn't try .

2. Authorization law. For example, if you want to myuser use MyPassword to connect to a MySQL server from any host.

GRANT all privileges on * * to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;--- try it

If you want to allow users to connect to the MySQL server from a host myuser IP 192.168.1.3 and use MyPassword as the password

GRANT all privileges on * * to ' root ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT OPTION;

GRANT all privileges on * * to ' root ' @ ' 10.10.40.54 ' identified by ' 123456 ' with GRANT OPTION

MySQL start-up and restore backup recovery database