MySQL

Installing MySQL 4.0.18.

1. If you have previously installed MySQL 3.23 and you want to install a new MySQL version do the following (for an upgrade read the documentation):
   
   
   • WARNING: THE FOLLOWING STEPS WILL COMPLETE REMOVE THE OLD MySQL INSTALLATION AND DATABASES. BE SURE IF YOU WANT TO DO THIS.
   • Stop the current server.
     Open a dos window and type: net stop mysql
   • Remove the previously installed mysql service.
     C:\..\mysql\bin>mysqld-nt --remove
     
   • Remove the old MySQL version:
     Start | Settings | Configuration Screen | Software | Select MySQL | Remove
   • Remove the old C:\..\mysql\ directory.
   
   
2. Download and unzip mysql-4.0.18-win.zip
   
   
3. Execute setup.exe to install MySQL Servers and Clients on your computer.
   
   
4. Select the mysql destination folder, e.g.: C:\Tools\mysql.
   
   
5. Select setup type: typical
   
   
6. After installation you can find the MySQL Reference Manual in ..\mysql\Docs\
   A more recent version of this document and other documents can be found at: http://www.mysql.com/documentation/
   
   The data directory can be found in ..\mysql\data.
   
   
7. Next step is to prepare the Windows MySQL Environment using the WinMySQLadmin tool.
   Execute file C:\..\mysql\bin>winmysqladmin.exe
   
   
   
   Enter a username and password. The username will be used as the default system administrator name, e.g.:
   User name = myname
   password = mysecret
   
   Note:
   WinMySQLadmin creates a c:\windows\my.ini configuration file and setup the MySQL service to start automatically when Windows starts.
   
   
8. The WinMySQLadmin window will disapper and a stoplight icon will appear in the system bar. Just right click on the icon and select "show me". The WinMySQLadmin window will be displayed.
   
   • Select "my.ini Setup" Tab
   • Check if Base Dir=C:/Tools/mysql
   • Press button: Pick-up and Edit my.ini" file
   • Verify if radio button mysqld-nt (see Note 1) is selected, otherwise select it.
   • Press button: Save Modifications
   • You should see:
     
     #This File was made using the WinMySQLAdmin 1.4 Tool
     #7-5-2004 17:19:30
     
     #Uncomment or Add only the keys that you know how works.
     #Read the MySQL Manual for instructions
     
     [mysqld]
     basedir=C:/Tools/mysql
     #bind-address=192.168.1.100
     datadir=C:/Tools/mysql/data
     #language=C:/Tools/mysql/share/your language directory
     #slow query log#=
     #tmpdir#=
     #port=3306
     #set-variable=key_buffer=16M
     [WinMySQLadmin]
     Server=C:/Tools/mysql/bin/mysqld-nt.exe
     user=myname
     password=mysecret
     
     
     
     
     
   You should see the following:
   
   
   
   Note:
   Here is a list of the different MySQL servers you can use:
   
   

   Binary	Description
   mysqld	Compiled with full debugging and automatic memory allocation checking, symbolic links, InnoDB and BDB tables.
   mysqld-opt	Optimized binary. From version 4.0 on, InnoDB is enabled. Before 4.0, this server includes no transactional table support.
   mysqld-nt	Optimized binary for Windows NT, 2000, and XP with support for named pipes.
   mysqld-max	Optimised binary with support for symbolic links, InnoDB and BDB tables.
   mysqld-max-nt	Like mysqld-max, but compiled with support for named pipes.

   
   
9. Do not close the WinMySQLadmin window yet.
   
   
10. Verify if the correct MySQL service is setup.
    In the Windows Services window you should see:
    Right click this service and select properties.
    The path to executable file should be: C:/Tools/mysql/bin/mysqld-nt.exe
    If this is NOT the case:
    
    
    • Right click on the WinMySQLadmin window.
      
      
      
      
    • Select Win NT | Stop the Service
    • Again right click | Select Win NT | Remove the Service
    • Again right click | Select Win NT | Install the Service
    • Again right click | Select Win NT | Start the Service
    • Now check if the correct MySQL service is setup.
    
    
    
11. Close the WinMySQLadmin window.
    
    
12. Start the command line MySQL monitor:
    C:\..\mysql\bin>mysql -u root
    
    You should see:
    
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 8 to server version: 4.0.18-nt
    
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    
13. The default privileges on Windows give all local users full privileges to all databases without specifying a password. To make MySQL more secure, you should set a password for all users and remove the row in the mysql.user table that has Host='localhost' and User=' '.
    You should also add a password for the root user. The following example starts by removing the anonymous user that has all privileges, then sets a root user password "mysecret":
    
    mysql> use mysql
    mysql> delete from user where host='localhost' and User='';
    mysql> quit
    C:\..\mysql\bin>mysqladmin reload
    C:\..\mysql\bin>mysqladmin -uroot password mysecret
    
    
14. An overview of a few commands which can be executed within directory C:\..\mysql\bin>:
    
    

    Command	Description
    mysqlshow -?	Displays the help of mysqlshow. This command shows the structure of a mysql database.
    mysqlshow -u<user> -p<password> <database>	Example: Display table names of a selected database. mysqlshow -uroot -pmysecret mobilefishdb
    mysqladmin -?	Displays the help of mysqladmin. This command executes the administration program for the mysqld daemon.
    mysqladmin -u<user> password <password>	Example: Set password "mysecret" for user root. mysqladmin -uroot password mysecret
    mysqladmin -u -p<old_password> password <new_password>	Example: Change password into "mynewsecret" for user root. mysqladmin -uroot -pmysecret password mynewsecret
    mysql -?	Displays the help of mysql. This command starts the command line MySQL monitor.
    mysql -u<user> -p<password>	Example: Starts the command line MySQL monitor. mysql -uroot -pmysecret