1. First describe how to run the command line as an administrator and modify the administrator user password:
to run the command line as an administrator:Method 1: Start--All Programs--attachments--command prompt--right--run as Administrator Method 2: Start the Search box, enter Cmd.exe, and right-click the administrator to run the method 3:runas/user:
ADministrator cmd, then enter the password: wjb19900502,
Note Uppercase
to view all users:NET user to modify the password for username: (need to be under the Super Admin Command Line window) NET user username new password
To start the administrator user:Method 1: Right-click the computer, manage, user and user groups, right-click
ADministrator, attribute, disables the user's √ removal; Method 2: Administrator access to the command line: NET user
ADministrator/active:yes (or No)
2. The following is formally entered in the MySQL installation configuration:
(It doesn't seem like you need to configure the MySQL environment path, but it's best to configure it)To
Configure the environment path:Specify to the Bin directory
Modify My.ini:basedir= d:/mysql Installation Path #根目录datadir = D:/mysql installation path/data #数据文件存放目录
Registration system service/Installation service: (need to enter as Administrator)Mysqld-install (MySQL optional, indicates that a MySQL name is registered for the Windows service) or: mysqld--install mysql--defaults-file= "E:program Filesmysql-5.1.58-win32my.ini "To remove: Mysqld-remove (MySQL seems optional) (if the installation error, you can use this command to remove and reinstall) set to self-boot: sc config mysql Start=auto If the installation is wrong: SC delete MySQL can delete the MySQL service and reinstall
start MySQL:into the bin directory of the database, net start MySQL
go to the root interface of MySQL:Mysql-uroot or: Mysql-u root-p (must have a password after the-p,-u and root together or not okay) the first time to enter no password, direct carriage can be through
Change Password:1, >use myql;2, >update mysql.user set Password=password (' root ') where user= ' root '; 3, >flush privileges;4, > Exit After logging out, you'll need a new password when you log back in.
Chinese garbled problem:
Modify the My.ini file to find [mysqld] and add the following below:
Copy the code code as follows:
Character-set-server = UTF8 #mysql5.5 Start Default-character-set = UTF8 #mysql5.5 ago
Find [client] and add it below:
Copy the code code as follows:
Default-character-set = UTF8
MySQL Free install version configuration