alfie romeo Posted April 13, 2003 Share Posted April 13, 2003 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\' Quote Link to comment https://forums.phpfreaks.com/topic/341-bugger-mysql-installation-problem/ Share on other sites More sharing options...
shivabharat Posted April 14, 2003 Share Posted April 14, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/341-bugger-mysql-installation-problem/#findComment-1114 Share on other sites More sharing options...
alfie romeo Posted April 14, 2003 Author Share Posted April 14, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/341-bugger-mysql-installation-problem/#findComment-1118 Share on other sites More sharing options...
shivabharat Posted April 14, 2003 Share Posted April 14, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/341-bugger-mysql-installation-problem/#findComment-1128 Share on other sites More sharing options...
alfie romeo Posted April 14, 2003 Author Share Posted April 14, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/341-bugger-mysql-installation-problem/#findComment-1129 Share on other sites More sharing options...
shivabharat Posted April 14, 2003 Share Posted April 14, 2003 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) Quote Link to comment https://forums.phpfreaks.com/topic/341-bugger-mysql-installation-problem/#findComment-1130 Share on other sites More sharing options...
alfie romeo Posted April 15, 2003 Author Share Posted April 15, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/341-bugger-mysql-installation-problem/#findComment-1139 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.