Entry

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

May 2nd, 2008 21:40
dman, Knud van Eeden, http://sturly.com

----------------------------------------------------------------------
--- Knud van Eeden --- 08 April 2021 - 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
----------------------------------------------------------------------