MySQL commands to stop and start services

2010-06-10  来源:本站原创  分类:Database  人气:165 

Win the next:

Start, Run

Stop: net stop mysql

Start: net start mysql

Premise has been installed as a windows service MYSQL

Open log

Open the my.ini file in the file, add the following text:

Writes

# Enter a name for the binary log. Otherwise a default name will be used.
# Log-bin =
# Enter a name for the query log file. Otherwise a default name will be used.
log = "D: / MySQL / MySQL Server 5.1/logs/query.log"
# Enter a name for the error log file. Otherwise a default name will be used.
log-error = "D: / MySQL / MySQL Server 5.1/logs/errorlog.log"
# Enter a name for the update log file. Otherwise a default name will be used.
log-update = "D: / MySQL / MySQL Server 5.1/logs/update.log"

View Log command:

mysql> show master status;

相关文章
  • MySQL commands to stop and start services 2010-06-10

    Win the next: Start, Run Stop: net stop mysql Start: net start mysql Premise has been installed as a windows service MYSQL Open log Open the my.ini file in the file, add the following text: Writes # Enter a name for the binary log. Otherwise a defaul

  • mysql commands in the interactivity 2010-08-06

    mysql> \ h For information about MySQL products and services, visit: http://www.mysql.com/ For developer information, including the MySQL Reference Manual, visit: http://dev.mysql.com/ To buy MySQL Enterprise support, training, or other products, vis

  • Mysql commands used in Linux ubuntu (rpm) 2011-05-24

    Mysql commands used in Linux 1.linux start the mysql command: mysqladmin start / Ect / init.d / mysql start (in front of the mysql installation path) 2.linux to restart the mysql command: mysqladmin restart / Ect / init.d / mysql restart (in front of

  • Random out a few mysql commands 2010-02-08

    When I use mysql with a few commands, clutter out, then it may be useful on some friends, although the Internet can find ---- First of all, enter the command line to mysql's bin directory, run mysql-u root-p, and then enter the password ---- If the p

  • MySql commands commonly used 2010-06-08

    MySQL basic operation of common operations, the following are MySQL5.0 tested by first description, remember the end of each command with; (semicolon) 1. Export the entire database mysqldump-u username-p - default-character-set = latin1 database name

  • Mysql commands used to switch 2011-06-23

    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, not to remind the show tables; display tables describe tablename;

  • Useful MySQL commands 2010-04-20

    Use Command Notes Display process show processlist; Pre-implementation of the statement explain YOURSQL Custom Export mysql -u -p -q -C --default-character-set=utf8 -e "lock tables account write; select account,gold_coin from account; unlock tables;&

  • mysql commands memoranda Collection 2010-05-22

    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 journey of mysql commands used 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 commands commonly used management 2010-06-27

    To enter the mysql: mysql -h192.168.1.101 -uroot -proot View all the tables in a database of information show table status from dbname \G; View information for a single table show table status from dbname like 'table1' \G; Using a database use dbname

  • Basic mysql commands 2010-12-23

    A, MySQL connect local database, user name "root", password "123" mysql-h localhost-u root-p123 Second, MySQL connect to a remote database (192.168.0.1), port "3306" user name "root", password "123" mysql-

  • Common MySQL Commands 2010-08-29

    1. Change the root password mysqladmin -u root -p Of the original password to modify the password for the password 2 See running show status; show variables; show processlist; 3 User Rights Management grant permissions on database objects to users gr

  • mysql commands used for viewing the database Table. field encoding 2010-10-22

    1 view all character sets supported by the database show character set; or show char set; (2) view the current status which includes of course the character sets status or \ s 3. View the system character set, including all the character sets show va

  • mysql commands used under ubuntu 2011-01-18

    1 Install the database, set a password for the root 2 log database: mysql-uroot-p, will be prompted for a password and successfully login. 3. Backup the database: not logged in the database in the case, $ mysqldump-uroot-p [database name]> / home / v

  • I use MySql commands 2010-05-07

    Increase in an index on column d, and so the column a primary key: ALTER TABLE t2 ADD INDEX (d), ADD PRIMARY KEY (a); Remove Column c: ALTER TABLE t2 DROP COLUMN c; Add a new AUTO_INCREMENT integer column named c: ALTER TABLE t2 ADD c INT UNSIGNED NO

  • mysql commands commonly used to collect 2011-04-22

    ① view the table of the specific attributes of each column: show full columns from table_name; ② TODO

  • mysql> command line commands you can use a variety of analytic (using the help or the help contents view more information) 2011-05-06

    mysql-u root-p Access to the mysql client application mysql, it can manage the database through Access the database, execute SQL statements and more. 1. Getting Help mysql> help or /? 2. Will mysql> enter the contents of the output to a file, use th

  • frequently used commands under linux mysql 2011-05-23

    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

  • Linux, mysql commonly used commands ubuntu (rpm) 2011-05-24

    Linux, mysql commonly used commands 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 fro

  • common commands under linux mysql 2011-05-23

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