Bugger! - MYSQL Installation problem

[alfie romeo]

I am a novice and this is doing my head in. Have had a few problems installing this. Have wiped and reinstalled and that is what i think maybe the problem. Any ideas? This is the error message below

 

thanks

 

C:mysqlbin>mysqladmin -u root reload

 

mysqladmin: 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\'

[shivabharat]

humm

 

mysql options!!

 

-#, --debug=...       Output debug log. Often this is \'d:t:o,filename`

-f, --force           Don\'t ask for confirmation on drop database; with

                     multiple commands, continue even if an error occurs

-?, --help            Display this help and exit

--character-sets-dir=...

                     Set the character set directory

-C, --compress        Use compression in server/client protocol

-h, --host=#          Connect to host

-p, --password[=...]  Password to use when connecting to server

                     If password is not given it\'s asked from the tty

, --pipe              Use named pipes to connect to server

-P  --port=...        Port number to use for connection

-i, --sleep=sec       Execute commands again and again with a sleep between

-r, --relative        Show difference between current and previous values

                     when used with -i. Currently works only with

                     extended-status

-E, --vertical        Print output vertically. Is similar to --relative,

                     but prints output vertically.

-s, --silent          Silently exit if one can\'t connect to server

-S, --socket=...      Socket file to use for connection

-u, --user=#          User for login if not current user

-v, --verbose         Write more information

-V, --version         Output version information and exit

-w, --wait[=retries]  Wait and retry if connection is down

 

now to run the mysqladmin

 

got to mysql/bin/winmysqladmin.exe and run this

 

and u will see the mysql in the taskbar or the best way would be got o control panel service and run the mysql service

 

Hope this helps

[alfie romeo]

somehow, i\'ve managed to fix it. i don\'t know how!

 

winmysqladmin. what can it be used for? i see it shows the tables i\'ve created (i\'m working through a book) but can you add to the tables through it.

 

I think some kind of interface would be very good for mysql rather than the command prompt.

 

Also, what is telnet and SSH?

 

thanks

[shivabharat]

If u need a GUI based thing

 

use

 

http://www.webyog.com/sqlyog/

 

really nice tool

 

Telnet

thru telnet u can access someone else\'s computer

or

Telnet is a user command and an underlying TCP/IP protocol for accessing remote computers.

 

if u are unix or windows u can still use telnet to connect to anymachine and access there pc no matter what OS they use.

 

SSH --- Secure Shell

 

is unix based command interface to access remote PC

[alfie romeo]

So Telnet would be useful if i had a MYSQL DB on a remote server/host and wanted to make changes to the DB.

 

Is it a piece of software that you install?

 

Another question that you probably know shivabharat is:

 

If you build a MYSQL DB on your local machine (localhost), can you move it to a remote server? Which folders would you have to move to ensure it ran ok and that all the table and data stayed safe?

 

thanks again

[shivabharat]

If you build a MYSQL DB on your local machine (localhost), can you move it to a remote server

 

Now to do this

 

u can make a batch script i.e .sql

 

which u can run on any server when u run .sql it will create the DB , tables and data with it

 

Is it a piece of software that you install?

 

u dont have to install anything

 

goto command prompt and type telnet

 

and u will get the prompt

 

telnet> -o

to 172.16.16.90 (IP)

[alfie romeo]

u can make a batch script i.e .sql

 

i take it that info on doing this is available in a lot of books out there. I only have one at the moment, build your own database driven website using php and mysql by kevin yank. I\'m only on chapter 3 but i\'m so impatient for the answers!

 

thanks again