Software Outsourcing, Offshore Software Development, Offshore Outsourcing Services, IT Outsourcing, Offshore Development
MySQL manual Offshore Software Outsourcing and Programming, IT Outsourcing Offshore Software Development  
Call Us Today: 1-800-678-9001
Offshore Software Outsourcing and Programming, IT Outsourcing Offshore Software Development

Home / Technical Support / MySQL

Key Offerings:

B2B and B2C E-Business Solutions

Offshore Software Development Outsourcing

Strategic Consulting

Offshore Software Outsourcing

About ALTOROS: ALTOROS Systems is headquartered in Tampa, Florida and maintains an office near Boston, Massachusetts and technology development center in Belarus and Russia. ALTOROS specializes on providing value-added e-commerce and web-based software development and offshore software outsourcing services to emerging enterprises helping them successfully plan and implement business initiatives.

Contact Us for more information.

Node: Connecting, Next: Connection access, Prev: Privileges provided, Up: Privilege system
Connecting to the MySQL Server
 
MySQL client programs generally require that you specify connection parameters when you want to access a MySQL server: the host you want to connect to, your user name, and your password.  For example, the mysql client can be started like this (optional arguments are enclosed between [ and ]):
 
shell> mysql [-h host_name] [-u user_name] [-pyour_pass]
 
Alternate forms of the -h, -u, and -p options are --host=host_name, --user=user_name, and --password=your_pass.  Note that there is no space between -p or --password= and the password following it.
 
Note: Specifying a password on the command-line is not secure!  Any user on your system may then find out your password by typing a command like: ps auxww.  See Option files.
 
mysql uses default values for connection parameters that are missing from the command-line:
 
      ·      The default hostname is localhost.
 
      ·      The default user name is your Unix login name.
 
      ·      No password is supplied if -p is missing.
 
Thus, for a Unix user joe, the following commands are equivalent:
 
shell> mysql -h localhost -u joe
shell> mysql -h localhost
shell> mysql -u joe
shell> mysql
 
Other MySQL clients behave similarly.
 
On Unix systems, you can specify different default values to be used when you make a connection, so that you need not enter them on the command-line each time you invoke a client program.  This can be done in a couple of ways:
 
      ·      You can specify connection parameters in the [client] section of the .my.cnf configuration file in your home directory.  The relevant section of the file might look like this:
[client]
host=host_name
user=user_name
password=your_pass
 
 
      ·      You can specify connection parameters using environment variables.  The host can be specified for mysql using MYSQL_HOST.  The MySQL user name can be specified using USER (this is for Windows only).  The password can be specified using MYSQL_PWD (but this is insecure; see the next section).  See Environment variables.
Offshore Software Outsourcing company Russia Florida Massachusetts Boston Belarus, Offshore Software Development Services, Offshore Programming and IT OutsourcingOffshore Development, Programming  Services, Tampa FL Russia, E-commerce, Database, CRM, Financial Insurance Health Care Real EstateOffshore Software Development Services, Software Outsourcing Russia
HOME PAGE, Offshore Software Outsourcing Company, offshore IT outsourcing services, offshore 
software development Russia Massachusetts Florida New York CT VT RI software development