Jump to content

Archived

This topic is now archived and is closed to further replies.

alfie romeo

Bugger! - MYSQL Installation problem

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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)

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.