MySQL installation + MySQL-front registration code

Source: Internet
Author: User
MySQL installation file can be downloaded directly to the http://www.mysql.com, get for win32.zip package, it is recommended to select 4.0.20d. It is not described in detail here. Download and obtain the MySQL for win32installation package, decompress it with winzip, and run setup.exe directly. Note that you should select an installation path. Of course, the installation path can be any. We recommend that you select the C:/MySQL directory. After the installation is complete, MySQL is complete. The default username is root and the password is blank. After installing MySQL, start- Program -Input cd c:/MySQL/bin at the command prompt and press enter to switch the directory to cd c:/MySQL/bin in C: /MySQL/bin> enter the mysqld-NT-install command at the command prompt, and press Enter. If the prompt "service successfully installed" appears, this indicates that you have successfully installed MYSQL as a Windows service. Click "start"> "program"> "Administrative Tools"> "service". You can see that MySQL has become one of many service projects, but it has not been started yet. So let's start it. You can choose one of the following methods to start the MySQL service: when the machine is restarted, it is automatically started. In the service window, select the MySQL service name, then, press the start button to start it. In the "command prompt character" window, enter the Net start MySQL command to start its Mysql Data installation. By default, the system generates a database named test. Generally, because the data needs to be accessed by the root user, we recommend that you create a new database and assign a new user to the database for security. Because MySQL Databases have fewer Default Client functions, database creation and user addition are not supported. Other tools such as MySQL-front include these features. You can download these tools to use them. Of course, you can also use the command line method described below to add users and databases. Log on to the database and enter the "command prompt character" window, enter cd c:/MySQL/bin, and press the Enter key to switch the directory to cd c: /MySQL/bin, enter the mysql-uroot-p command, and press enter to prompt you to enter the password. If you have just installed MySQL, the Super User Root has no password, therefore, press enter to enter mysql. The MySQL prompt is: mysql> Change Password C:/MySQL/bin. input at the prompt: format: mysqladmin-u username-P old Password new password example: Add a password ab12 to the root account. Run the following command: mysqladmin-uroot password ab12 to create the database format: Create Database database name; for example, create a new database shopex at the MySQL prompt: mysql> enter create database shopex; display the database format: show databases; note that databases is used instead of database to create a new user format: grant all privileges on database. * To username @ login host identified by "password"; for example, add a user Test password to 1234 so that he can only log on to localhost, in addition, you can perform all operations on the database shopex (localhost refers to the local host, that is, the host where the MySQL database is located). At the MySQL prompt: mysql> enter grant all privileges on shopex. * t O test @ localhost identified by "1234"; with the preceding operations, you create a new database named shopex and add a database named test to grant all operation permissions on the shopex database. Note: The preceding is just a simple MySQL Operation Command. For more details, see the MySQL operation instructions. The next installation depends on what you choose as your Web server. We recommend that you directly use IIS. Mysql-front registration code example/xeq9 + a4lczwqdudcq/fs verification + zookeeper/zke yaoiyo/dc33unbt6mtqx + export aaqawob + export whtg6 + export bo2wnmktgz/zookeeper =
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.