|
|
| |
Installing MySQL on Windows |
 |
| |
Installing
MySQL:
First download a copy of MySQL's latest version. From
www.mysql.com/downloads
If no other copy of MySQL currently exist on the machine
just run the install program. Else stop the current version,
then run the install. If you are upgrading an older version
first check the MySQL's manual to see if any other requirements
are needed in the upgrade.
Once MySQL is installed you will most likely want to add
it as a service on the machine.
First make sure MySQL is not currently running.
C :\mysql\bin> mysqladmin -u
root shutdown
Then to add MySQL as a service run this command:
C :\mysql\bin> mysqld
--install
-or-
C :\mysql\bin> mysqld-max-nt
--install If
using NT, 2000 or XP
You can now start or stop MySQL from the service area
or by the following commands:
C:\> NET START MySQL
C:\> NET STOP MySQL |
| |
Logging
into MySQL:
C
:\mysql\bin> mysql -h host
-u user -p dbname
Enter password: *********** |
| |
Securing
MySQL:
Now that you have MySQL up and running you will want
to change the default privileges to make MySQL more
secure.
First login into the mysql database in MySQL. The mysql
database in MySQL holds all the user privilege information.
C:\mysql\bin> mysql -u root
mysql
Then remove all anonymous users.
mysql> DELETE FROM user WHERE
user=' ';
mysql> QUIT
Then reload the user privileges.
C:\mysql\bin> mysqladmin reload
or from inside mysql
mysql> FLUSH PRIVILEGES;
Last change the root password.
C:\mysql\bin> mysqladmin -u
root password your_password
C:\mysql\bin> mysqladmin -u root -h host_name password your_password
Replace host_name and your_password with your information.
|
| |
|
