Entry

Database: MySql: Microsoft Windows How to start MySql server from the command line? [mysqld-nt.exe]

Jul 6th, 2008 13:19
Knud van Eeden, dman,

----------------------------------------------------------------------
--- Knud van Eeden --- 08 April 2005 - 08:32 pm ----------------------

Database: MySql: Microsoft Windows How to start MySql server from the 
command line? [mysqld-nt.exe]

MySql v4.x

---

Steps: Overview:

 1. -Open an MSDOS box

 2. -Change to your MySql 'bin' directory

 3. -Type the command (all on one line)

      start mysqld-nt.exe
      --defaults-file="<your MySql directory>\my.ini"

      the following is optional

      --basedir="<your MySql directory>"
      --datadir="<your MySql directory>\data\"
      --standalone

     1. -E.g. (all on one line)

        start mysqld-nt.exe
        --defaults-file="c:\program files\\mysql\mySQL_Server_4.1
\my.ini"

     2. -E.g. (all on one line)

        start mysqld-nt.exe
        --defaults-file="c:\program files\\mysql\mySQL_Server_4.1
\my.ini"
        --basedir="c:\program files\mysql\mySQL_Server_4.1\"
        --datadir="c:\program files\mysql\mySQL_Server_4.1\data\"
        --standalone

 4. -That will open a second MSDOS box (keep this open, as it is your
     database server running)

===

MySql v5.x

---

Steps: Overview:

 1. -Open an MSDOS box

 2. -Change to your MySql 'bin' directory

 3. -Type the command (all on one line)

      start mysqld-nt.exe
      --defaults-file="<your MySql directory>\my.ini"
      --user=<your user name>

      the following is optional

      --passsword=<your password>
      --basedir="<your MySql directory>"
      --datadir="<your MySql directory>\data\"
      --standalone

     1. -E.g. (all on one line, assumes blank password, does not prompt
               for a password)

        start mysqld-nt.exe
        --defaults-file="c:\program files\MySql\MySql server 5\my.ini"
        --user=root

     2. -E.g. (all on one line, with password, does not prompt for
               password)

        start mysqld-nt.exe
        --defaults-file="c:\program files\MySql\MySql server 5\my.ini"
        --user=yourusername
        --password=yourpassword

     3. -E.g. (all on one line, with password, prompts for
               password)

        start mysqld-nt.exe
        --defaults-file="c:\program files\MySql\MySql server 5\my.ini"
        --user=yourusername
        --password

     4. -E.g. (all on one line)

        start mysqld-nt.exe
        --defaults-file="c:\program files\MySql\MySql server 5\my.ini"
        --user=root
        --basedir="c:\program files\MySql\MySql server 5\"
        --datadir="c:\program files\MySql\MySql server 5\data\"
        --standalone

 4. -That will open a second MSDOS box (keep this open, as it is your
     database server running)

===

Internet: see also:

---

Database: Relational: MySql: Link: Overview: Can you give an overview 
of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35331/fid/52

----------------------------------------------------------------------