Biodata Erna Selviyanti

Mengenai Saya

Foto saya
Nana Imut,,,asik,,,senang punya teman banyak, suka banget ma kucing hitam ^^

Senin, 04 Juli 2011

Cara cari MySQL lewat cmd (biar nana ga lupa)

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Erna>cd "\Program Files"

C:\Program Files>cd "MySQL\MySQL Server 5.5"

C:\Program Files\MySQL\MySQL Server 5.5>dir
Volume in drive C has no label.
Volume Serial Number is B04F-69D0

Directory of C:\Program Files\MySQL\MySQL Server 5.5

04/07/2011 10:23 .
04/07/2011 10:23 ..
04/07/2011 09:21 bin
04/07/2011 09:21 data
04/07/2011 09:21 include
04/07/2011 09:22 lib
01/07/2011 16:00 8.918 my 2011-05-04 1535.ini.bak
01/07/2011 16:02 8.918 my 2011-07-01 1600.ini.bak
01/07/2011 16:03 8.918 my 2011-07-01 1602.ini.bak
01/07/2011 16:05 8.918 my 2011-07-01 1603.ini.bak
01/07/2011 16:07 8.918 my 2011-07-01 1605.ini.bak
01/07/2011 16:10 8.918 my 2011-07-01 1607.ini.bak
01/07/2011 16:13 8.918 my 2011-07-01 1610.ini.bak
01/07/2011 16:18 8.918 my 2011-07-01 1613.ini.bak
04/07/2011 09:06 8.918 my 2011-07-01 1618.ini.bak
04/07/2011 09:09 8.920 my 2011-07-04 0906.ini.bak
04/07/2011 09:22 8.920 my 2011-07-04 0909.ini.bak
04/07/2011 09:32 8.918 my 2011-07-04 0922.ini.bak
04/07/2011 10:21 8.918 my 2011-07-04 0932.ini.bak
04/07/2011 10:23 8.918 my 2011-07-04 1021.ini.bak
21/01/2011 05:05 4.829 my-huge.ini
21/01/2011 05:05 20.238 my-innodb-heavy-4G.ini
21/01/2011 05:05 4.803 my-large.ini
21/01/2011 05:05 4.812 my-medium.ini
21/01/2011 05:05 2.921 my-small.ini
26/08/2010 14:56 13.128 my-template.ini
04/07/2011 10:23 8.918 my.ini
04/07/2011 09:22 mysql-test
04/07/2011 09:22 scripts
04/07/2011 09:22 share
21 File(s) 184.505 bytes
9 Dir(s) 80.722.247.680 bytes free

C:\Program Files\MySQL\MySQL Server 5.5>cdbin
'cdbin' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MySQL\MySQL Server 5.5>cdbin
'cdbin' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MySQL\MySQL Server 5.5>dir
Volume in drive C has no label.
Volume Serial Number is B04F-69D0

Directory of C:\Program Files\MySQL\MySQL Server 5.5

04/07/2011 10:23 .
04/07/2011 10:23 ..
04/07/2011 09:21 bin
04/07/2011 09:21 data
04/07/2011 09:21 include
04/07/2011 09:22 lib
01/07/2011 16:00 8.918 my 2011-05-04 1535.ini.bak
01/07/2011 16:02 8.918 my 2011-07-01 1600.ini.bak
01/07/2011 16:03 8.918 my 2011-07-01 1602.ini.bak
01/07/2011 16:05 8.918 my 2011-07-01 1603.ini.bak
01/07/2011 16:07 8.918 my 2011-07-01 1605.ini.bak
01/07/2011 16:10 8.918 my 2011-07-01 1607.ini.bak
01/07/2011 16:13 8.918 my 2011-07-01 1610.ini.bak
01/07/2011 16:18 8.918 my 2011-07-01 1613.ini.bak
04/07/2011 09:06 8.918 my 2011-07-01 1618.ini.bak
04/07/2011 09:09 8.920 my 2011-07-04 0906.ini.bak
04/07/2011 09:22 8.920 my 2011-07-04 0909.ini.bak
04/07/2011 09:32 8.918 my 2011-07-04 0922.ini.bak
04/07/2011 10:21 8.918 my 2011-07-04 0932.ini.bak
04/07/2011 10:23 8.918 my 2011-07-04 1021.ini.bak
21/01/2011 05:05 4.829 my-huge.ini
21/01/2011 05:05 20.238 my-innodb-heavy-4G.ini
21/01/2011 05:05 4.803 my-large.ini
21/01/2011 05:05 4.812 my-medium.ini
21/01/2011 05:05 2.921 my-small.ini
26/08/2010 14:56 13.128 my-template.ini
04/07/2011 10:23 8.918 my.ini
04/07/2011 09:22 mysql-test
04/07/2011 09:22 scripts
04/07/2011 09:22 share
21 File(s) 184.505 bytes
9 Dir(s) 80.722.247.680 bytes free

