Close start mysql command notes

2011-01-04  来源:本站原创  分类:PHP  人气:82 

In the windows below:
Start:
1.cd c: \ mysql \ bin
2.mysqld - console
Close:
1.cd c: \ mysql \ bin
2.mysqladmin-uroot shutdown
You can also:
Start:
1.cd c: \ mysql \ bin
2.net start mysql
Close:
1.cd c: \ mysql \ bin
2.net stop mysql
In linux under:
Use netstat-nlp view the status of mysql command line services:
Open. / Mysqld_safe &
Close mysqladmin-uroot shutdown
rpm install of the open service mysql start
Close service mysql stop
In the command line starts mysql, if without "- console", start, shut down the interface information is not displayed, but recorded in the installation directory under the data directory, the file name is usually hostname.err, through this file viewing mysql console information.

Execute the command:

1.
mysql / bin> mysql-u root-p test <c: / test.sql

2.
mysql / bin> mysql-u root-p enter password
mysql> use test
mysql> source c: / test.sql

Both windows and linux can use

File path is recommended / not \

相关文章
  • Close start mysql command notes 2011-01-04

    In the windows below: Start: 1.cd c: \ mysql \ bin 2.mysqld - console Close: 1.cd c: \ mysql \ bin 2.mysqladmin-uroot shutdown You can also: Start: 1.cd c: \ mysql \ bin 2.net start mysql Close: 1.cd c: \ mysql \ bin 2.net stop mysql In linux under:

  • High Performance MySQL study notes 2010-09-09

    http://hi.baidu.com/thinkinginlamp/blog/item/d6daa61e9f9acc11413417cc.html High Performance MySQL study notes: find out who holds the lock over the weekend re-re-read "high-performance MySQL", found that some knowledge of point of views will be

  • MySQL command line frequently used commands 2010-12-21

    Mysql commonly used commands show databases; display database create database name; create a database use databasename; Select database drop database name directly delete the database, do not remind the show tables; indicator describe tablename; show

  • How to change mysql command prompt information under 2010-04-06

    We often encounter this problem you also for your MySQL command mode, the previous information or tips: MySQL>, then how are we going to change under the mysql command prompt information? So what the current selected database, what the user is curren

  • How to change the mysql command prompt information under 2010-04-06

    We often encounter this problem you also for your MySQL command mode, the previous information or tips: MySQL>, then how are we going to change under the mysql command prompt information? So what the current selected database, what the user is curren

  • MySQL command Collection (change) 2010-04-13

    First, connect MYSQL. Format: mysql-h host address-u username-p password 1, connected to the machine on MYSQL. First, open the DOS window, then enter the directory mysql \ bin, then type the command mysql-u root-p, a carriage return after the prompt

  • mysql command Collection 2010-05-07

    Test environment: mysql 5.0.45 [Note: in mysql through mysql> SELECT VERSION (); to see the database version] Order: leo First, connect MYSQL. Format: mysql-h host address-u username-p password 1, connected to the machine on MYSQL. First, open the DO

  • mysql command under linux 2010-05-24

    mysql command under linux (2010-04-14 18:09:36) reproduced Tags: topics for one, to summarize: 1.linux start the mysql command: mysqladmin start / Ect / init.d / mysql start (in front of the installation path for the mysql) 2.linux next restart mysql

  • MYSQL command Daquan 2010-05-24

    Common MySQL command Daquan First, connect MySQL Format: mysql-h host address-u username-p password 1, Example 1: Connect to the machine on MYSQL. First, open the DOS window, then enter the directory mysqlbin, then type the command mysql-uroot-p, a c

  • Journey to the mysql command used MySql 2010-05-30

    First, connect MYSQL. Format: mysql-h host address-u username-p password 1, Example 1: Connect to the machine on MYSQL. First, open the DOS window, then enter the directory mysqlbin, then type the command mysql-uroot-p, a carriage return after the pr

  • mysql command line frequently used commands (rpm) 2010-07-30

    The first one, mysql service start and stop net stop mysql net start mysql The second measure, landing mysql Syntax is as follows: mysql-u username-p password type the command mysql-uroot-p, Enter your password after the prompt, enter 12345, then pre

  • MySQL command line to import. Exported. Sql files 2010-08-17

    MySQL import and export. Sql file, follow these steps: 1. MySQL command-line mode settings: Desktop -> My Computer -> Properties -> Environment Variables -> New -> PATH = "; path \ mysql \ bin;" one path for the MySQL installation

  • mysql command (turn) 2010-08-30

    1. Installation and configuration of MYSQL 2. Common mysql command-line command 1. Mysql start and stop start the MYSQL service net start mysql Stop service net stop mysql MYSQL 2. Netstat-na | findstr 3306 view was listening port, findstr to find th

  • MySQL command to export import data 2010-09-18

    Keywords: mysql command to export import data 1. Export the entire database mysqldump-u username-p database name> exported file name mysqldump-u wcnc-p smgp_apps_wcnc> wcnc.sql 2. Exporting a table mysqldump-u username-p database watches were> ex

  • MySQL command Daquan Classic Edition (switch) 2010-09-23

    The following article introduces the MySQL command Daquan, including the MySQL database of commonly used commands, modify the MySQL database root password and to grant the actual practical application of the introduction, the following is the descrip

  • linux server and configured to start the MYSQL command from the Start 2010-09-28

    linux server and configured to start the MYSQL command from the Start Keywords: self-starting configuration mysql / Usr / local / mysql / bin / mysqld_safe - user = mysql & Note MYSQL installation directory Configuration from the start By vi / etc /

  • (To) MySQL Command Guide 2010-12-06

    1, mysql start and stop services net stop mysql net start mysql 2, landing mysql Syntax is as follows: mysql-u username-p password type the command mysql-uroot-p, enter your password after the prompt, enter 12345, then you can enter into in the mysql

  • linux mysql command operation 2010-12-14

    1.linux start the mysql command: mysqladmin start / Ect / init.d / mysql start (in front of the mysql installation path) 2.linux next restart mysql command: mysqladmin restart / Ect / init.d / mysql restart (in front of the mysql installation path) 3

  • mysql command sets the encoding 2010-12-23

    mysql command set encoding: http://dev.mysql.com/doc/refman/5.0/en/charset-server.html spring to achieve upload and download: http://ajava.org/readbook/open/springhxjssj/15554.html oracle11g References: http://www.oracle.com/pls/db112/homepage oracle

  • linux install mysql, mysql command Failure 2011-01-04

    An installation steps From here to download the version you need (note to choose your operating system is 64-bit or 32-bit): Download Here only two kinds of judgments is a 64-bit linux or 32 approach: Command: file / bin / cat [Root @ app3 config] #