Jump to content


Photo

Bugger! - MYSQL Installation problem


  • Please log in to reply
6 replies to this topic

#1 alfie romeo

alfie romeo
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 13 April 2003 - 09:54 AM

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

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 14 April 2003 - 02:37 PM

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
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#3 alfie romeo

alfie romeo
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 14 April 2003 - 04:17 PM

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

#4 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 14 April 2003 - 07:38 PM

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
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#5 alfie romeo

alfie romeo
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 14 April 2003 - 08:50 PM

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

#6 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 14 April 2003 - 09:35 PM

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)
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#7 alfie romeo

alfie romeo
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 15 April 2003 - 07:16 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users