Installation of mysql under Win2000
Summary
This article focuses on Mysql installation under Win2000 (2002-08-21 18:45:53)
By Wing, Source:
LinuxAid
1. Mysql Introduction MySQL is a relational database management system (RDBMS). It organizes and manages a lot of data well, which makes it easy to manage and get information through server-side scripting languages like PHP. MySQL is completely free, and it has won the favor of the majority of users with its height openness and high-speed growth. In this article, we will introduce you to the installation of mysql under Win2000. Second, download the required files first from http://www.mysql.com/downloads/mysql-3.23/mysql-3.23.29a-win.zip, unzip it Go to your local hard disk (we use my mysql_setup directory). Third, execute the installer and add it to the service to execute a c: /mysql_setup/setup.exe file, the installation process is simple, as long as you choose the installation path (we use my mysql directory) and the installation mode (simply complete installation However, only 20m). Then perform the following command in C: MySQL / BIN:
C: mysql / bin> mysqld-nt --install Now in your "Program -> Administrative Tools -> Service" should already be able to see the mysql service, its startup category is started from starting, and now restart your computer. Fourth, MySQL settings MySQL only allows authorized users to access and operate information stored in their databases. When MySQL is installed for the first time, it generates a user called "root", which can access all things without password. Your first task is to set your password for the root user. To set the password of the root user in MySQL, enter the following command (including quotation marks) in the bin subdirectory of the mysql directory:
Mysqladmin -u root password "Your New Password" To make sure Mysql accept this change, you must tell it to reload the list of authenticated users and passwords:
MySQLADMIN -U Root Reload If this command shows an error message telling you that you can't access it, don't worry, this only proves that the new password has taken effect. To test your new password, you can request the MySQL server to tell you about its current status:
MySQLADMIN -U ROOT -P status When prompted, enter a password. You will see some simple information that contains the current state of the service. -u root parameter tells the program You want to log in with "root" user. The -p parameter tells the program prompting you to enter your password before the connection. The Status parameter tells the program that you want to see the system status. If you need to close the MySQL server, you can use the following command.
MySQLADMIN -U root -p Shutdown 5. Log in to MySQL Login MySQL, you can execute the following command on the command line:
MySQL -H
-u
-p
You need
Change to your MySQL service is running on the host name or IP address of the computer. If you log in to MySQL on the same computer of the service, you can use the -h localhost directly.
It should be your MySQL username. This should be root for your own Mysql server.
If you enter everything, the MySQL client program will connect to the mysql server and return to you a mysql command line:
