To operate the mysql client utility in the context of the root user. : MySQL « Command MySQL « SQL / MySQL

Home
SQL / MySQL
1.Aggregate Functions
2.Backup Load
3.Command MySQL
4.Cursor
5.Data Type
6.Database
7.Date Time
8.Engine
9.Event
10.Flow Control
11.FullText Search
12.Function
13.Geometric
14.I18N
15.Insert Delete Update
16.Join
17.Key
18.Math
19.Procedure Function
20.Regular Expression
21.Select Clause
22.String
23.Table Index
24.Transaction
25.Trigger
26.User Permission
27.View
28.Where Clause
29.XML
SQL / MySQL » Command MySQL » MySQL 
To operate the mysql client utility in the context of the root user.
        

mysql --user=root

   
    
    
    
    
    
    
    
  
Related examples in the same category
1.mysql Options
2.mysql Commands
3.Processing SQL Files with mysql
4.Change default-character-set for backup
5.Connect to the mysql database as the root user from the MySQL CLI
6.Connects the root account to the inventory database:
7.Connect to the MySQL database as root
8.Import a SQL-format dump file back into MySQL
9.If you dumped tables from a single database, you'll need to tell mysql which database to import them into
10.Verify whether the MySQL databases have been properly installed and configured.
11.Specify the user for mysql
12.Specify a database when you start the mysql utility
13.To invoke mysql interactively from the command line, specify any necessary connection parameters after the command name
14.Provide a database name to select that database as the default database
15.Restoring a Single Database
16.Restoring Several Databases
17.Restoring a Database
18.Recreate the database in interactive mode:
19.Connect to the sampdb database on the local host and on cobra.snake.net:
20.Telling mysql to Read Queries from a File
21.MySQL Server and Included Administrative Tools
22.Common Options of the MySQL Client Tools
23.Producing HTML Output
24.Producing XML Output
25.Using the mysql Client to Export Data
26.Launching mysql with the option --silent:
27.XML Exporting with mysql
28.Sign into the MySQL server as root
29.The options part of the mysql command line might be empty
30.To determine the version of a program, use the --version option.
31.To determine the options supported by any MySQL program, invoke the program with the --help option.
32.Try out the various communication protocols
33.Find out which options will be taken from option files by mysql, use this command
34.Specifying Queries on the Command Line
35.To run multiple queries with the -e option, separate them with semicolons:
36.Getting Server Metadata
37.Produce output in formats other than tab-delimited
38.The prompt command supports a number of options that allow you to display the mysql prompt in various ways.
39.To connect to a server running on some other machine, it's necessary to specify the hostname using an -h option.
40.In many cases, a given option has both a long and a short form.
41.Connect with the same options as the previous example, but using the corresponding short option forms:
42.Generating HTML Tables
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.