My SQL Shutdown current server install mysql server

  • Slides: 5
Download presentation
My. SQL

My. SQL

Shutdown current server & install mysql server Microsoft(R) Windows DOS (C)Copyright Microsoft Corp 1990

Shutdown current server & install mysql server Microsoft(R) Windows DOS (C)Copyright Microsoft Corp 1990 -2001. C: MYSQLBIN>mysqladmin -u root shutdown C: MYSQLBIN>mysqld --install Service successfully installed. C: MYSQLBIN>

Starting and stopping mysql • C: MYSQLBIN>net START My. SQL • The My. SQL

Starting and stopping mysql • C: MYSQLBIN>net START My. SQL • The My. SQL service is starting. • The My. SQL service was started successfully. • C: MYSQLBIN>net stop mysql • The My. SQL service is stopping. • The My. SQL service was stopped successfully. • C: MYSQLBIN>

 • When run as a service, mysqld has no access to a console

• When run as a service, mysqld has no access to a console window, so no messages can be seen there. If mysqld doesn't start, check the error log to see whether the server wrote any messages there to indicate the cause of the problem. The error log is located in the `C: mysqldata' directory. It is the file with a suffix of `. err'. • When mysqld is running as a service, it can be stopped by using the Services utility, the command NET STOP My. SQL, or the command mysqladmin shutdown. If the service is running when Windows shuts down, Windows will stop the server automatically.

C: MYSQLBIN>mysql test Welcome to the My. SQL monitor. Commands end with ; or

C: MYSQLBIN>mysql test Welcome to the My. SQL monitor. Commands end with ; or g. Your My. SQL connection id is 3 to server version: 4. 0. 20 a-debug Type 'help; ' or 'h' for help. Type 'c' to clear the buffer. mysql> quit Bye