Install MySQL on Windows

Source: Internet
Author: User
Tags command line odbc mysql mysql client mysql in php and window mysql database
Mysql|window can run MySQL under Windows 95, Windows 98, or Windows NT. To do this, you must install the TCP/IP support environment, and the Winsock software must be at least version 2.
Two kinds of software can be installed under Windows:
• Standalone programs, such as those installed for UNIX (MYSQLD servers with programs such as M S y q L and Mysladmin).
· M y ODBC, which allows other programs (such as a C C e s) to communicate with MySQL servers in MySQL-driven ODBC.
Windows distribution contracts are all available as zip files from the MySQL site. To open such a file, just double-click it. If this does not work, you can use a program such as WinZip or Pkunzip to open it. Under the main distribution package:
mysqlw i n. ver s i o. zip full distribution Package (server and client).
w i n c l i e n T s-ver s i o n. z i p client software (MySQL, Mysqla d m i n, mysqldump, etc.). You can use this software if you do not want to run the server under Windows.
my o db c-ver s i o n-w i n 9 5. Z I P
My o db c-ver s i o n-n t. Z I P
Windows MYODBC (Windows 98) or Windows NT support environment.
MYSQLC L i e n t-ver s i o n-c y g I n-b 2 0. t a r.gz a MySQL client compiled using the Cygnus toolset. It includes MYSQLC, a MySQL client version with command-line history editing capabilities. If you install it, you need to Cygwinb19.dll from the C:\mysql\lib copy library file to the Windows system directory.

Install a client-only distribution or client/server distribution

If there is a winclients.version.zip distribution that contains only the client software, unlock it to produce a MySQL folder. Position this folder to C:\.
If you have a mysqlwin-version.zip distribution that contains both the server and the client, you should first open it. In the results folder, execute the Setup program to install MySQL in C:\mysql.
Select from the following servers:

Server Description
Mysqld Standard Server
Mysqld-opt Servers optimized for the Pentium processor
Mysqld-nt A server that can be installed as a service under Windows NT

You can run any server under NT, but the last one can run only under NT.
To run Mysqld or Mysqld-o p T, you can start the server as follows:
C:\> C:\mysql\bin\mysqld
C:\> c:\mysql\bin\mysqld-opt
To turn off this server, you can use the Mysqladmin utility:
C:\> c:\mysql\bin\mysqladmin-uroot shutdown
Under Windows NT, you can run mysqld-nt as a service:
C:\> c:\mysql\bin\mysqld-nt--install
If you start mysqld-n T in this way, you can specify them by placing them in the option file C: \ my.cnf. You cannot specify these parameters on the command line. When Mysqld-nt is running as a service, you can start or stop it by using the following commands:
c:\> net start MySQL c:\> net stop MySQL can use the Services control Manager utility in the Control Panel folder to start and stop the server, or from the command line Mysqladmin utility to stop the server:
C:\> c:\mysql\bin\mysqladmin-uroot shutdown
To run Mysqld-n T as a stand-alone program, call it as follows:
C:\> c:\mysql\bin\mysqld-nt--standalone
In this case, if you want, you can specify additional options after the--standalone option on the command line. To shut down this server, use Mysqla d i n.
If you have questions about running the server, see the "Installing MySQL" chapter of the MySQL Reference guide.
The default installation allows Mysqlroot users to connect without a password. For instructions on setting a password, see Chapter 11th.


Install MYODBC

Open the appropriate distribution package (one for Windows 95 or 9 8, one for Windows NT). Run the Setup program in the resulting folder to install the Mysqlodbc driver. The ODBC Control Panel is also installed, which you can use to configure this drive.
If an error occurs in the installation MYODBC, such as "Problems while copying MFC30." DLL, it means that MFC30.DLL is being used by an application. In this scenario, restart Windows in Safe mode, and then execute the Setup program.
When you run the ODBC Control Panel, you will see a window that allows you to set the data source name (D S N). Click the User DSN tab, and then click the Add button to appear with a window that lists the available data sources. Select the MySQL driver from the list and click the Finish button. You will see a window that enters the data source connection parameters. Fill in for hope to build
Set the parameters of the connection, and then click the OK button. For example, to use the most common server and user accounts in this book to set up the data source for the samp_db database, fill in the fields as follows:

Field name Field value
Windows DSN Name: samp_db
Mysqlhost (name or IP): Pit-viper.snake.net
Mysqldatabase Name: samp_db
User: Paul
Password: Secret

You should now be able to access the MySQL database using an ODBC-enabled program.

Installing the Perl DBI Support environment

From the ActiveState Web site (http://www. A c t i v e s t a T E. C o m/) get ActiveState Perl distribution and install it. Then, get and install the other Perl modules that are required. The P p m (Perl Package Manager) program is for this purpose. To find out which modules are already installed, you can use the following commands:
C:\> c:\perl\bin\ppm Info
Then use the appropriate commands listed below to install the required modules. Perhaps cgi.pm has been installed, and probably also need to install DBI-related packages.
c:\> c:\perl\bin\ppm Install Data-dumper
c:\> c:\perl\bin\ppm Install DBI
c:\> c:\perl\bin\ppm Install dbd-mysql c:\> c:\perl\bin\ppm install CGI

Installing PHP and Apache

Under Windows, PHP is executable independently, while the MySQL support environment is a DLL file. The best thing to do to complete the installation of PHP on Windows is to visit the following Web pages:
Http://www.umesd.k12.us/php/win32install.html



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.