C:\Program Files\MySQL\MySQL Server 5.5>dir
Volume in drive C has no label.
Volume Serial Number is B04F-69D0

Directory of C:\Program Files\MySQL\MySQL Server 5.5

04/07/2011 10:23 .
04/07/2011 10:23 ..
04/07/2011 09:21 bin
04/07/2011 09:21 data
04/07/2011 09:21 include
04/07/2011 09:22 lib
01/07/2011 16:00 8.918 my 2011-05-04 1535.ini.bak
01/07/2011 16:02 8.918 my 2011-07-01 1600.ini.bak
01/07/2011 16:03 8.918 my 2011-07-01 1602.ini.bak
01/07/2011 16:05 8.918 my 2011-07-01 1603.ini.bak
01/07/2011 16:07 8.918 my 2011-07-01 1605.ini.bak
01/07/2011 16:10 8.918 my 2011-07-01 1607.ini.bak
01/07/2011 16:13 8.918 my 2011-07-01 1610.ini.bak
01/07/2011 16:18 8.918 my 2011-07-01 1613.ini.bak
04/07/2011 09:06 8.918 my 2011-07-01 1618.ini.bak
04/07/2011 09:09 8.920 my 2011-07-04 0906.ini.bak
04/07/2011 09:22 8.920 my 2011-07-04 0909.ini.bak
04/07/2011 09:32 8.918 my 2011-07-04 0922.ini.bak
04/07/2011 10:21 8.918 my 2011-07-04 0932.ini.bak
04/07/2011 10:23 8.918 my 2011-07-04 1021.ini.bak
21/01/2011 05:05 4.829 my-huge.ini
21/01/2011 05:05 20.238 my-innodb-heavy-4G.ini
21/01/2011 05:05 4.803 my-large.ini
21/01/2011 05:05 4.812 my-medium.ini
21/01/2011 05:05 2.921 my-small.ini
26/08/2010 14:56 13.128 my-template.ini
04/07/2011 10:23 8.918 my.ini
04/07/2011 09:22 mysql-test
04/07/2011 09:22 scripts
04/07/2011 09:22 share
21 File(s) 184.505 bytes
9 Dir(s) 80.722.247.680 bytes free

C:\Program Files\MySQL\MySQL Server 5.5>cd bin

C:\Program Files\MySQL\MySQL Server 5.5\bin>dir
Volume in drive C has no label.
Volume Serial Number is B04F-69D0

Directory of C:\Program Files\MySQL\MySQL Server 5.5\bin

04/07/2011 09:21 .
04/07/2011 09:21 ..
04/07/2011 09:21 debug
21/01/2011 05:15 146.944 echo.exe
21/01/2011 05:15 1.306.624 echo.pdb
21/01/2011 05:18 3.847.168 myisamchk.exe
21/01/2011 05:18 4.476.928 myisamchk.pdb
21/01/2011 05:18 3.724.288 myisamlog.exe
21/01/2011 05:18 4.173.824 myisamlog.pdb
21/01/2011 05:18 3.763.712 myisampack.exe
21/01/2011 05:18 4.345.856 myisampack.pdb
21/01/2011 05:18 3.737.088 myisam_ftdump.exe
21/01/2011 05:18 4.222.976 myisam_ftdump.pdb
21/01/2011 05:18 4.094.464 mysql.exe
21/01/2011 05:18 5.894.144 mysql.pdb
21/01/2011 05:17 4.021.760 mysqladmin.exe
21/01/2011 05:17 5.664.768 mysqladmin.pdb
21/01/2011 05:18 4.122.112 mysqlbinlog.exe
21/01/2011 05:18 6.156.288 mysqlbinlog.pdb
21/01/2011 05:17 4.017.152 mysqlcheck.exe
21/01/2011 05:17 5.648.384 mysqlcheck.pdb
21/01/2011 05:10 13.498.368 mysqld-debug.exe
21/01/2011 05:17 8.141.824 mysqld.exe
21/01/2011 05:17 23.638.016 mysqld.pdb
21/01/2011 05:17 4.079.616 mysqldump.exe
21/01/2011 05:17 5.844.992 mysqldump.pdb
21/01/2011 05:05 7.562 mysqldumpslow.pl
21/01/2011 05:05 24.520 mysqld_multi.pl
21/01/2011 05:05 33.913 mysqlhotcopy.pl
21/01/2011 05:17 4.012.544 mysqlimport.exe
21/01/2011 05:17 5.681.152 mysqlimport.pdb
26/08/2010 14:56 2.973.600 MySQLInstanceConfig.exe
21/01/2011 05:17 4.012.544 mysqlshow.exe
21/01/2011 05:17 5.632.000 mysqlshow.pdb
21/01/2011 05:17 4.034.048 mysqlslap.exe
21/01/2011 05:17 5.779.456 mysqlslap.pdb
21/01/2011 05:17 6.402.048 mysqltest.pdb
21/01/2011 05:17 8.937.984 mysqltest_embedded.exe
21/01/2011 05:17 22.433.792 mysqltest_embedded.pdb
21/01/2011 05:18 9.187.328 mysql_client_test_embedded.exe
21/01/2011 05:18 22.499.328 mysql_client_test_embedded.pdb
21/01/2011 05:05 8.734 mysql_config.pl
21/01/2011 05:05 4.336 mysql_convert_table_format.pl
21/01/2011 05:05 9.399 mysql_secure_installation.pl
21/01/2011 05:17 3.430.912 mysql_tzinfo_to_sql.exe
21/01/2011 05:17 3.002.368 mysql_tzinfo_to_sql.pdb
21/01/2011 05:17 3.544.576 mysql_upgrade.exe
21/01/2011 05:17 3.248.128 mysql_upgrade.pdb
21/01/2011 05:18 3.452.416 my_print_defaults.exe
21/01/2011 05:18 3.092.480 my_print_defaults.pdb
21/01/2011 05:18 3.548.160 perror.exe
21/01/2011 05:18 3.297.280 perror.pdb
21/01/2011 05:18 3.441.664 replace.exe
21/01/2011 05:18 3.100.672 replace.pdb
21/01/2011 05:18 3.451.392 resolveip.exe
21/01/2011 05:18 3.092.480 resolveip.pdb
53 File(s) 269.944.112 bytes
3 Dir(s) 80.722.247.680 bytes free

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
O)

