Illustration of MYSQL installation and data upgrade

The following figure shows how to install MYSQL and upgrade data. if you install MYSQL, skip this step.

Find the ragnarok Database Directory under your Mysql database Directory, for example, install Mysql in
Under the D: \ mysql Directory, find the ragnarok Database Directory under the D: \ mysql \ data \ directory.
Copy it to other places!
[Upgrade your ODBC-MySQL ODBC driver]
First open your control panel and find [add and delete programs] to delete the old MySQL ODBC driver.
Then install mydbc-3.51.11-1-win.exe.
[Delete the old MYSQL service on your computer]
If you have installed an earlier version, you need to see how to delete Mysql from your system.
When you detach the old MYSQL database service from your computer
First, stop MYSQL in the WINDOWS service.
Then go to the add deletion program in the control panel to delete it.
However, you cannot completely delete the MYSQL service.
Then you need to clear your MYSQL service in the registry
There are several places: (there should be two items. you can check them out)
1. delete the HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet001 \ Services \ Eventlog \ Application \ MySQL directory.
2. delete the HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet002 \ Services \ Eventlog \ Application \ MySQL directory.
3. delete the HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ Application \ MySQL directory.
As shown in:

After clearing,
Remember to delete the C: \ WINDOWS \ my. ini file.
Then restart the computer.
Go to your computer service and check it out.
Is the MYSQL service missing? now, you can install the new MYSQL version!
[Download related software:]
Mysql 4.1.11-win32-For Windows (Mysql 4.1.11-win32.exe) -- database service
Download
Https://www.php1.cn //>
Connector/ODBC-MySQL ODBC driver (MyODBC-3.51.11-1-win.exe) -- data source
Download
Https://www.php1.cn //>
MySQL Control Center (mysqlcc-0.9.4-win32.zip)-Administrative tools
Download
Https://www.php1.cn //>
[Mysql Server 4.1.11 installation tutorial]
========================================================== ========================================================
1. run the MYSQL Server 4.1 installation package

2. click (Change ..) to select the installation path. we recommend that you do not install the C drive!

3. I chose to install it in the D: \ Mysql \ directory, and then click OK to go to the next installation step.

4. after selecting the installation path, click Next> to proceed to the Next step!

5. click Install to start installation.

6. check the installation progress!

7. select Skip Sign-Up and click Next> continue installation!

8. here we have installed it. after selecting Configure the MySQL Server now
Click Finish to configure Mysql.

9. go to the Mysql configuration page!

10. select Detailed Configuration and click Next> Next!

11. select Server Machine and click Next> continue!

12. select Multifunctional Database and click Next to continue!

13. by default, this step allows you to choose the location where your database files are stored!

14. select Online Transaction Processing (OLTP) and click Next> continue!

15. for example, continue Next>

16. Select language support! The default value is Standard Character Set.

17. remember to select the Include Bin Directory In Windows Path option and continue

18. for example, enter the password and continue Next>

19. click Execute to complete the configuration and start the MYSQL service!

20. click Finish to complete the installation of your Mysql!

[Recover the backup of the cAthena Mysql database]
========================================================== ========================================================
Copy the ragnarok directory you just backed up to the directory of your Mysql database to complete the Mysql version upgrade.
[Install MySQL Control Center to manage Mysql data services]

========================================================== ========================================================
We first install mysqlcc-0.9.4-win32.zip, presumably install everyone
Yes. I will not describe it here. let's take a look at the MySQL Control Center
To configure and manage the Mysql database!
1. open MySQL Control Center and we can see an English interface. next we will set
Language Pack, find Options and click the General Ctrl + 0 option, as shown in figure

2. select the Language option, select the Simplified Chinese option, and then Apply it!
After the application, you need to turn off the MySQL Control Center and then open it. you can see it, right?
Not a Chinese interface we are familiar!

3. let's take a look at how to use MySQL Control Center to manage our MYSQL
First, create a service, such! Set your own password.
Ask me how much it is! The password you set when installing MYSQL 4.1.11! As shown in
Write, and click add!

4. next we will add a new root administrator. someone will ask if there is not already one.
Why do we need to add another one? let me explain why we need to add another one.
Mysql Admin User, which is installed by default in mysql 4.0
Four Mysql Admin User accounts!
----------------------------------------------------------
Root @ % root @ localhost
@ %
@ % Localhost
-----------------------------------------------------------
Some may ask, what are the functions of so many accounts? let's talk about
MYSQL account principle. we can see the comparison between root @ % and root @ localhost accounts.
Is it different? of course, the usage is also different. when we set a Mysql connection
These two items are (Server) (User); Server is the IP address of your Mysql Server
Or the domain name or machine name. The User is the account connecting to the SQL database, as shown in the following table.
-----------------------------------------------------------
Account @ server address
-----------------------------------------------------------
Root @ % root @ localhost
-----------------------------------------------------------
Guan Jian lies in the server address. @ % indicates that any address can be connected. @ localhost
It indicates that you can only use localhost as the local connection address.
Only one root @ localhost account is installed. Mysql 4.1.11
Security enhancement, hey ~~
Assume that my MYSQL server is installed on the machine 192.168.0.100, if I only
Root @ localhost: I can only use localhost at 192.168.0.100.
To connect to the MYSQL database. if I have a root @ % account, I can
You can connect to the database with 127.0.0.1 \ 192.168.0.100, so sometimes we need
When connecting to other machines, we need to create an account ourselves!
For example, create a new Mysql Admin User account

5. enter the account information to be created, and add it!

6. Have you seen it? create a new mysql admin user account. of course.
You can also create other names, not necessarily Root, but different accounts.
Attach different permissions to the account ID. you need to know it later!

The above is the illustration of MYSQL installation and data upgrade _ php skills. For more information, please follow the PHP Chinese network (www.php1.cn )!