Invoking MySQL from the C:\> Promt in Windows 2000
Posted by MySQLNovice (MySQLNovice), 7 July 2003I tried connecting to the MySQL Server directly and still cannot do so. I've got MYSQL running, but need to make a new root user account so that I can enter a password and User name. I tried C:\ mysql to invoke it but the command isn't recognized as a valid commmnad. What command is used to invoke MySQL within windows 2000?
Posted by admin (Graham Ellis), 7 July 2003Did you accept all the defaults as you installed MySQL? If so, the executables will be in \mysql\bin ... thus, to run the MySQL program to try out a commection
In terms of setting up a root passowrd, use mysqladmin, for example:
c:\mysql\bin\mysqladmin -uroot password abc123
Posted by MySQLNovice (MySQLNovice), 8 July 2003I tried entering the code at the C:\> as you indicated and it still wont acept the command. Could simply uninstalling, redownload and reinstalling help?
Posted by admin (Graham Ellis), 8 July 2003Rather than re-install, can I suggest you search for the files mysql.exe, mysqladmin.exe, etc, using the operating system tools; my guess is that you'll find them on some other directory path which you'll then be able to use. Uninstalling and re-installing might leave you exactly back where you were, and there's the potential for old stuff to not get properly cleaned out as well. OK - if all else fails you may have to re-install, but all else hasn't failed yet
Posted by MySQLNovice (MySQLNovice), 9 July 2003Ok-I've verified mysql.exe and mysqladmin.exe.
I've got two other files mysqladmin.exe and winmysqladim.exe. (all of the files are in C:\mysql\bin)
Posted by admin (Graham Ellis), 9 July 2003Problem sorted, then? You can contact the MySQL daemon from the command line, set up password, check that it's working ....
Posted by MySQLNovice (MySQLNovice), 10 July 2003How do I do that? Please remeber I'm an absolute beginner with MySQL.
Posted by MySQLNovice (MySQLNovice), 10 July 2003I took a shot in the dark and entered mysql\bin\mysql.exe at the C:\> and got this:
Welcome to the mysql monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.13-nt.
I now have a mysql> prompt. I guess I've invoked it...
Posted by admin (Graham Ellis), 10 July 2003Yep, now you can start experimenting with some SQL commands, creating tables, etc. You might find at first that you get a lot of error messages - SQL commands have to be much more exactly correct (right words, right quotes, right commas) than does English.
Tip - when you get on to longer commands, write them into a plain text file with notepad, and save that text file. Then invoke mysql with
on the end of it and it should run all the commands in the file. Any errors, correct the text file and re-run - no need to retype!
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: firstname.lastname@example.org • WEB: http://www.wellho.net • SKYPE: wellho