Personal mysql configuration command

Last Update:2015-11-24 Source: Internet

Author: User

Tags reserved

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

C:\WINDOWS\SYSTEM32>CD D:
D:\

C:\windows\system32>d:

D:\>CD mysql_5.6.24_winx6420151123

D:\mysql_5.6.24_winx6420151123>dir
The volume in drive D is software
The serial number of the volume is 0001-F4BC

Directory of D:\mysql_5.6.24_winx6420151123

2015-11-23 17:10 <DIR>.
2015-11-23 17:10 <DIR>.
2015-11-23 17:19 <DIR> mysql-5.6.24-winx64
2015-11-23 17:00 366,063,432 Mysql_5.6.24_winx64.zip
1 files 366,063,432 bytes
3 Directories 8,415,944,704 bytes available

D:\MYSQL_5.6.24_WINX6420151123>CD bin
The system could not find the path specified.

D:\mysql_5.6.24_winx6420151123>, ....
' ... ' is not an internal or external command, nor is it a running program
or batch file.

D:\MYSQL_5.6.24_WINX6420151123>CD.

D:\>CD mysql_5.6.24_winx6420151123

D:\mysql_5.6.24_winx6420151123>dir
The volume in drive D is software
The serial number of the volume is 0001-F4BC

Directory of D:\mysql_5.6.24_winx6420151123

D:\MYSQL_5.6.24_WINX6420151123>CD mysql-5.6.24-winx64

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64>dir
The volume in drive D is software
The serial number of the volume is 0001-F4BC

Directory of D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64

2015-11-23 17:19 <DIR>.
2015-11-23 17:19 <DIR>.
2015-11-23 17:11 <DIR> Bin
2015-03-25 17:34 17,987 COPYING
2015-11-23 17:11 <DIR> Data
2015-11-23 17:11 <DIR> Docs
2015-11-23 17:11 <DIR> include
2015-11-23 17:17 <DIR> Lib
2015-03-25 18:02 1,141 My-default.ini
2015-11-23 17:19 <DIR> Mysql-test
2015-03-25 17:34 2,496 README
2015-11-23 17:19 <DIR> Scripts
2015-11-23 17:19 <DIR> Share
2015-11-23 17:19 <DIR> Sql-bench
3 Files 21,624 bytes
11 Directories 8,415,932,416 bytes available

D:\MYSQL_5.6.24_WINX6420151123\MYSQL-5.6.24-WINX64>CD bin

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin>dir
The volume in drive D is software
The serial number of the volume is 0001-F4BC

Directory of D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin

2015-11-23 17:11 <DIR>.
2015-11-23 17:11 <DIR>.
2015-03-25 18:06 134,656 Echo.exe
2015-03-25 18:06 936,960 echo.pdb
2015-03-25 18:07 4,064,256 Innochecksum.exe
2015-03-25 18:07 3,075,072 innochecksum.pdb
2015-03-25 18:09 4,519,424 Myisamchk.exe
2015-03-25 18:09 4,180,992 myisamchk.pdb
2015-03-25 18:09 4,302,336 Myisamlog.exe
2015-03-25 18:09 3,640,320 myisamlog.pdb
2015-03-25 18:09 4,427,776 Myisampack.exe
2015-03-25 18:09 4,041,728 myisampack.pdb
2015-03-25 18:09 4,395,520 Myisam_ftdump.exe
2015-03-25 18:09 3,951,616 myisam_ftdump.pdb
2015-03-25 18:09 4,859,392 Mysql.exe
2015-03-25 18:09 5,819,392 mysql.pdb
2015-03-25 18:09 4,748,288 Mysqladmin.exe
2015-03-25 18:09 5,598,208 mysqladmin.pdb
2015-03-25 18:09 4,917,248 Mysqlbinlog.exe
2015-03-25 18:09 6,188,032 mysqlbinlog.pdb
2015-03-25 18:09 4,742,144 Mysqlcheck.exe
2015-03-25 18:09 5,557,248 mysqlcheck.pdb
2015-03-25 18:05 33,272,320 Mysqld-debug.exe
2015-03-25 18:05 35,539,968 mysqld-debug.pdb
2015-03-25 18:11 13,052,928 Mysqld.exe
2015-03-25 18:11 33,795,072 mysqld.pdb
2015-03-25 18:09 4,816,384 Mysqldump.exe
2015-03-25 18:09 5,712,896 mysqldump.pdb
2015-03-25 18:02 7,635 mysqldumpslow.pl
2015-03-25 18:02 27,732 mysqld_multi.pl
2015-03-25 18:02 36,098 mysqlhotcopy.pl
2015-03-25 18:08 4,736,000 Mysqlimport.exe
2015-03-25 18:08 5,565,440 mysqlimport.pdb
2015-03-25 18:08 4,736,000 Mysqlshow.exe
2015-03-25 18:08 5,540,864 mysqlshow.pdb
2015-03-25 18:08 4,762,112 Mysqlslap.exe
2015-03-25 18:08 5,663,744 mysqlslap.pdb
2015-03-25 18:08 5,042,688 Mysqltest.exe
2015-03-25 18:08 6,302,720 mysqltest.pdb
2015-03-25 18:11 14,016,000 Mysqltest_embedded.exe
2015-03-25 18:11 31,632,384 mysqltest_embedded.pdb
2015-03-25 18:09 5,234,688 Mysql_client_test.exe
2015-03-25 18:11 14,265,344 Mysql_client_test_embedded.exe
2015-03-25 18:11 31,607,808 mysql_client_test_embedded.pdb
2015-03-25 18:02 9,079 mysql_config.pl
2015-03-25 18:09 4,534,272 Mysql_config_editor.exe
2015-03-25 18:09 4,983,808 mysql_config_editor.pdb
2015-03-25 18:02 4,504 mysql_convert_table_format.pl
2015-03-25 18:11 13,870,080 Mysql_embedded.exe
2015-03-25 18:11 31,304,704 mysql_embedded.pdb
2015-03-25 18:09 4,074,496 Mysql_plugin.exe
2015-03-25 18:09 3,091,456 mysql_plugin.pdb
2015-03-25 18:02 10,518 mysql_secure_installation.pl
2015-03-25 18:07 3,951,104 Mysql_tzinfo_to_sql.exe
2015-03-25 18:07 2,690,048 mysql_tzinfo_to_sql.pdb
2015-03-25 18:09 4,224,000 Mysql_upgrade.exe
2015-03-25 18:09 3,189,760 mysql_upgrade.pdb
2015-03-25 18:07 4,055,552 My_print_defaults.exe
2015-03-25 18:07 2,993,152 my_print_defaults.pdb
2015-03-25 18:08 4,189,696 Perror.exe
2015-03-25 18:08 3,189,760 perror.pdb
2015-03-25 18:07 3,966,464 Replace.exe
2015-03-25 18:07 2,747,392 replace.pdb
2015-03-25 18:07 4,054,016 Resolveip.exe
2015-03-25 18:07 2,993,152 resolveip.pdb
63 Files 453,594,446 bytes
2 Directories 8,415,866,880 bytes available

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin>mysqld-install
Service successfully installed.

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin>