C:\Program Files\MySQL\MySQL Server 5.5\bin>cd ..

C:\Program Files\MySQL\MySQL Server 5.5>cd \

C:\>cd wamp\bin\mysql\mysql5.5.8\bin

C:\wamp\bin\mysql\mysql5.5.8\bin>dir
Volume in drive C has no label.
Volume Serial Number is B04F-69D0

Directory of C:\wamp\bin\mysql\mysql5.5.8\bin

04/07/2011 10:12 .
04/07/2011 10:12 ..
31/12/2010 08:39 146.944 echo.exe
31/12/2010 08:39 3.849.216 myisamchk.exe
31/12/2010 08:39 3.724.800 myisamlog.exe
31/12/2010 08:39 3.765.760 myisampack.exe
31/12/2010 08:39 3.737.600 myisam_ftdump.exe
31/12/2010 08:39 4.094.976 mysql.exe
31/12/2010 08:39 4.023.808 mysqladmin.exe
31/12/2010 08:39 4.122.624 mysqlbinlog.exe
31/12/2010 08:39 4.017.664 mysqlcheck.exe
31/12/2010 08:39 12.341.760 mysqld-debug.exe
31/12/2010 08:39 8.133.120 mysqld.exe
31/12/2010 08:39 4.079.104 mysqldump.exe
31/12/2010 08:39 6.795 mysqldumpslow.pl
31/12/2010 08:39 23.749 mysqld_multi.pl
31/12/2010 08:39 33.148 mysqlhotcopy.pl
31/12/2010 08:39 4.013.056 mysqlimport.exe
31/12/2010 08:39 4.013.056 mysqlshow.exe
31/12/2010 08:39 4.034.560 mysqlslap.exe
31/12/2010 08:39 4.232.704 mysqltest.exe
31/12/2010 08:40 8.930.304 mysqltest_embedded.exe
31/12/2010 08:39 4.440.064 mysql_client_test.exe
31/12/2010 08:39 9.180.672 mysql_client_test_embedded.exe
31/12/2010 08:39 8.734 mysql_config.pl
31/12/2010 08:39 4.336 mysql_convert_table_format.pl
31/12/2010 08:39 9.399 mysql_secure_installation.pl
31/12/2010 08:39 3.431.936 mysql_tzinfo_to_sql.exe
31/12/2010 08:39 3.544.576 mysql_upgrade.exe
31/12/2010 08:39 3.452.928 my_print_defaults.exe
31/12/2010 08:40 3.548.672 perror.exe
31/12/2010 08:40 3.443.712 replace.exe
31/12/2010 08:40 3.452.416 resolveip.exe
31 File(s) 115.842.193 bytes
2 Dir(s) 80.725.131.264 bytes free

C:\wamp\bin\mysql\mysql5.5.8\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.5.8-log MySQL Community Server (GPL)

Copyright (c) 2000, 2010, 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>

0 komentar: