zoukankan      html  css  js  c++  java
  • 个人mysql配置命令

    Microsoft Windows [版本 6.1.7601]
    版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

    C:Windowssystem32>cd D:
    D:

    C:Windowssystem32>D:

    D:>cd mysql_5.6.24_winx6420151123

    D:mysql_5.6.24_winx6420151123>dir
    驱动器 D 中的卷是 SoftWare
    卷的序列号是 0001-F4BC

    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 个文件 366,063,432 字节
    3 个目录 8,415,944,704 可用字节

    D:mysql_5.6.24_winx6420151123>cd bin
    系统找不到指定的路径。

    D:mysql_5.6.24_winx6420151123>..
    '..' 不是内部或外部命令,也不是可运行的程序
    或批处理文件。

    D:mysql_5.6.24_winx6420151123>cd ..

    D:>cd mysql_5.6.24_winx6420151123

    D:mysql_5.6.24_winx6420151123>dir
    驱动器 D 中的卷是 SoftWare
    卷的序列号是 0001-F4BC

    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 个文件 366,063,432 字节
    3 个目录 8,415,866,880 可用字节

    D:mysql_5.6.24_winx6420151123>cd mysql-5.6.24-winx64

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64>dir
    驱动器 D 中的卷是 SoftWare
    卷的序列号是 0001-F4BC

    D:mysql_5.6.24_winx6420151123mysql-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 个文件 21,624 字节
    11 个目录 8,415,932,416 可用字节

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64>cd bin

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64in>dir
    驱动器 D 中的卷是 SoftWare
    卷的序列号是 0001-F4BC

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64in 的目录

    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 个文件 453,594,446 字节
    2 个目录 8,415,866,880 可用字节

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64in>mysqld -install
    Service successfully installed.

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64in>



    Microsoft Windows [版本 6.1.7601]
    版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

    C:UsersAdministrator>net start mysql
    MySQL 服务正在启动 ..
    MySQL 服务已经启动成功。


    C:UsersAdministrator>mysql -u root -p
    'mysql' 不是内部或外部命令,也不是可运行的程序
    或批处理文件。

    C:UsersAdministrator>mysql -u root -p
    'mysql' 不是内部或外部命令,也不是可运行的程序
    或批处理文件。

    C:UsersAdministrator>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_winx6420151123mysql-5.6.24-winx64>dir
    驱动器 D 中的卷是 SoftWare
    卷的序列号是 0001-F4BC

    D:mysql_5.6.24_winx6420151123mysql-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 个文件 21,624 字节
    11 个目录 8,415,244,288 可用字节

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64>cd bin

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64in>dir
    驱动器 D 中的卷是 SoftWare
    卷的序列号是 0001-F4BC

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64in 的目录

    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 个文件 453,594,446 字节
    2 个目录 8,415,244,288 可用字节

    D:mysql_5.6.24_winx6420151123mysql-5.6.24-winx64in>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)

    Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be 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_winx6420151123mysql-5.6.24-winx64in>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)

    Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be 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_winx6420151123mysql-5.6.24-winx64in>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)

    Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be 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_winx6420151123mysql-5.6.24-winx64in>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)

    Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

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

    mysql>

    如果一件事情你觉得难的完不成,你可以把它分为若干步,并不断寻找合适的方法。最后你发现你会是个超人。不要给自己找麻烦,但遇到麻烦绝不怕,更不要退缩。 电工查找电路不通点的最快方法是:分段诊断排除,快速定位。你有什么启示吗? 求知若饥,虚心若愚。 当你对一个事情掌控不足的时候,你需要做的就是“梳理”,并制定相应的规章制度,并使资源各司其职。
  • 相关阅读:
    P1091,P1017
    二维ST表模板
    【ybtoj】【堆的应用】内存管理
    【ybtoj】【RMQ问题】降雨量
    【ybtoj】【RMQ问题】与众不同
    【ybtoj】【倍增问题】运输计划
    【ybtoj】【倍增问题】删边问题
    【ybtoj】【倍增问题】图上查询
    【ybtoj】【倍增问题】货车运输
    【ybtoj】【强连通分量】软件安装
  • 原文地址:https://www.cnblogs.com/wvqusrtg/p/4992685.html
Copyright ? 2011-2022 开发猿


http://www.vxiaotou.com