C:\users\administrator>net start MySQL
The MySQL service is starting:
The MySQL service has started successfully.

C:\users\administrator>mysql-u root-p
' MySQL ' is not an internal or external command, nor is it a running program
or batch file.

C:\users\administrator>d:

D:\>CD mysql_5.6.24_winx6420151123

D:\MYSQL_5.6.24_WINX6420151123>CD mysql-5.6.24-winx64

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64>dir
The volume in drive D is software
The serial number of the volume is 0001-F4BC

Directory of D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64

2015-11-23 17:19 <DIR>.
2015-11-23 17:19 <DIR>.
2015-11-23 17:11 <DIR> Bin
2015-03-25 17:34 17,987 COPYING
2015-11-24 19:26 <DIR> Data
2015-11-23 17:11 <DIR> Docs
2015-11-23 17:11 <DIR> include
2015-11-23 17:17 <DIR> Lib
2015-03-25 18:02 1,141 My-default.ini
2015-11-23 17:19 <DIR> Mysql-test
2015-03-25 17:34 2,496 README
2015-11-23 17:19 <DIR> Scripts
2015-11-23 17:19 <DIR> Share
2015-11-23 17:19 <DIR> Sql-bench
3 Files 21,624 bytes
11 Directories 8,415,244,288 bytes available

D:\MYSQL_5.6.24_WINX6420151123\MYSQL-5.6.24-WINX64>CD bin

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin>dir
The volume in drive D is software
The serial number of the volume is 0001-F4BC

Directory of D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin>mysql-u root-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 5
Server version:5.6.24 MySQL Community Server (GPL)

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

mysql> INSERT INTO Mysql.user (Host,user,password) VALUES ("localhost", "Nixinsheng", Password
("123"));
Query OK, 1 row affected, 3 warnings (0.00 sec)

mysql> flush Privileges;
Query OK, 0 rows Affected (0.00 sec)

Mysql> exit
Bye

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin>mysql-u nixinsheng-p
Enter Password: * * *
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 6
Server version:5.6.24 MySQL Community Server (GPL)

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Mysql> exit
Bye

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin>mysql-u root-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 7
Server version:5.6.24 MySQL Community Server (GPL)

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' 123 ');
Query OK, 0 rows Affected (0.00 sec)

Mysql> exit
Bye

D:\mysql_5.6.24_winx6420151123\mysql-5.6.24-winx64\bin>mysql-u root-p
Enter Password: * * *
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 8
Server version:5.6.24 MySQL Community Server (GPL)

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Mysql>

Personal mysql configuration command

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

A Free Trial That Lets You Build Big!

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

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

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

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More