Bob,
See below:
bob lambert wrote:
> Confusion. Can someone explain or provide a
> reference that explains all the different ways to
> run mysql. For example:
>
> mysqld
> mysql
> mysql-nt
> winmysqladmin
> mysqladmin
OK, here goes...
mysqld = the mysql server
mysql = the mysql client process
mysql-nt = the mysql server for Windows 'NT' o/s (2000, XP)
winmysqladmin = a windows based version of the mysqladmin utility
mysqladmin = a command-line utility that provides optiond for administering mysql
doe = a deer, a female deer...
>
> Why so many choices and when / how to decide which
> to use ?!!
OK, mysqld & mysqld-nt are the only server processes here, with the -nt version being NT specific.
The mysql client is what you implement to start an interactive session with the server from the command-line. So, the following command:
shell> mysql [options]
will give you a mysql> prompt (assuming you are an authorised user) and then you can SQL to your hearts connect. e.g:
mysql> SELECT questions FROM bob;
For details of [options], see:
http://dev.mysql.com/doc/mysql/en/mysql.html
Hopefully this also answers your last question below.
With regard to connecting via phpmyadmin the, assuming it's all set up with valid usernames & passwords etc - you should be fine, and yes you can work from the browser and a console at the same time.
>
> and if I already have mysql running from an xampp
> install/run (apache + mysql + phpmyadmin), and I
> am managing stuff with phpmyadmin, can I still
> open a console window and work with that same
> instance ? I don't think I can create a 2nd
> instance and I don't know how to get into an
> existing instance of mysql (get to the mysql>
> prompt).
>
> Thanks
> Bob the newbie
--
Nick Roper