Operating system WinXP SP2
Download free installation version 33.8M
MD5: 7fc5d48687623b679dac5cfdceda596e
Decompression to the C: / file to change to the mysql installation, the end begins to use mysql1. Start the mysql service C: /mysql/winmysqladmin.exe Start Service When the green traffic light appears at the system tray, the service has been successfully launched 2. Stop MySQL service Right-click on the traffic light WIN NT - "Stop The Server red light indicates that the service has been successfully stopped 3. Yellow light indicates that the service is starting or stopping: If the firewall such as Tianwang is installed, it should be noted to allow mysql connection network 4. Put C : / MySQL / BIN Add to Environment Variable System Variable Path. 5. Connect to MySQL Enter CMD in the command line to open a DOS window format: mysql -h host address -u username -P user password Enter the Myql -uroot -P Enter (indicating the local mysql server with the root connection) prompts to enter the password just When you are installed, you have no password. You can successfully enter the welcome words and mysql> 6. Exit MySQL in mysql> After entering EXIT successfully exits Show Bye7.Mysqladmin -u User Name - Poji Password New Password 8. Add one User Grant SELECT, INSERT, UPDATE, DELETE ON *. * To test1 @ "%" Identified by "ABC"; (Number not less) GGRANT SELECT, IDENT, UPDATE, DELETE ON *. * To test2 @ localhost identified by " ABC "; GRANT SELECT, INSERT, UPDATE, DELETE ON *. * To Test3 @ localhost iDentified by" "