Getting to mysql bin directory on windows
Getting to mysql bin directory on windows
am 18.10.2006 01:25:42 von Gonzosez
I am trying to get to the bin directory of mysql 5 on windows, the name of
the mysql folder whereby I can cd to the bin directory is MySQL Server 5.0
and windows has shortened it to MYSQLS~1 however I cannot get to the
directory regardless of what I type, it keeps saying invalid directory, this
is what my dos prompt looks like:
C:\Program Files>cd mysql
C:\Program Files\MySQL>dir
Directory of C:\Program Files\MySQL
..
17/10/06 17:16 .
... 17/10/06 17:16 ..
MYSQLS~1 0 17/10/06 17:16 MySQL Server 5.0
0 file(s) 0 bytes
3 dir(s) 275.46 MB free
C:\Program Files\MySQL>cd mysql~1
Invalid directory
C:\Program Files\MySQL>cd mysqls~1
Invalid directory
C:\Program Files\MySQL>cd MYSQLS~1
Invalid directory
C:\Program Files\MySQL>cd MYSQLS~1
Re: Getting to mysql bin directory on windows
am 18.10.2006 02:19:48 von Rik
Nospam wrote:
> I am trying to get to the bin directory of mysql 5 on windows, the
> name of the mysql folder whereby I can cd to the bin directory is
> MySQL Server 5.0 and windows has shortened it to MYSQLS~1 however I
> cannot get to the directory regardless of what I type, it keeps
> saying invalid directory, this is what my dos prompt looks like:
>
>
> C:\Program Files>cd mysql
>
> C:\Program Files\MySQL>dir
>
>
> Directory of C:\Program Files\MySQL
>
> .
17/10/06 17:16 .
> .. 17/10/06 17:16 ..
> MYSQLS~1 0 17/10/06 17:16 MySQL Server 5.0
> 0 file(s) 0 bytes
> 3 dir(s) 275.46 MB free
>
> C:\Program Files\MySQL>cd mysql~1
> Invalid directory
>
> C:\Program Files\MySQL>cd mysqls~1
> Invalid directory
>
> C:\Program Files\MySQL>cd MYSQLS~1
> Invalid directory
>
> C:\Program Files\MySQL>cd MYSQLS~1
If you quote it, the full name will work, so:
cd "MySQL Server 5.0"
Else:
cd m (and then press the 'tab', here it's configured to autocomplete the
dir name).
Grtz,
--
Rik Wasmus
Re: Getting to mysql bin directory on windows
am 18.10.2006 03:49:44 von tito
You need to enter
cd mysqls~1.0
The command
dir /x
will display the 8dot3 names.
You may also be able to use the TAB key to complete the path you are
typing.
For example, type
cd my
then press the TAB key and it should hopefully complete to something
like
cd "MySQL Server 5.0"
Re: Getting to mysql bin directory on windows
am 18.10.2006 23:12:03 von Gonzosez
"Tito" wrote in message
news:1161136184.841770.150040@e3g2000cwe.googlegroups.com...
> You need to enter
> cd mysqls~1.0
>
> The command
> dir /x
> will display the 8dot3 names.
>
> You may also be able to use the TAB key to complete the path you are
> typing.
> For example, type
> cd my
> then press the TAB key and it should hopefully complete to something
> like
> cd "MySQL Server 5.0"
finally able to get to the directory, however, on trying to change the
password it says this:
C:\PROGRA~1\MYSQL\MYSQLS~1.0\BIN\MYSQLA~1.EXE: connect to server at
'localhost'
failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'
telent localhost 3306 says "could not open a connection to localhost"
and typing:
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld-nt
061018 21:17:10 [ERROR] Can't find messagefile 'C:\Program Files\MySQL\MySQL
Ser
ver 5.0\share\english\errmsg.sys'
061018 21:17:10 [ERROR] Aborting
What could be wrong?
Re: Getting to mysql bin directory on windows
am 18.10.2006 23:31:38 von Rik
Nospam wrote:
> finally able to get to the directory, however, on trying to change
> the password it says this:
>
> C:\PROGRA~1\MYSQL\MYSQLS~1.0\BIN\MYSQLA~1.EXE: connect to server at
> 'localhost'
> failed
> error: 'Can't connect to MySQL server on 'localhost' (10061)'
> Check that mysqld is running on localhost and that the port is 3306.
> You can check this by doing 'telnet localhost 3306'
>
> telent localhost 3306 says "could not open a connection to localhost"
>
> and typing:
>
> C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld-nt
> 061018 21:17:10 [ERROR] Can't find messagefile 'C:\Program
> Files\MySQL\MySQL Ser
> ver 5.0\share\english\errmsg.sys'
> 061018 21:17:10 [ERROR] Aborting
I'd suggest a visit to comp.databases.mysql, it has zero to do with PHP.
--
Grtz,
Rik Wasmus