Logo

Para ver las diferencias de SQL entre distintas BD [MySQL | Oracle | SQL Server | DB2 | Access | Postgres]
A Gentle Introduction to SQL

Apache Web Server: PHP, MySQL, Perl, SSL - Windows 2000/XP, Linux - DeveloperSide.NET

DeveloperSide.NET
Your source for in-depth server-side information. Updated Daily

Building a Web Server, a Step-by-Step Instruction Guide
Binary Install -- MySQL 4.0.20 for Windows 2000/XP

___________
Requirements
This MySQL package comes pre-built.

________
Download
Home : http://www.mysql.com/
Package(win32 binary, non-installer version) : http://dev.mysql.com/downloads/mysql/4.0.html

_______________
Our Configuration
Install to : :\www\mysql

_____
Setup
Unpack as :\www\mysql-4.0.20
Rename directory :\www\mysql-4.0.20 to :\www\mysql
Copy your choice of mysql\my-xxx.cnf (my-medium.cnf) to your %SYSTEMROOT% directory (C:\WINNT)
[note that .cnf file extensions are invisible, by default, on Windows 2000/XP]
Rename file %SYSTEMROOT%\my-xxx.cnf to my.ini
Edit %SYSTEMROOT%\my.ini
Edit and uncomment basedir = :/www/mysql/
Edit and uncomment datadir = :/www/mysql/data/

___________________
MySQL Server Binaries
MySQL comes with several server binaries to select from, each containing different feature sets.

mysqld.exe: Compiled with full debugging and automatic memory allocation checking, symbolic links, and InnoDB and BDB transactional tables.
mysqld-opt.exe: Optimised binary with InnoDB transactional tables.
mysqld-nt.exe: Optimised binary for NT/2000/XP with support for named pipes.
mysqld-max.exe: Optimised binary with support for symbolic links, and InnoDB and BDB transactional tables.
mysqld-max-nt.exe: Optimised binary for NT/2000/XP with support for symbolic links, InnoDB and BDB transactional tables, and named pipes.

_______
Startup
MySQL can be installed as a Service or started as a Standalone Console.
Install the MySQL process as a Service.
[Default] Listen on all interfaces (0.0.0.0), and start automatically after a reboot
:\www\mysql\bin> mysqld-max-nt --install
Listen on all interfaces (0.0.0.0), manual start only
:\www\mysql\bin> mysqld-max-nt --install-manual
Listen on loopback only (127.0.0.1)
Add bind-address=127.0.0.1 to section [mysqld] of my.ini
Don't allow connection with TCP/IP
Add skip-networking to section [mysqld] of my.ini
Enable support for named pipes
Add enable-named-pipe to section [mysqld] of my.ini
Start the MySQL Service.
:\> NET START MySQL
Start MySQL as a Standalone Console.
:\www\mysql\bin> mysqld-max-nt --standalone --console
[add --bind-address=127.0.0.1 and/or --log-warnings to the end]

_______
Cleanup
Create a password for the 'root' mysql account...
:\www\mysql\bin> mysqladmin -u root password new-password
Delete all insecure users...
Access the MySQL prompt...
:\www\mysql\bin> mysql -u root -p
[note that there is no space between '-p' and 'password', and that '<>' is not typed]
Display all accounts...
mysql> SELECT User, Host, Password FROM mysql.user;
Select the 'mysql' database...
mysql> USE mysql;
Delete all initial accounts, except 'root@localhost'...
mysql> DELETE FROM mysql.user WHERE User = '' OR Host = '%';
mysql> DELETE FROM mysql.db WHERE User = '';
mysql> FLUSH PRIVILEGES;
Exit.
mysql> quit;

_____________
Running MySQL
Enter the command-line interface.
:\www\mysql\bin> mysql -u root -p
[note that there is no space between '-p' and 'password', and that '<>' is not typed]
Shutdown the MySQL Service.
:\www\mysql\bin> mysqladmin -u root -p shutdown
[note that there is no space between '-p' and 'password', and that '<>' is not typed]
Uninstall the MySQL Service.
:\www\mysql\bin> mysqld-max-nt --remove
Shutdown the Standalone Console MySQL process.
Ctrl-C under the cmd.exe windows it was started from

____
Help
Display the command-line interface options.
:\www\mysql\bin> mysql --help
Display mysql-max-nt options.
:\www\mysql\bin> mysqld-max-nt --help
Display MySQL version information.
:\www\mysql\bin> mysqladmin -V
See what values a running MySQL server is using.
:\www\mysql\bin> mysqladmin -u -p variables
Display information.
:\www\mysql\bin> mysqladmin -u -p version status proc

________________________________
Log non-critical warnings to the log file.
Standalone Console : Add --log-warnings to the MySQL standalone console line
Service : Add log-warnings to section [mysqld] of my.ini

Computer Security Books - /database-security/ books

EFECTO 2000: "VERBATIM S/C 50 0,26 € 0,23 € 0,26 € 0,23 € 0,24 € 0,21 €"
TELEFONOS Y DIRECCIONES

TIENDA : 902501549

HORARIO DE TIENDA : DE LUNES A VIERNES DE 10:00 A 14: 00 Y DE 16:30 A 20:00

SABADOS DE 10:00 A 14:00 C/ VALDERRIBAS Nº 47 28007 MADRID

Cuadenos de estrategia del Ministerio de Defensa