how to configure the mysql?

aoe123

Joined: 2011-06-24
Posts: 1
Posted: Fri, 2011-06-24 14:58

hi there,

i made a free mysql via db4free
ho do i have to configure now my mysql database?

thanks for helping me!

regards
aoe123

 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Fri, 2011-06-24 15:03

I suggest asking on the db4free forum.

--
dakanji.com

 
Hyacinth

Joined: 2011-06-27
Posts: 1
Posted: Mon, 2011-06-27 03:59

1, the installation wizard welcome screen

2, select the type of installation
Typical, Complete, Custom select "Custom" installation

3, the custom installation
By default, MySQL will be installed to C: \ Program Files \ MySQL \ MySQL Server 4.1 \ folder inside. Can point "Change" to change the path. (Recommended in the non-system disk installed, such as: D: \ Mysql)

4, ready to begin installation
Install - to install

5, create a MySQL.com account interface, if it is the first use of MySQL, choose "Create anew free MySQL.com accout". (Recommended option skip sign-up skipped)

7, installed interfaces

Note: There is a configuration wizard options (Configure the MySQL Server now), suggest checking immediately configure your MySQL.

9, the configuration type selection page. Select "Detailed configuration" (configuration details).

10, enter the type of service selection page. Select "Developer Machine" (developer machine), so do not take up a lot of system resources.

11, Database usage selection page. Choose "Multifunctional Database".

12, choose a location for the InnoDB data page. Do not change settings directly on the Installation Path to installation directory

13, select the number of MySQL connections at the same time. Choose "Manual Setting", set up according to their needs, appropriate setting.

14, configure MySQL in the TCP / IP communications environment in ports. Select the default 3306 port.

15, select the character set in MySQL.
Note that the choice will affect whether you can use Chinese in MySQL. Select the gb2312 character set to support Simplified Chinese, Traditional Chinese election big5.

16, set the Windows Service option.
Note, "Install As Windows Service" must be checked, which is to run MySQL as a Windows service. "Service Name" to use the default "MySQL" service name or your favorite (recommended default "MySQL"). Following the "Launch the MySQL Server automatically" must be checked, so when Windows starts, MySQL will automatically start the service, otherwise we should manually start MySQL. 10061 error occurs, the reason here.

17, set the root of the root account password.
"Modify Security Settings" is set to the root account password, enter the password you set. "Create An Anonymous Account" is to create an anonymous account, this will lead to unauthorized users unauthorized access to your database, there are security risks, it is recommended not to check.

18, MySQL Configuration Wizard will be based above all the settings you configure MySQL, MySQL to run in order to meet your needs.
Point "Execute" start the configuration, when there is "Service started successfully", the description of your configuration is complete, MySQL service started successfully.
Point "Finish" to complete the entire MySQL configuration is complete, the rest is to use MySQL client MySQL server, and then use.

19, check
Under the Windows 2k3 install MySQL, it would have automatically activated the service, and in the Start menu has a shortcut to their client connections.

20, through the Windows Service Manager view.
"Start" - "Run", type "services.msc", press Enter. Pop up the Windows Service Manager, then you can see the service called "mysql" service items, and the right marked "started."

21, opening and closing
Start "-" Run ", type" cmd ", Enter, open a command prompt interface
Start the mysql service: enter "net start mysql"
Stop mysql service: Enter the "net stop mysql"